Hi Jason

Yeah - I pretty much convinced myself last night that it can only be because of Foreign Keys not being indexed. Its the only think I can...

Hi Gail

> No, because it's not the user that's requesting the data, it's the web server. SQL will finish the web server's request. If there's no transaction, any locks get...

Hi Gail,

Thanks for this. I think you've definitely helped me get into the right ballpark.

The application in question is quite an old and buggy CRM system built using classic ASP...

Hi Gail

Thanks for the reply.

> If a session has opened a transaction, run a query and is now in the sleeping state waiting for more work, it could still be...

You may also want to make sure you "editions" match.

Example, I wouldn't expect an Enterprise Edition -> Standard Edition backup and restore to work if the EE edition database was...