Hi Clive,

We recently rebuilt every index. The main table used has the following for showcontig:

DBCC SHOWCONTIG scanning 'Snapshots' table...

Table: 'Snapshots' (2055678371); index ID: 1, database ID: 13

TABLE level scan performed.

-...

Hi Paul,

The server software is set to timeout after 30 seconds.

Ive noticed that when there is a high number of connections, the perfmon counter Lock timeouts/sec sometimes shoots up to...

The orignal procedure was created in SQL 2000, but the amended one in 2005. I completely agree with your comments, however this could well create massive problems if not detected!...

Hi Chris,

I've managed to work it out, but I dont know why it makes a difference. In the original procedure that was created some time ago, there was this:

IF NOT...

I actually managed to fix it.

For anyones information this link shows you how to fix it:

http://www.mssqltips.com/tip.asp?tip=1166

I think I may have found the reason. There was 4 stored procedures that referenced invalid columns that had not been deleted. I've removed these from the publication and its...