yes i used a script to take them off and online

I did some testing and restored to a 2014 server but couldnt replicate. Interestingly it caused the available...

thanks for replys:

in master:
name   database_id
object    32
Object_old 5

in object:
object   32

Nothing in sys.synonyms...

thanks for the pointer but cant do a "select count(*) from..." as the data comes from a SP - but you got me thinking

I changed the SP to have 2...

My problem is there...

😀 yep! Nightly, and logs shipped to another server hourly - about the only thing they have done!

Given the age of the app, who knows...

However,...

thats exactly what i was thinking re delete all the statistics. I got a blank app db and had a look and that contained alot of stats too, not quite...

thanks for the pointers.

Dundas is a no go ATM - we are redeveloping a product and it needs to use vanilla RS, then we will offer consultancy, fleshing them out....

existing thick client app:

The issue is the classes that cross or start in the middle of time periods - eg a lessons goes from 930-1045 and the next one 1050-1230....

you mean a matrix? i have already put that together (couple of years RS exp.). The issue is to do with the length of the period

This is what i want...

hi, i am using SQL 2000, not 2005.

unfortunately the business users arent very advanced in anything other than moaning.... So we are stuck with a report that is literally...

ok update for you

been off reading lots of stuff after seeing the sp_blocker output - eventually came across a MS ppt which...

thanks Chris

Whats the best way to locate these long running queries that lock multiple rows or even whole tables, - i think they are impacting the whole db. We...