Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

how to identify whether my sa account is disabled in sql server Expand / Collapse
Author
Message
Posted Thursday, February 18, 2010 4:45 AM


SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Friday, April 17, 2015 12:17 AM
Points: 168, Visits: 307
Hi All,

how to identify whether my sa account is disabled in sql server. Is there any system sp or anything?

Thanks,
DR
Post #867900
Posted Thursday, February 18, 2010 4:57 AM
SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Friday, April 24, 2015 4:32 AM
Points: 1,640, Visits: 1,829
Within SSMS you will see a "red" down arrow.
Post #867904
Posted Thursday, February 18, 2010 5:03 AM


SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Friday, April 17, 2015 12:17 AM
Points: 168, Visits: 307
Thanks for the replay.

But I could not see that in SSMS 2000.

However what is way to enable it? I am having a prod sql server 2000 with SP4.

Thanks,
DR
Post #867909
Posted Thursday, February 18, 2010 5:11 AM
SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Friday, April 24, 2015 4:32 AM
Points: 1,640, Visits: 1,829
You have added the post to SQL 2005... Not there in SQL2k

Try ..

SELECT * FROM syslogins


From my memory i think there is a is_disabled column
Post #867915
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse