ok sound good. I will not worry about scripting out the maintenance plans.

I create them last week to perform backups, etc and it did not take me very long to...

Nice but it hangs when I load the page.

Thanks.

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...

I fixed my typo and attempted to restore but because the machine that I made the backup was not at SP4 and the target machine was I could not restore.:w00t:

I'm...

Never mind I was able to resolve.

Find the session that put it into single user mode, kill it and set to multi-user mode.

george sibbald (1/20/2012)

---

you haven't specified the full path to the backup so SQL is presuming its in the default directory. I presume its somewhere else.

Are you trying to move the...

Lowell (1/19/2012)

---

I'll look for or create a script for linked servers;

the problem is the credentials for the remote user, if you identify one, cannot be scripted out, because they are...

gweiho4xd2 (1/20/2012)

---

Hi,

The default database is set by the SQL server user login to our 'planning' database.

I've also manually set the database to 'planning' in the ODBC connection but still no...

Unfortunately it did not work.

Someone had to change the permission later this afternoon because he...

Where did you get that script?

Try running it on a production box.:w00t:

I had a Developer who was a member of the fixed database role db_owner and it added him to...

I just wanted to make sure.

Thanks Lowell.:cool:

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...

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 (1/18/2012)

---

for the scripting of jobs and linked servers, look in the script section here; there's several that do a great job there;i haven't done it in a while, so...