Home All Groups Group Topic Archive Search About

Verify a SQL Server 2000 login

Author
14 Dec 2006 1:08 AM
JayKon
I have two apps (with two databases) that have user accounts that are
identical to the base username in SQL Server (minus the domain) and I've
written a procedure that combines them into one list. Then I tried to use
sp_helpuser to verify that the user existed in SQL Server (and that the app
login is not guaranteed dead).

However, if a user is only in the 2nd database, I get a (bogus) error from
sp_helpuser.

Where can I go to verify a SQL Server 2000 login name?

AddThis Social Bookmark Button