GO USE MASTER DECLARE @returnvalue varchar(50) DECLARE @machineName varchar(50) SELECT @returnvalue = hostname from master..sysprocesses WHERE spid = @@spid SELECT @machineName=Rtrim(@returnvalue) DECLARE @userName varchar(50) SET @userName=@machineName+'\ASPNET' IF(SELECT count(loginname) FROM SYSLOGINS WHERE loginname =@userName)<1 BEGIN EXEC('CREATE LOGIN [' + @Username + '] FROM WINDOWS') USE DiscussMoudle EXEC sp_addrolemember N'db_owner', @UserName END ELSE BEGIN USE DiscussMoudle EXEC sp_addrolemember N'db_owner', @UserName END USE MASTER SET @userName='NT AUTHORITY\NETWORK SERVICE' IF(SELECT count(loginname) FROM SYSLOGINS WHERE loginname =@userName)<1 BEGIN EXEC('CREATE LOGIN [' + @userName + '] FROM WINDOWS') USE DiscussMoudle EXEC sp_addrolemember N'db_owner', @UserName END ELSE BEGIN USE DiscussMoudle EXEC sp_addrolemember N'db_owner', @userName END GO 你数据库是叫DiscussMoudle吧
GO
USE MASTER
DECLARE @returnvalue varchar(50)
DECLARE @machineName varchar(50)
SELECT @returnvalue = hostname from master..sysprocesses WHERE spid = @@spid
SELECT @machineName=Rtrim(@returnvalue)
DECLARE @userName varchar(50)
SET @userName=@machineName+'\ASPNET'
IF(SELECT count(loginname) FROM SYSLOGINS WHERE loginname =@userName)<1
BEGIN
EXEC('CREATE LOGIN [' + @Username + '] FROM WINDOWS')
USE DiscussMoudle
EXEC sp_addrolemember N'db_owner', @UserName
END
ELSE
BEGIN
USE DiscussMoudle
EXEC sp_addrolemember N'db_owner', @UserName
END USE MASTER
SET @userName='NT AUTHORITY\NETWORK SERVICE'
IF(SELECT count(loginname) FROM SYSLOGINS WHERE loginname =@userName)<1
BEGIN
EXEC('CREATE LOGIN [' + @userName + '] FROM WINDOWS')
USE DiscussMoudle
EXEC sp_addrolemember N'db_owner', @UserName
END
ELSE
BEGIN
USE DiscussMoudle
EXEC sp_addrolemember N'db_owner', @userName
END
GO
你数据库是叫DiscussMoudle吧