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 Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Saturday, April 5, 2014 1:58 AM
Points: 48, Visits: 198
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: Today @ 1:47 AM
Points: 1,586, Visits: 1,786
Within SSMS you will see a "red" down arrow.
Post #867904
Posted Thursday, February 18, 2010 5:03 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Saturday, April 5, 2014 1:58 AM
Points: 48, Visits: 198
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: Today @ 1:47 AM
Points: 1,586, Visits: 1,786
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