use [ecdbsub] GO if not exists (select * from master.dbo.syslogins where loginname = N'ct21user') BEGIN declare @logindb nvarchar(132), @loginlang nvarchar(132) select @logindb = N'master', @loginlang = N'日本語' if @logindb is null or not exists (select * from master.dbo.sysdatabases where name = @logindb) select @logindb = N'master' if @loginlang is null or (not exists (select * from master.dbo.syslanguages where name = @loginlang) and @loginlang <> N'us_english') select @loginlang = @@language exec sp_addlogin N'ct21user', 'ct21', @logindb, @loginlang END GO if not exists (select * from dbo.sysusers where name = N'ct21user' and uid < 16382) EXEC sp_grantdbaccess N'ct21user', N'ct21user' GO exec sp_addrolemember N'db_owner', N'ct21user' GO if not exists (select * from master.dbo.syslogins where loginname = N'sfcsql') BEGIN declare @logindb nvarchar(132), @loginlang nvarchar(132) select @logindb = N'master', @loginlang = N'日本語' if @logindb is null or not exists (select * from master.dbo.sysdatabases where name = @logindb) select @logindb = N'master' if @loginlang is null or (not exists (select * from master.dbo.syslanguages where name = @loginlang) and @loginlang <> N'us_english') select @loginlang = @@language exec sp_addlogin N'sfcsql', 'sfc', @logindb, @loginlang END GO if not exists (select * from dbo.sysusers where name = N'sfcsql' and uid < 16382) EXEC sp_grantdbaccess N'sfcsql', N'sfcsql' GO exec sp_addrolemember N'db_owner', N'sfcsql' GO