【SQL开源代码栏目提醒】:网学会员为广大网友收集整理了,CreateDBLoginSec2.sql,希望对大家有所帮助!
USE [MSPetShopOrders]
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