Script out Jobs & Logins Master DB

• Lowell

  SSC Guru

  Points: 323482

  More actions

  January 20, 2012 at 6:54 am

  #1436456

  i just copied and pasted my quoted command, and tested it in both SQL2005 and SQL2008, and i got results with no errors at all.

  I'm not sure where your issue lies.

  Lowell

  ---

  --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

• Welsh Corgi

  SSC Guru

  Points: 116520

  More actions

  January 20, 2012 at 7:41 am

  #1436495

  Lowell (1/20/2012)

  ---

  i just copied and pasted my quoted command, and tested it in both SQL2005 and SQL2008, and i got results with no errors at all.

  I'm not sure where your issue lies.

  I found out the problem.

  If I pasted it without quoting, it did not copy everything.

  When I used quote it replace the > and < with control characters.

  I created jobs in which I had a maintence plan.

  The one job that I was hoping to get it did not create.

  If I could script out the maintence plans that would be good.

  I tried restore MSDB but the destination machine is on SP4 and the source is on SP3.

  Thanks for your help!

  For better, quicker answers on T-SQL questions, click on the following...
  http://www.sqlservercentral.com/articles/Best+Practices/61537/

  For better answers on performance questions, click on the following...
  http://www.sqlservercentral.com/articles/SQLServerCentral/66909/