check login exists for a specific database

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
Wed Apr 28 08:20:02 CDT 2004

You can use Exists on the Name field of Sysusers
"Priya" <anonymous@discussions.microsoft.com> wrote in message
news:0205F18B-F5F3-469B-B6D4-6988118DB032@microsoft.com...
> 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 advance
> Priya