SQLBill, why don't you just restore the database to another name in the same instance as the existing production database ? It seems to be a lot less of a...

Most software is backwards compatible. Forward compatible does not make sense. There may be compelling reasons to upgrade to SQL 2005 however if the software vendor does not support it,...

Here's a couple of other options:

• an IDENTITY column for the PK and just index datetime
• any other unique column for the PK and just index the time

Here's an eclectic list:

• A Clockwork Orange
• Total Recall
• Demolition Man
• The Minority Report

Going from favorite geek movie to @@timeticks

is like going from the sublime to the esoteric ...

Cache on the SAN is 256 MB ????

What can you upgrade it to ? If the max cache supported is 8 Gb, I'd at least put in 4 Gb....

system tables updates are pretty 'cool'  and usually very efficient ... but it's even 'cooler' when you know when NOT to use them ... every  one I've seen on this...

It sounds like there are a few items to add to your database build checklist under maintenance JOBs to create ... we call them site standards ...

SQL-DMO --> SQL 2000, SQL v7.0

SQL-SMO --> SQL 2005

It's all about revenue from MS standpoint. From ours it's primarily stability then support followed by features. 5 year cycles are just fine (and probably more realistic). 2 year cycles are OK...

I'm not familiar with HP SAN, but I've worked with EMC, Clarion and Hitachi quite a bit (we currently use EMC). I was wondering about a few of things that might...

Things are 'flaky' <period> and I do not know what to say. My actions would be to uninstall all of the client tools and reinstall them. Then apply SP3 (actually...

Thanks for the information Yelana !

Could you share this documentation with the community ?

I was able to duplicate your issue on a named instance. I need to acquire a 'default' instance yet ...