DECLARE @DatabaseName varchar(100), @SqlStatement varchar(1024)
SET ROWCOUNT 1
SELECT @DatabaseName = NAME FROM SYSDATABASES ORDER BY NAME
WHILE @@ROWCOUNT > 0
BEGIN
SET @SqlStatement = 'sp_change_users_login ''Auto_Fix'', ''SedonaUser'''
SELECT @SqlStatement = 'Use [' + @DatabaseName + '] exec ' + @SqlStatement
PRINT (@SqlStatement)
EXEC (@SqlStatement)
SELECT @DatabaseName = NAME FROM SYSDATABASES WHERE NAME > @DatabaseName ORDER BY NAME
END
SET ROWCOUNT 0
GO
DECLARE @DatabaseName varchar(100), @SqlStatement varchar(1024)
SET ROWCOUNT 1
SELECT @DatabaseName = NAME FROM SYSDATABASES ORDER BY NAME
WHILE @@ROWCOUNT > 0
BEGIN
SET @SqlStatement = 'sp_change_users_login ''Auto_Fix'', ''SedonaReports'''
SELECT @SqlStatement = 'Use [' + @DatabaseName + '] exec ' + @SqlStatement
PRINT (@SqlStatement)
EXEC (@SqlStatement)
SELECT @DatabaseName = NAME FROM SYSDATABASES WHERE NAME > @DatabaseName ORDER BY NAME
END
SET ROWCOUNT 0
GO
