Moving away from your question slightly, if I have a table, MyTable, with two columns say c1,MyDate and a view, MyView, defined as SELECT COUNT(*) FROM MyTable then

from your client...

Is this really what you want to do? COUNT will simply return a count of rows whereas I suspect you want a total generated on whether the relevant ClearedDate column...

I've made a few assumptions and I'm not sure what "plan number + CS" means but you could replace

and I.TitleReferenceNumber in (Not sure what to put in here)

with the rather...

Is there no other clue in the error message? Normally, you'd expect to find a reason for the failure such as "general network error" or "query timeout" etc. Just as...

There’s all sort of things to investigate here. Starting with some of the more likely

1)is the latency between the publisher and distributor (i.e. Log Reader Agent)?

2)is the latency between the...

Mike,

Firstly you have my sympathy. I too got involved in a DB2 project but that's another matter. Back on SQL Server now, phew! As I went along, and to help...

Ricardo,

Glad everything is working now. As for a book, I can't recommend one personally. I have managed to survive by using Books OnLine and various SQL Forums (oh, and a...

Does the error message contain reference to a transaction sequence number and command_id? I'd hope that it does as you can use these with sp_browsereplcmds to identify the actual stored...

Do you replicate SQL statements or do you use stored procedures? I'm guessing the latter and, if so, have they been written by yourself or are you using the horrible...

You're going to hurl abuse at me I'm sure. I had exactly this problem a couple of weeks ago and after a few hours of cursing and swearing I fixed...

Taking the simple case of one publication and one subscription you should have three jobs. One Snapshot Agent, one Log Reader Agent and one Distribution Agent. So you have somehow...

Hmmm... starting to get suspcious now. Can I ask a very silly question? In the stored procedure which fails / works does the date it is converting sometimes have a...

Without knowing anything about your installation, I would guess it's the 103 format in your convert statement. That will return dd/mm/yyyy which when converted back to datetime fails. Had the...

Any progress on this? I'd be interested.

Mike

You can reboot whenever you want. You can be really sloppy like me and not bother stopping any agents. We replicate over 100 million rows a day and have never...