DECLARE @SQLString VARCHAR(6300)
SELECT @SQLString = ''
SELECT @SQLString = @SQLString + 'EXEC [dbo].[sp_Change_Users_Login] ''Update_One'','''+[Name]+''','''+[Name]+''' '
FROM [dbo].[SysUsers]WHERE [IsSqlUser] = 1 AND (SId IS NOT NULL AND SId <> 0x0) AND SUSER_SNAME(SId) IS NULL
IF LEN(LTRIM(RTRIM(@SQLString)))>0
BEGIN
PRINT (@SQLString)
END
GO
SELECT @SQLString = ''
SELECT @SQLString = @SQLString + 'EXEC [dbo].[sp_Change_Users_Login] ''Update_One'','''+[Name]+''','''+[Name]+''' '
FROM [dbo].[SysUsers]WHERE [IsSqlUser] = 1 AND (SId IS NOT NULL AND SId <> 0x0) AND SUSER_SNAME(SId) IS NULL
IF LEN(LTRIM(RTRIM(@SQLString)))>0
BEGIN
PRINT (@SQLString)
END
GO
No comments:
Post a Comment