check login exists for a specific database

[Guest]

Hi
How do I check whether a login exists for a particular database in MSDE

Code
SqlConnection objConn = new SqlConnection(strCon)
objConn.Open()
SqlCommand objCmd = new SqlCommand()
objCmd.Connection = objConn
//eg: if login 'priya' does not exist in database PRIYA how do i do it
objCmd.CommandText = @" EXEC sp_addlogin @loginame ='abb',@passwd ='abb',@defdb = 'ABB' EXEC sp_grantdbaccess N'abb', N'abb' EXEC sp_addrolemember N'db_owner', N'abb'"
objCmd.ExecuteNonQuery()

Thankx in advanc
Priya

 

[William Ryan eMVP]

You can use Exists on the Name field of Sysusers

Hi,
How do I check whether a login exists for a particular database in MSDE?

Code:
SqlConnection objConn = new SqlConnection(strCon);
objConn.Open();
SqlCommand objCmd = new SqlCommand();
objCmd.Connection = objConn;
//eg: if login 'priya' does not exist in database PRIYA how do i do it
objCmd.CommandText = @" EXEC sp_addlogin @loginame ='abb',@passwd

='abb',@defdb = 'ABB' EXEC sp_grantdbaccess N'abb', N'abb' EXEC
sp_addrolemember N'db_owner', N'abb'" ;