Yes () are required to EXEC a string as code.

"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)

msdb Database is where they are restored. I would restore either to another database or another test server and push them into the proper table (see other threads not on...

Check NT Event log and SQL Server Logs for some details (backups are logged). Anyway may be cleaning needs, bad recorder head, or bad drive. But the log may give...

Haven't tried this in dealing with instances but have with Service apps that need SQL up and ready to receive when reboot occurrs. Set 1 instance to automatic, then create...

What is the effect of deleting them? They go away and you get extra drive space, sorry couldn't resist as all our production systems have dumped these (we do keep...

Or if it is going to be a COmpaq get your sales rep to let you talk to a techie (not the CS guys but a real hardware tech). But...

The best thing to do after my initial suggestion is run profiler to catch the queries run most often and see what index additions may make since. However with you...

1) If this was an OEM copy then technically NO as it is only supposed to go with the original equipment (there are a lot of ins and outs to...

Ok you may hurt yourself with this overall since these are in truth the same indexes. I suggest drop Indx1 and make PRIMARY KEY NONCLUSTERED into PRIMARY KEY CLUSTERED.

Now...

I would also be curious to know why you have the extra Filter occurring. Just out of curiosity, you stated the 2000 box was dev, copy the DDL from EM...

Well to it's bennefit SQL2000 does have some engine enhancements. However run in QA with show exectuion plans on to see if there is any difference between the twos plans....

Sorry haven't looked to much into this but check out http://msdn.microsoft.com/library/default.asp?url=/library/en-us/sqldmo/dmoref_cnst03_4c11.asp for SQL-DMO errors handling.

"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)

Well there are lots of methods to deal with this, however to save you a lot of troubles you may want to setup an import table to do your scrubbing...

Doubly sorry, found the other. Here is what I posted

Check these out on the MS KB site http://search.support.microsoft.com/search/default.aspx?Catalog=LCID%3D1033%26CDID%3DEN-US-KB%26PRODLISTSRC%3DON&Product=sql&Query=Error%252022029&Queryc=Error+22029&withinResults=false&srchstep=0&KeywordType=ALL&Titles=false&numDays=&maxResults=25

But I almost bet it is the master backup that is your base...

Check these out on the MS KB site http://search.support.microsoft.com/search/default.aspx?Catalog=LCID%3D1033%26CDID%3DEN-US-KB%26PRODLISTSRC%3DON&Product=sql&Query=Error%252022029&Queryc=Error+22029&withinResults=false&srchstep=0&KeywordType=ALL&Titles=false&numDays=&maxResults=25

"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)