If not exists ( select * from master.dbo.syslogins where loginname = N'loginname') BEGIN USE master Exec sp_addlogin N'loginname' ,N'dbPWD ',N'DBNAME'
END USE dbname if not exists(select * from dbname.dbo.sysusers where name = N'loginname') BEGIN CREATE USER loginname FOR LOGIN loginname END EXEC sp_addrolemember N'db_datareader', N'loginname' EXEC sp_addrolemember N'db_datawriter', N'loginname'
BEGIN
USE master
Exec sp_addlogin N'loginname' ,N'dbPWD ',N'DBNAME'
END
USE dbname
if not exists(select * from dbname.dbo.sysusers where name = N'loginname')
BEGIN CREATE USER loginname FOR LOGIN loginname
END
EXEC sp_addrolemember N'db_datareader', N'loginname'
EXEC sp_addrolemember N'db_datawriter', N'loginname'