also @sphite

when replication failed for the reason you status above "Someone accidentally ran the script on the Destination server - which added the column" you should have been able to...

If you're confident that your subscriber has the data you need, you can define your subscription using

@sync_type = N'replication support only' instead of @sync_type = N'automatic'.

and run your snapshot (it...

You can find the exact command having issues by running this:

exec sp_BrowseReplCmds '0x00029F9B000001F0004E00000000','0x00029F9B000001F0004E00000000'

against your distribution database.

This will return all commands in that transactionID and you would then look for...

My experience is that "ALTER LOGIN...DISABLE" is for SQL Standard accounts

while "ALTER LOGIN...DENY" is for Windows accounts..

one option that may work for you too- is to disable remote access (via...

bump...

are there no smart people out there who know the answer 😛

since the serverid <> 0 it's considered a "remote" server.

for @@servername to return properly- you'll need to drop and add as stated earlier:

If you look up sys.servers in BOL-...

I've seen this before- I'd bet your server isn't registered as "local"

Try selecting from master.Sys.servers- (select * from master.sys.servers)

you're local servername should be server_id= 0

if it's not- I think you...

Hi-

First I want to make sure I'm understanding... Your DR Server will be the same computername and Service Account??

We've done exactly that process a number of times on SQL 2000,...

It's been awhile since I logged this, and actually it's been resolved for awhile too, but I thought I'd add the resolution.

It turned out that I DID have one anonymous...

I wonder if you could:

Name the new server the same as the old server (off the network until swap time)

configure distribution

copy the mdf and ldf files and attach

[Note-- I haven't...

hmm- this isn't making sense based upon my analysis to date, but yesterday I changed the retention to 13 days rather than the 14 it was set for and dropped...

no apology needed-- You're helping 🙂

Your assumption is correct-

if I look at the history and identify a xact_seqno, then run sp_browsereplcmds for it-- it's still there

I'm mostly concerned with...

yes- (See the 1st msg in the thread)

It's typically running from 50 minutes to 2 hours.

I started tracking the size of MSrepl_commands on 10/14

(running sp_spaceused MSrepl_commands) each time the...

well- looking at all the publications (after forcing synchs) we have none pending.

I'll see if I can drill down to some particulars via xact_seqno to determine from there.

Any more thoughts...

Hmm. That's a mighty good question! How does one tell?

Unfortunately, we don't have vanilla replication table => table... We've got some pretty ugly custom stored procedures - sometimes updating a...