😛 We're caching partial sets of the data based on access...

All these databases are SQL 2005 databases, none have been upgraded from 2000. I'll give this a go but it seems like it shouldn't make any difference.

We've forced the sp to recompile, deleted it's plan etc. Even just running the update statement in a management studio window didn't work.

I agree entirely but...

I've checked all of these and they are identical.

We've managed to get this going by creating a new database and using sql compare and sql data compare to copy the...

Gail,

I'll try to do as you ask but I know I created the broker in the same way in both databases using

ALTER DATABASE FLEXII_GENERATED SET ENABLE_BROKER

followed by these

GRANT CREATE...

Notification services are active on both databases. Each has a different Guid for the broker id and the caching itself seems to be working fine when we point at...

I can run through visual studio and pause on the line of code that is making the ado.net call and checked everything is the same.

I've run the profiler...

I've updated the statistics using the FullScan option on the table being updated and every table it is related to as well and still no help.

I agree with...

Grant,

Thank you for your help. I've turned off all the 'ignore' options in the SQL compare and still nothing reported, I've rebuilt the statistics on the tables in the...

Grant Fritchey (12/20/2007)

---

How often do you update the statistics on these two databases. I'll be they're out of sync. Also, do you do a regular re-index or index defrag? I'll...