To my knowledge there aren't any major differences between 2000 and 2005 as far as it comes to things you're looking into.

Personally I would go with broader raid 10 set...

same way as before, open server properties and go to the "processor" tab.

Just remember to untick the affinity settings below the box, so you can modify your processor count.

dunno if this is the case, but if you move ALL your db files from the local drives to a SAN area and nothing else is left on the local...

Hi,

btw, this is SQL Server 2005 thread, you seem to be running 2000

check that your db's are in recovery model = full

I haven't ever tried to move the model database, but a stupid question, have you checked that the account running sqlserver has access to your new drive/folder (local system/nt account)?...

Thanks, but the answer is not this easy

This will result to null, if you have a default instance, so it won't be that...

why not choose anything else than 64-bit, even if you have less than 4 GB of RAM, there is no extra cost for running 64-bit all the way from hardware,...

yes, I'm aware of those and I tried to emphasize that I don't need information about other instances, I just want to differ to instances from each other. (not in...

I'm just trying to find some unique or almost unique information from the master database, nothing more special.

The server name is already known and the connection + authentication is...

You have missed one big change in SQL Server 2005 compared to the previous versions. There is no access to the system tables anymore or the old system table structure...