how to identify whether my sa account is disabled in sql server

Question

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

sql_lock SSCrazy Eights Points: 9373 More actions · Answer 1

SSCrazy Eights

Points: 9373

February 18, 2010 at 4:57 am

Within SSMS you will see a "red" down arrow.

Dathuraj Pasarge SSC Eights! Points: 807 More actions · Answer 2

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

sql_lock SSCrazy Eights Points: 9373 More actions · Answer 3

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