Yeah those triggers definatly shut you down when they work as I found out with my login trigger!  Even locks out the SA login!

Legato Octopus, but I believe that is now sold by EMC2 as RepliStor.

http://software.emc.com/products/software_az/replistor.htm?hlnav=T

See if you can get it from dbcc outputbuffer(spid)

Jeff, that is way cool.  Good luck on getting that approved (hope your dad got a good patent on it!)

You on Windows 2003?  Mapped drives does not work except from the desktop that mapped it, even if you leave that desktop logged in, the process that runs SQL can...

Boring, but DVR!  Guess that might not be considered a gadget.  But.....I can't tell you how much I like my DVR!  I'm a Formula 1 fan and watch every race. ...

Thanks! 

Will have to take a look at it on Monday when I get back from the F-1 race at Indy

Yes, but you have to use dynamic SQL to do it.  I posted a sample on here not too long ago how I do it.

hmmm paragliding.  Hey those have no engine, sounds scary!

If you are only worried about the structure, then a simple upgrade script should do it.  Make a batch file that opens...

Does it happen at 42 minutes and 30 seconds no matter when you run it?  Could you say move the backup 30 minutes and see if that moves the time...

How much data are you talking?  You could make a change script that would include inserts (and updates and deletes).  If you can talk them trough how to do a...

You should know by now I like to answer my own questions   Found a tool that works very well.

http://www.surfpack.com/downloads/dir/Batch-Rename-EXE-12064-download.html

The Row_Number is in the right order, but not necessarily the order that the data is returned.  For that you still need an order by after the where clause.

If you need data moved over should be able to use DTS to move it to a 2000 server.  If you just need the structure script it out and run...