I've run sp_updatestats, one table has 1.5 million rows, the other two million. Still does scan for both tables. No idea why - surely it should use the...

True, obviously one of the tables has to do a scan, but I wouldn't have thought both would.

I've dug a little deeper and it turns out that out of 2m...

I'm only updating rows where TR matches DSR and DS matches DS - there are a great many other rows in IT that are not being updated. So I...

I can see I haven't explained it well enough 🙂

Database A, master schema, has dictionary tables such as 'ApplicationName' and 'CustomerType'.

Databases B, C and D are entirely different schemas, however...

Thanks for your response.

Problem is foreign keys. I know I can't create FKs to values in other databases (whether on the same server or not), which is why I'm...

Is there even a way to get a list of tables which are different, with maybe some additional information about the difference? Or even just a list of...

Hi

Thanks. I knew I could do that but I always regard it as a last resort because the production database is on a site which is not ours, and...

What an innovative idea - thanks! 🙂

Hi

Thanks a lot for the code. It looks like polling is the only way in 2000, which is unfortunate, but manageable I suppose 🙂

Thanks to everyone who offered suggestions...

Deadlocks and blocks are different. Blocking locks can become deadlocks after time. But I just need blocks!!

I'm stunned that I can't capture this data without polling, which is...

Hi

Thanks for your answer. Running any proc at short intervals is a desperate waste of resources surely seeing as how 99% of the time it will find nothing?

Also, sorry...

Sorry - this forum doesn't show quoted text for some crazy reason. I meant, does the blocked process report event exist in SQL 2000?

Does that exist in SQL2000?

Hi

Thanks for the response. I'd seen this, however it doesn't solve the problem. Microsoft suggest that you use that proc to periodically check for blocks - however I...

Aha - found it, and thank you very much. When checking the service packs, I accidentally ran the check in the same window twice 😉

So yes, the...