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 Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Monday, July 13, 2015 12:31 PM
Points: 218, Visits: 325
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 @ 2:18 AM
Points: 1,661, Visits: 1,843
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: Monday, July 13, 2015 12:31 PM
Points: 218, Visits: 325
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 @ 2:18 AM
Points: 1,661, Visits: 1,843
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