Search code examples
advantage-database-server

How to check if logins are enabled?


So I can call sp_ModifyDatabase( 'LOGINS_DISABLED','False' ) to modify the state of LOGINS_DISABLED, but I can't find how you check the current state of the setting. Anyone know where that is?


Solution

  • The system.dictionary system table contains that information:

    SELECT Logins_Disabled FROM system.dictionary;