As I say I remember doing a similar sort of thing when placing a number of servers within seperate dmz's, so they all had seperate subnets and the issue of...

does your 2k server have tcp/ip and named pipes libs loaded? No strange settings / aliases/ names or anything?

Is it using a std port? on same network?

You can't register by...

be aware that the sql server error log and agent log are prone to ntfs fragmentation and may soon present problems on any drive they exist, especially if disk space...

I wasn't quite sure if x64 required this fix.

this might not be relevent but sp4 broke awe support and you need an additional hotfix ( after sp4 ) to use it.

I seem to remember that until 2005 you can't selectively restore individual file groups. If your backup window is too large might I suggest you investigate Litespeed, which does exactly...

I suggest a read of a good tcp/ip book. I'm not too hot on tcp/ip but I'm pretty sure this is to do with subnet masks and you have to...

You can't have such a thing as the requirements / constraints / costs / facilities for such a thing will vary from one business to another. I'm sure there's been...

yeah I'm not sure they are indexes .. try drop statistics  .. I'd normally delete direct from the system table .. but you might not feel safe with this approach. ...

yeah - in the programs for sql2005 are surface configuration, for example remote access is disabled by default so if you don't set it in the config program ( which...

yup, that works and tells me something else is amiss , usually ( and i say this in a general sense ) if you have to force an index there...

I'm not convinced a reindex does a full scan ( and if you have auto stats set on your database this too would reset your stats to 10% so I...

as I say only small data sets should go into a table variable. Your clustered idnex scans are in fact table scans so that tells me that your indexing isn't...

never stupid - the 2005 interface can be very confusing - especially if you're used to 2000!

at the risk of getting sued by intel I believe intel 64bit chips aren't really too hot .. something to do with the front bus only being 40 bit, so...