No. You could code for the error and have it save the transaction to another db or even to a local disk. Or fire an alert that frees up reserved...

Its a good question and another one I dont know the answer to. I guess the thing to do is formulate a plan for proving the results?

Andy

http://www.sqlservercentral.com/columnists/awarren/

You can run whatever you want as an OS command. Easiest way is to package entire thing as a batch file, call that from the job.

Andy

http://www.sqlservercentral.com/columnists/awarren/

I've got an article posted on the site that talks about that a little. Typically happens when someone inserts a row on the subscriber by mistake, then inserts it on...

Jeff, your article is this week.

Andy

http://www.sqlservercentral.com/columnists/awarren/

It takes time. Making things secure almost always slows things down (or appears to). I'd recommend that you talk them into letting you change the sa password, give the most...

I typically create a new publication. Then at some point in the future when I have time, I may put them all back into one. Can't add an article if...

Havent used enough to say for sure, but what I've seen of clustering it's smoother (and supports more nodes).

Andy

http://www.sqlservercentral.com/columnists/awarren/

Nothing wrong with either method. Faster still would be to compress either file using zip or similar. Faster than that would be a SQLLiteSpeed backup since they compress in memory...

The tables are still there? Why do you think the subscriptions are still running?

Andy

http://www.sqlservercentral.com/columnists/awarren/

Have not used it so this is far from authoritative - but I'd think the only affect would be that your logs are possibly going to be larger.

Andy

http://www.sqlservercentral.com/columnists/awarren/

Maybe this:

http://groups.google.com/groups?hl=en&lr=lang_en&ie=UTF-8&oe=UTF-8&threadm=uIBxGNUvAHA.2028%40tkmsftngp04&rnum=1&prev=/groups%3Fq%3Ddts%2B%27Execution%2Bcancelled%2Bby%2Buser%27%26hl%3Den%26lr%3Dlang_en%26ie%3DUTF-8%26oe%3DUTF-8%26selm%3DuIBxGNUvAHA.2028%2540tkmsftngp04%26rnum%3D1

http://groups.google.com/groups?hl=en&lr=lang_en&ie=UTF-8&oe=UTF-8&threadm=0e1e01c25e6b%24d45b2590%2436ef2ecf%40tkmsftngxa12&rnum=7&prev=/groups%3Fq%3Ddts%2B%27Execution%2Bcancelled%2Bby%2Buser%27%26hl%3Den%26lr%3Dlang_en%26ie%3DUTF-8%26oe%3DUTF-8%26selm%3D0e1e01c25e6b%2524d45b2590%252436ef2ecf%2540tkmsftngxa12%26rnum%3D7

Andy

http://www.sqlservercentral.com/columnists/awarren/

Not sure this is a SQL issue. Is the error indicating something data access related? You may get better/faster help if you visit the site that spawned the software (assuming...

Gotta love the docs.

Andy

http://www.sqlservercentral.com/columnists/awarren/

Agree. Posting in the wrong section isnt that severe of an offense!

Andy

http://www.sqlservercentral.com/columnists/awarren/