Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
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 Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Friday, March 4, 2016 6:03 AM
Points: 225, Visits: 354
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: Monday, September 12, 2016 7:43 AM
Points: 1,739, Visits: 1,913
Within SSMS you will see a "red" down arrow.
Post #867904
Posted Thursday, February 18, 2010 5:03 AM


SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Friday, March 4, 2016 6:03 AM
Points: 225, Visits: 354
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: Monday, September 12, 2016 7:43 AM
Points: 1,739, Visits: 1,913
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