Once you are in single user mode and then start QA, you have to stop the object browser if you normally have it up.  It will use your single connection.

Thanks, I'll just keep a check on the MS web site.  I couldn't find anything giving an estimate so I guess they aren't saying.  There are a couple bug fixes...

You might be able to use a tool like Red-Gate's SQL data compare to see the differences and script the ones you need to change.

Thanks for the information.  I think the link gives some basic information I was looking for to import the logs into SQL and make soem sense of them. 

In repsonse...

Thanks.  This article says what I thought but couldn'tfind in print.  It's a good concise article. 

I still would like to be able to find it in print from Microsoft.  But,...

Your failing statement did't pass the parser.  The statements are actually never getting executed and it's not really rolling back the first insert - it never does it.  But, you are correct...

cannot or should not

rajiv, thanks for responding.

My question is a general question and fixing my example isn't required.  I'm sorry it wasn't clear what I was trying to illustrate.  What I am trying to learn...

• Oh, ignore that post.  I just realized you asked what edition.  I don't know that.

select @@version works on the SQL6.5 instance (Microsoft SQL Server  6.50 - 6.50.416 (Intel X86)   Jan 23 1999 14:10:24   Copyright (c) 1988-1997 Microsoft Corporation

) I recently installed with SP5a. Maybe...

Brian,

Would the lookup work without qualification the same for every user that may also be aliased to DBO?  When the article talks about the DB owner they are refering...

I've had similiar patch or SP installation problems with the SQL monitor (running in the tray), MOM if it kicks in to do SQL monitoring while your patching and multiple...

I also chose to steer away from when upgrading from SQL7 to SQL2000 due to the complications of keys.  I have also used a merge replication instead of transactional replication...

Try reading up on the new option for queued updates when using transaciton replication with auto updating subscribers.  I've not used this option yet but have experience with the auto updating...

Did you enable a mail profile?  I've seen problems with agent starting when mail gets hung.  I don't have a solution but maybe another place to investigate.