Sysproperties in the Master table does not indicate any blocks ...

Profiler has not picked up any deadlocks *or blocking that i can see.

Yes some queries quick while others just time out or are incredibly slow.

Some of the users have indicated...

Rebuilding the index on the table did not make solve the issue 🙁

I'm gonna retrace my steps and collect some more data with performance monitor ..

The results from SQL profiler pointed to our Currency table.

On closer analyis the index fragementation is 97% on this table...

Thanks for the input.

The strange thing is that the SQL2000 subscribers (and only 3 of the 6) are experiencing the timeouts. Users connecting to the 2005 DB have not experienced...

Wow ... sorry I should maybe post in a different topic.

I've just had a look under my local subscriptions and found to two subscriptions to the same publisher ......

Thanks for the advice...

It turns out the log file was using an additional 100mb.

Cheers.

Thanks!

Thanks for all the info and the link to the msdn article ... will give it a read.

The plan is to kill the 2000 publication, restore the DB to instance...

Thanks for the input guys. Ya the future date seems like a good idea, will bring it up with the higher ups 😉

Are the colomns in the same database or are you joining between seperate databases ?

Thanks ! Exactly what i was looking for :hehe:

Thank you very much!

Sorry I did not mention that I intended to use the Query on a 2000 box. We are in the process of upgrading but 2005 is still...

Thanks I will be giving it a try ...

I suppose this will not be easy to do in SQL 2000? The db at work has not been converted to 2005...