There is a setting that determines when the transaction is commited: Set Implicit_transactions.  If this is off, the transaction is committed immediately unless you use BEGIN TRANSACTION first.  When I...

Yeah!  Good luck with your upgrade.

I think it boils down to the data and what you are trying to achieve.   The LEFT OUTER join will retrieve all rows from the table on the left of the join whether...

Here are the steps to do a restore and move the file destinations:

In SQL Server Management Studio

 Right Click on Databases and choose "Restore Database"

 Type the name of the database that...

Thanks! I knew it would be somthing obvious that I overlooked!

You definately should be able to restore to SQL 2005 from a SQL 2000 backup, but not the other way around.  Make sure you understand how to do a restore,...

Do you know the command to cause the results to show up in Query Analyzer as they happen instead of when the batch is completed?

There is an option STATS that defaults to 10%.

Kirk is correct. Also, don't have to convert your DTS packages right away. There is an upgrade wizard, and dtsrun is still supported. 

It looks like the Import tool only brings data.  When I try to import a table using it, I lose the primary keys, defaults, etc.  Do you need to convert...

They must have corrected the issue with Office XP. I was unable to reproduce the problem and left "set nocount on" in my trigger.

Do you have a backup available?

Merry Christmas Steve, Brian and Andy!  Thanks for helping to make 2005 such a fun year for me.  Can't wait to see what next year has in store.

Cool!  Glad it helped!

Sorry about that!  I would have checked it myself, but I didn't realize one of my questions was being posted today.