InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comSat, 25 May 2013 00:42:16 GMT20http://www.sqlservercentral.com/Forums/Topic1405990-391-1.aspxALTER DATABASE XXX SET NEW_BROKER WITH ROLLBACK IMMEDIATEFirst stop everything that uses service broker in MSDB, like DBMail or anything you have created manually.Mon, 14 Jan 2013 01:22:39 GMTanthony.greenhttp://www.sqlservercentral.com/Forums/Topic1405990-391-1.aspxGot below error:Cannot enable the Service Broker in database "msdb" because the Service Broker GUID in the database (XXXXX....) does not match the one in sys.databases (YYYYY.......).I dont have an clue whether the master/msdb was restored from another server. Can i create a new service broker. For this any precautions needed like i have to check all the existing service broker etc?Sat, 12 Jan 2013 14:36:02 GMTbalasach82http://www.sqlservercentral.com/Forums/Topic1405990-391-1.aspxYep, thats the documented way to do what you want to do.Fri, 11 Jan 2013 08:26:24 GMTanthony.greenhttp://www.sqlservercentral.com/Forums/Topic1405990-391-1.aspxYes, i didnt want to update the systables directly. thats why wanted to find the best way to do this.Running the sp_update_job is the best method and no other "Accepted" way. Is it?Fri, 11 Jan 2013 08:23:19 GMTbalasach82http://www.sqlservercentral.com/Forums/Topic1405990-391-1.aspxDon't update the system tables directly.Instead use sp_update_job passing in the old name and the new name.Fri, 11 Jan 2013 07:53:38 GMTanthony.greenhttp://www.sqlservercentral.com/Forums/Topic1405990-391-1.aspxHi balasach82,Lets say i have a job that is called Backup and my servername is BI-ONT this could be the query that you could use.Update msdb..sysjobsSet name = 'BI-ONT'+'_'+ namewhere name = 'Backup'If you don't use the Where clause de statement will update all your jobs.Don't forget to refresh your object explorer after all of this.MarboFri, 11 Jan 2013 07:47:20 GMTMarbohttp://www.sqlservercentral.com/Forums/Topic1405990-391-1.aspxHow to rename all the job in an sql server 2005? I need to add the servername to the jobnames?Fri, 11 Jan 2013 07:01:45 GMTbalasach82