recommend they bin VSS and get Subversion instead 😉

it sounds very much like there are foreign keys and they are missing column information.

i would query the system views and find out which foreign keys are affected. Drop them...

RAID 10 if you can RAID 5 if you want to keep it simple, RAID 0+1 involves mirroring over a striped set and is not as tolerant as RAID 10

the 80 folder contains numerous backward compatability components

to get a list of database and filenames use

select name, fileid, filename from sys.sysaltfiles

you will need to install either SQL2005 express or developer. Enterprise and standard are for server systems only

install a new instance with the correct collation and transfer any objects across, then remove the original instance. Pay close attention to the installer and select the right collation, check...

you may or may not need to configure the /3GB switch in the boot.ini (i assume you meant this file and not...

Simon

not so much bad indexing, but yes they are related. The fill factor is defined as a default at server level which is usually 0 and means 100%. When rebuilding...

what is your MDAC version

to make the trace easier to read\sort dump the output to a sql table

SELECT * INTO tablename

FROM ::fn_trace_gettable('d:\path to trace\tracename.trc', default)

the compound key has to be unique, you can have the same value in single columns as long as the combined values are unique

col1 ...

Jeff, send it over PM

begs the question, if you find yourself having to store the same data in a column should it really be a primary key??

this is very important, if...