WildGoblin
Ru-Board Member | Редактировать | Профиль | Сообщение | Цитировать | Сообщить модератору Message: An error occurs while executing SQL command: DECLARE @NewName nvarchar(128); DECLARE @UseExisting bit; SET @NewName = N'SVR\AMS User'; SET @UseExisting = 0; DECLARE @LegacyName nvarchar(128); SELECT @LegacyName = name FROM sys.server_principals WHERE sid = SUSER_SID(@NewName); IF NOT @LegacyName IS NULL BEGIN IF @UseExisting = 1 RETURN EXECUTE ('DROP LOGIN [' + @LegacyName + ']'); END EXECUTE ('CREATE LOGIN [' + @NewName + '] FROM WINDOWS'); |