if not exists (select * from master.dbo.syslogins where loginname = N'user') BEGIN declare @logindb nvarchar(132), @loginlang nvarchar(132) select @logindb = N'test', @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'user', null, @logindb, @loginlang END GOuse test goif not exists (select * from dbo.sysusers where name = N'user' and uid < 16382) EXEC sp_grantdbaccess N'user', N'user' GOexec sp_addrolemember N'db_owner', N'user' GO
EXEC sp_addlogin 'user', 'test', 'test'---password=test go
BEGIN
declare @logindb nvarchar(132), @loginlang nvarchar(132) select @logindb = N'test', @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'user', null, @logindb, @loginlang
END
GOuse test
goif not exists (select * from dbo.sysusers where name = N'user' and uid < 16382)
EXEC sp_grantdbaccess N'user', N'user'
GOexec sp_addrolemember N'db_owner', N'user'
GO
go