都要加入域名:
use muonline
if not exists (select * from master.dbo.syslogins where loginname = N'WANGJINTAO\ASPNET')
exec sp_grantlogin N'WANGJINTAO\ASPNET'
exec sp_defaultdb N'WANGJINTAO\ASPNET', N'MuOnline'
exec sp_defaultlanguage N'WANGJINTAO\ASPNET', N'简体中文'
GOif not exists (select * from dbo.sysusers where name = N'WANGJINTAO\ASPNET' and uid < 16382)
EXEC sp_grantdbaccess N'WANGJINTAO\ASPNET', N'ASPNET'
GOexec sp_addrolemember N'db_owner', N'WANGJINTAO\ASPNET'
GO
use muonline
if not exists (select * from master.dbo.syslogins where loginname = N'WANGJINTAO\ASPNET')
exec sp_grantlogin N'WANGJINTAO\ASPNET'
exec sp_defaultdb N'WANGJINTAO\ASPNET', N'MuOnline'
exec sp_defaultlanguage N'WANGJINTAO\ASPNET', N'简体中文'
GOif not exists (select * from dbo.sysusers where name = N'WANGJINTAO\ASPNET' and uid < 16382)
EXEC sp_grantdbaccess N'WANGJINTAO\ASPNET', N'ASPNET'
GOexec sp_addrolemember N'db_owner', N'WANGJINTAO\ASPNET'
GO
use master
go
if not exists (select * from master.dbo.syslogins where loginname = N'WANGJINTAO\ASPNET')
exec sp_grantlogin N'WANGJINTAO\ASPNET'
exec sp_defaultdb N'WANGJINTAO\ASPNET', N'MuOnline'
exec sp_defaultlanguage N'WANGJINTAO\ASPNET', N'简体中文'
GO
use muonline
go
if not exists (select * from dbo.sysusers where name = N'WANGJINTAO\ASPNET' and uid < 16382)
EXEC sp_grantdbaccess N'WANGJINTAO\ASPNET', N'ASPNET'
GOexec sp_addrolemember N'db_owner', N'WANGJINTAO\ASPNET'
GO