【SQL开源代码栏目提醒】:网学会员为需要SQL开源代码的朋友们搜集整理了CreateDBLogin1.sql相关资料,希望对各位网友有所帮助!
USE [MSPetShop4]
if not exists (select * from master.dbo.syslogins where loginname = N'mspetshop')
BEGIN
exec sp_addlogin 'mspetshop' ,'pass@
word1', 'MSPetShop4'
END
exec sp_grantdbaccess 'mspetshop'
exec sp_addrolemember 'db_owner', 'mspetshop'