198 reputation
16
bio website davidagibson.com
location United Kingdom
age 35
visits member for 3 years, 2 months
seen Dec 11 at 16:50

Trying hard not too suck...


Jun
8
awarded  Constituent
Jun
8
awarded  Caucus
May
9
accepted Why is replication attempting to distribute NULL values into Identity columns
May
9
answered Why is replication attempting to distribute NULL values into Identity columns
Feb
14
comment Why are Stored Procedure schema changes not being replicated when using ”initialize with backup”?
@JNK, - I think I came to the conclusion that "initialize with backup" precludes this option. I'm not 100% sure that's correct but there appears to be so much undocumented that it made alot of sense when I came to this conclusion. In our situation we ended up not replicating tables or stored procudures - just the data.
Jan
16
asked Why is replication attempting to distribute NULL values into Identity columns
Dec
7
comment Dropping then adding a table to a subscription with Identity option Not for Replication causes errors
Nobody was happier then me when I got it to work! And then the next error arrived... coming from a DEV I don't know how you DBAs do it.
Dec
6
awarded  Teacher
Dec
6
accepted Dropping then adding a table to a subscription with Identity option Not for Replication causes errors
Dec
6
answered Dropping then adding a table to a subscription with Identity option Not for Replication causes errors
Dec
2
asked Dropping then adding a table to a subscription with Identity option Not for Replication causes errors
Nov
1
awarded  Supporter
Nov
1
awarded  Scholar
Nov
1
accepted How long can the log reader agent run for before a restart will do it some good?
Nov
1
comment How long can the log reader agent run for before a restart will do it some good?
Great that's what I wanted to hear, cheers Mike.
Nov
1
awarded  Student
Nov
1
asked How long can the log reader agent run for before a restart will do it some good?
Oct
8
comment Why are Stored Procedure schema changes not being replicated when using ”initialize with backup”?
Not dumb at all :) but yes - they are articles. Also further tested has confirmed that when I set up the replication using the GUI which forces me to semi-create snapshot stuff the stored procedures definitely get replicated.
Oct
7
awarded  Autobiographer
Oct
7
asked Why are Stored Procedure schema changes not being replicated when using ”initialize with backup”?