Have a look through the error log and post any sections that look like tehy contain errors or that you don't understand.

If you like, zip the entire error log up...

Maybe...

Secure your server. Make sure no one has enough rights to log on, stop the SQL instance and copy the files off.

Make sure your backups are somewhere secure (ie, can't...

Restore it. It's the only way to be absolutely sure.

If you're using SQL 2005, have page...

Ok, I haven't looked at the entire plan in detail (it's huge)

Here are some very quick index suggestions. Try them out, but no guarentees.

I don't know what indexes...

Databases don't have passwords.

You give credentials at the server level and then set the rights those credentials have for each database.

It's not too hard a process using Object Explorer.

Create...

Please don't cross post. It just wastes people's time. Most of us read all the forums.

Please do not reply to this thread. Replies to the following thread please.

http://www.sqlservercentral.com/Forums/Topic478901-150-1.aspx

You can set up a job if you want it to run at a particular time. If you just want 1 proc to call the rest, you can use xp_cmdshell...

Please don't cross post. It just wastes people's time.

Please do not reply to this thread. All replies to the following please -

http://www.sqlservercentral.com/Forums/Topic478926-169-1.aspx

Please don't cross post. It just wastes people's time.

Please do not reply to this thread. All replies to the following please -

http://www.sqlservercentral.com/Forums/Topic478926-169-1.aspx

Just bear in mind, as I mentioned earlier, that the estimated execution plan is just that. Estimated.

There's no guarentee that the estimated cost...

SQL 2005?

If so, check the error log, see if there are any messages about teh backup buffer size been reduced.

Use varchar. Max of 8000 characters

Use multiple variables and concatinate them.

If you show us the code, we can help you more.

Try SET SHOWPLAN_XML ON, then run the query. It should return the xml as a resultset.

Make sure you switch the Showplan option off, as it will affect all statements run...

Just the system databases? Interesting. Master, Model and MSDB all giving the same error?

Are the user databases on a different drive?