Tuesday, October 26, 2010
Job name from sp_who2
select * from msdb..sysjobs where
job_id = convert(uniqueidentifier,0x20981069DD3DE5F4598433E36C60CF26)
Orphaned users
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
Subscribe to:
Comments (Atom)
