【SQL开源代码栏目提醒】:网学会员鉴于大家对SQL开源代码十分关注,论文会员在此为大家搜集整理了“CreateDBLoginSec1.sql”一文,供大家参考学习
USE [MSPetShop]
declare @hostName as varchar(25)
set @hostname = HOST_NAME() + '\ASP
NET'
exec sp_grantlogin @hostname
exec sp_grantdbaccess @hostname
exec sp_addrolemember 'db_owner', @hostname