Absolutely agree with that!

Now, wouldn't it be an absolute hoot if they were looking at the MSDE box in Query Analyzer or EM thinking that it was the production box?  Not so uncommon a...

Concur... that's just about the same as what I use for header info.  And I document any parameters where such documentation belongs... next to the parameters in the code

Heh... cursors... gotta love 'em.

How much disk space do you have... 300 gig?  500 gig?  Why are you worried about a 9 or 10 gig TempDB?  Shoot... we preset ours...

Why speculate Do a test Run the following code several times and tell your team mate "Sorry,...

That certainly doesn't help the rest of us... Please post the "e-mail w/ example" here

Just like anywhere else... build a calendar table and a separate holiday table... include holidays for every country and make sure the holiday table has the ISO country code in...

Dinendra,

We need to know why you want to do this so we can give you the most correct answer.

(Thats' why, Ben )

You might be able to use some form of recursive CTE in SQL Server 2005, but your request is in an SQL Server 2000 forum. 

The UDF that David suggested...

...and, if there hasn't been too much activity, you may be able to recover the MDF and LDF files if they were, in fact, deleted.

Add an Identity column and delete the dupes when the import is done... much faster than trying to build an "UPSERT" (merge) in SQL Server 2000.

Here, here and well said.  Thanks, Matt.

Steve, thanks for taking the time to remember veterans and for paralleling the "give" and perils of good people in the world of IT.  A...

Ah hah!!!  THAT's why my checkbook is a mess!  I used Kerchoff's law of voltage dividers as applied to a WheatStone Bridge instead of the good ol' Boltzmann factor k