savethytrees (1/19/2012)

---

For jobs, I would rather use a VB script. The TSQL method puts a limitation on the length of a job step that is being scripted.

Check this

http://saveadba.blogspot.com/2011/12/sql-server-2005-generate-scripts-for.html

Check out the...

Lowell,

The script gave me an erroron the While Statement?

WHILE (@LoopControl <= @MaxSteps)

Lowell,

Nice.:cool:

Thank you!

Thanks @richard-2.

I was going to edit my post because I had figured it out.:-)

What did you specify as the default database in your DSN?

@michael-2

Thanks!

Thanks Lowell!

Thank you!

You...

I know that if you stop the SQL Server Service you can replace a User Database.

My guess is that you could do the same to replace the Master & Model...

Years ago I goofed on switching Master DB.

The last time, I just scripted out the Jobs & it worked, bad idea?

Lowell (1/13/2012)

---

I wouldn't even try to restore a different server's system databases.

instead, i'd do the following:.

1. script out your jobs in the msdb database,

2. script out the logins with...

Yes and thank you.

I thought that...

Post moved to the following URL:

http://www.sqlservercentral.com/Forums/Topic1238156-146-1.aspx%5B/url%5D

Markus (1/18/2012)

---

Yes you can. Simply move everything however you plan on doing it. Then once the original servername is off the network have the dns alias of the...