A little more information if you please:

Are the O/S and program files located on any of these drives?

Does this instance host more than 1 database (other than the system databases)?

Speaking...

In theory, if the SQL service is never restarted, and the server never gets rebooted, then tempdb is never recreated.

May I suggest: DENY VIEW ANY DATABASE TO [login]. When VIEW ANY DATABASE is revoked, the user can only see master, tempdb, any database he owns, and the...

The other option is to copy the media to a UNC that is accessible to both your local PC and any servers you wish to install SQL Server on. ...

No, for a few reasons.

1. You've already restored the data file and did not leave the database in a state to restore additional log files (so I assume).

2. ...

Also, afterwards you can script out the tables you've added to your SQL 2000 system databases and recreate them in a new user database on SQL 2005. You can...

Good Point GSquared. Thanks for the clarification. The syntax for this query is fairly wonky and I'm not used to coding in this manner on a regular basis.

I would focus on the derived table:

(SELECT @list_id = COALESCE(@list_id + ', ', '') + ' ' + LTRIM(RTRIM(pit1.secondary_id))

FROM partyInfoTable pit1

WHERE pit1.primary_id = pidt.primary_id) as list_id

Pay close attention...

Did you declare the variable first?

1. Install the 64bit Oracle 10g Release 2 client on both nodes (default location for Oracle Home)

2. Install the 64bit Oracle ODAC 10g Release 2 drivers on both nodes to...

You asked whether you needed to apply the patch to both nodes. What you did not tell us though was how many SQL instances are on this cluster. ...

I would also add that when it comes to re-indexing it is best to test the level of fragmentation in the individual indexes and perform index defrags or index rebuilds...

The forum is not really a good place to deliver this information. Books are written on the topic you're concerned about. I suggest you look through the Microsoft...

Scott, do you really want an email every time a job fails on every SQL instance? Must have a lot of free time on your hands and space in...

First of All: Nice Job TJay.

I too built a similar system using linked servers in order to monitor failed jobs, backup history/backups out of date tollerance, databases::applications::servers, space issues...