Mike, this is no problem at all. The Alert Engine SPID will stay connected and show up in your sp_who2 output even if it is not doing any specific job...

Scorpion, thank you so much for the best post in this quite lengthy thread. Shows it was actually worth following the thread through 5 pages...

In response...

I agree, if you are at this level you shouldn't be looking at memory counters and such. Pick up a good beginners book and start from the ground up, this...

As the others have said, the problam lies in th fact that @@identity returns the latest created identity-value in the current session. As Andy suggested you can use scope_identity instead...

Do you have the same version of ADO on both servers?

--

Chris Hedgate @ Apptus Technologies (http://www.apptus.se)

http://www.sql.nu

One thing I would like is to have a 'Reply to posting'-functionality, so that you can show which individual post in a thread you are replying to. Not a big...

Jeff, I'll paste your email response to me here so that others can follow the discussion:

quote:

---

So if this was a bak file...

Have you tried specifying where to move the database files to? Otherwise I would expect the problem to that SQL Server does not have rights to read the backup files.

--

Chris...

Tim, you really brought up some bad memories there...

To continue your off-topic rant, I just remembered an old project where the customer decided that 'Articles' should...