You could set up a job on the 2005 server to run the SSIS package and run the job from the commandline on the 2000 server though (cmdexec in SQLAgent)....

I want a reverse GOOF button that gives out stronger and stronger electric current when people write queries that give cartesian products, or bad code in general.  Preferably tied in...

I've never done an unattended install, but Windows Authentication is the default, so I imagine somewhere in that string you need to tell it to install it with Mixed Authentication. ...

ok this is not meant as a flame, just trying to see if I understand.

You are worried about security but you have been making direct updates to the table that...

Are you running Windows 2003?  If so the mapped drive will not work from within SQL.  You will have to use a UNC name.

You should be ok backing up the disk then restoring them.  Howerver, make sure all services are shut down and disabled before you start doing this. 

Wouldn't hurt to make...

I would store one record per language, just like sys.messages does.  Makes it easy to add another language later if determined there is a need for it.

I agree with you on the rusty part Steve, but it does something against your self confidence during an interview.  Last couple of interviews I have done I think I...

I got laid off in 2002 due to the reduction in the number of contracts available (I worked for a consulting firm at the time).  During the 3 months I...

If you have quoted_identifier set to be on, the "y" is thought be SQL to be a column.  If you want to use double quoted, quoted_identifer need to be set...

Good write up Jeff and David.  And I agree, lots of time politics get in the way of doing the right thing.

Using the brain is #1 when it comes to...

I've succesfully used TRY..CATCH to handle deadlocks.  Works great.  Even set it upto record it when they happened, with how many retries etc.  I was thinking about putting a time...

I usualy went to the launches (and other MS/vendor sponsored events) to catch up with fellow DBA's and developers from past companies

Agreed.  It is even part of the "standard" trace that will run if you do not modify anything when starting a new trace.... (granted you might need some filters..)

Wouldn't that round just fine (to 4 digits precision) just be being copied into a money data type?  The negative number becomes -1.2394