Viewing 15 posts - 31 through 45 (of 109 total)
Thanks for your time
@SSChasing Mays: no table vars (I agree and hate those things; ). Indexes? Hmmm, I could start dropping them one by one, would sure like...
September 29, 2011 at 1:49 pm
you need to run some update scripts to do this:
Using a SQL Server 2005 Distributor with a Publisher Running SQL Server 2000
SQL Server 2005 can be used as a remote...
December 21, 2007 at 2:58 pm
This is transactional repl, right?
Did you run your snapshot agent?
ChrisB MCDBA
MSSQLConsulting.com
December 21, 2007 at 2:53 pm
--set unlimited if still having problems - need to do this in the log reader job.
-Querytimeout 0
ChrisB MCDBA
MSSQLConsulting.com
December 10, 2007 at 11:17 pm
This happened after you restored your publication database from backup?
I would re-init all subscriptions.
ChrisB MCDBA
MSSQLConsulting.com
December 10, 2007 at 11:12 pm
drop subscriptions to article / drop article / make schema changes / add subscription
exec sp_dropsubscription @publication = 'MyPubName'
, @article = ...
December 10, 2007 at 11:06 pm
Remove FK's at subscriber. Data integrity is controlled at publisher.
ChrisB MCDBA
MSSQLConsulting.com
December 10, 2007 at 10:54 pm
I would say, yes.
ChrisB MCDBA
MSSQLConsulting.com
December 10, 2007 at 10:48 pm
Get the latest service pack on SQL2000.
ChrisB MCDBA
MSSQLConsulting.com
December 6, 2007 at 1:17 pm
You don't have to drop entire subscription. YOu can drop a subscription for 1 table at a time - then add back in. Run snapshot agent, this only creates bcp...
December 5, 2007 at 12:50 am
You say you are updating - but the error is an insert - PK violation. Are there triggers on your merge tables? (Other then the merge triggers of course)
If not...
December 4, 2007 at 1:04 pm
Another use (dotcomboy) was having similar problem - here is his post:
dotcomboy-
I'm trying to setup a push replication from SQL 2005 to Oracle 10g and I'm getting errors. I've...
December 4, 2007 at 12:56 pm
I would assume replication needs 3 to 4 hours to deal with the large CRM batch job regardless of when you start & stop your agents. You should drill in...
December 4, 2007 at 12:51 pm
[publisher].[userdb].syspublications
[publisher].[userdb].sysarticles
[publisher].[master].sysservers where srvname = 'repl_distributor'
[distributor].distribution.MSsubscriptions
ChrisB
December 3, 2007 at 1:34 pm
In ent mgr you can expand the Replication folder on each server.
You will see publications only on a publisher. Expand publication to see each server subscribing to pub.
Right click...
December 3, 2007 at 1:00 pm
Viewing 15 posts - 31 through 45 (of 109 total)