Nah, you were there when I posted.  I don't know where my brain was, but it obviously wasn't in my head.

Steve

Have fun!

By the way, I got my coffee cup ALWAYS within reach!

Another thought just occurred to me regarding the service pack, etc overwriting changes to system procs.  It would probably...

I should know this...  SourceSafe????

Steve

It'll move the tables because the clustered index IS the data. 

As to manually doing it, don't.  Write a script to handle it.  You can check sysindexes for clustered indexes,...

I was taught to NEVER, EVER, EVER change a system stored proc, so I created a wrapper for sp_who2 to display the results in the order I wanted (order of...

8.00.534 = 2000 SP 2

HOW TO: Identify Your SQL Server Service Pack Version and Edition

http://support.microsoft.com/default.aspx?scid=kb;en-us;321185

Steve

I have a stored procedure that deletes files based on a date/time stamp in the filename.  It wouldn't be too much of a stretch to go from there to use...

Sounds to me like you're pretty much on track.  Since your backups for the past month are stored on premises, you have very quick access to your backups which are...

Here's what I've got.  I have a stored proc that deletes my old backup files based on the date/time stamp in the filename.  I also have a stored proc that...

There are a couple ways to set the current database in QA.  First, there is a drop down box in the menu bar at the top.  Simply select the db...

Jim, what exactly does the stored proc need to do?  If the backup name is the same every month, then a job with the restore statement coded in the job...

Once again, I'm in the position of seconding someone else.  "What she said".  The rebuild master utility is an option, but you'll still need to restore master to get back...

Read Books Online regarding DBCC CHECKTABLE.  It has repair capabilities.  I would attempt it from least risk to greatest, in other words, REPAIR_FAST first, if that doesn't work, then REPAIR_REBUILD,...

No script handy, but simply create clustered indexes for each table you wish to move, specifying your secondary file.  If you already have a clustered index, drop it and recreate...

Per the top of the bug check, you aren't expected to find the source of the error.  This is a SQL Server crash, and Microsoft is requesting that you send...