Thanks Gail,

That is certainly an option and you are correct, it would suffice. I just find it difficult to believe that SQL server provides no mechanism for the DBA...

Almost exclusively SQL logins.

I have been reading and see that for Windows Domain accounts sp_denylogin can be used, but I tried it and it does not work for SQL accounts.

I...

Thanks folks,

Sorry for posting in the wrong forum.

Well,

I think I may have just answered my own questions. I found the following table showing the bit values for the xstatus field in sysxlogins (source: aspfree.com[/url]):

[font="System"]Table 2-4 shows...