【SQL开源代码栏目提醒】:网学会员,鉴于大家对SQL开源代码十分关注,论文会员在此为大家搜集整理了“CreateDBLogin2.sql”一文,供大家参考学习!
USE [MSPetShop4Orders]
if not exists (select * from master.dbo.syslogins where loginname = N'mspetshop')
BEGIN
exec sp_addlogin 'mspetshop' ,'pass@
word1', 'MSPetShop4Orders'
END
exec sp_grantdbaccess 'mspetshop'
exec sp_addrolemember 'db_owner', 'mspetshop'