SQL Errors and Solutions – Kaizen – Continuous Improvement
all xxx vidoe ozbeki sekis indian porn video porno gratis porno gratis tumblr big tits porn videos English nxxx www Fullsex porn video best free bfxxhindi xxx videos

SQL Errors and Solutions

SQL Errors and Solutions
Error:
This login is the owner of 14 job(s). You must delete or reassign these jobs before the login can be dropped. (Microsoft SQL Server, Error: 15170)

Solution:
— **Changes the owner of the jobs to sa

DECLARE @pJobName VARCHAR(1000)
DECLARE JobName_Crsr CURSOR
FOR
    SELECT  [name]
    FROM    msdb..sysjobs
    WHERE   owner_sid <> 0x01
OPEN JobName_Crsr
FETCH NEXT FROM JobName_Crsr INTO @name_holder
WHILE ( @@FETCH_STATUS <> -1 )
    BEGIN
        EXEC msdb..sp_update_job @job_name = @pJobName,
            @owner_login_name = 'sa'
        FETCH NEXT FROM JobName_Crsr INTO @name_holder
    END 
CLOSE JobName_Crsr
DEALLOCATE JobName_Crsr

 

Top