|
database
newsgroups
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
Verify a SQL Server 2000 loginI 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? |
|||||||||||||||||||||||