Code
use [Northwind]
if not exists (select * from master.dbo.syslogins where loginname=N'northwindUser')
begin
exec sp_addlogin 'northwindUser','north@wind1','Northwind'
exec sp_grantdbaccess 'northwindUser'
exec sp_addrolemember 'db_owner','northwindUser'
posted on
2009-11-24 09:51
静水流深
阅读(
419)
评论()
编辑
收藏
举报