Thanks for the pointer,

That would make a decent interview question. and it least a truncate means you can retain permissions etc.

i would also probably drop the table rather than truncate in this instance. You would then get the same Identity value for each date each time you ran the code.

I...

same error but I got it working eventually

in iis admin if you select properties for virtual directory of reports in the asp.net tab the asp version is null and is...

It might be time for the 2005 engine to stand still and stabilise as a solid platform for a bit while older systems are upgraded (making a larger 2005 user base). ...

The new manager asked me that question several months ago as he was obviously struggling with both the concept of a DBA and the budget. the answer then was obvious:

 "The kind...

I went for an interview today and they explaind their current issue with sql2005 as a problem getting sql2005 to mail their lotus notes users. I suggested xp sendmail with...

My method for duplicate removal  may not suit every one. it offers the advantage if you have duplicate data but the identity column makes the data unique you can modify the...