Since we are on the subject of replication, I have a question for the group.

I am trying to implement Transactional Replication by doing a restore of a
dump and not using the snapshot. I am getting errors for NULL values trying
to be entered into Primary Key columns on the subscriber. I called Microsoft
and they said it was a problem with my triggers. They asked me to go through
each trigger (140) and add the syntax Not for replication. So my question
is, does this make sense and if so, is there a way to loop through in a
script and add that syntax to every trigger without going through everyone
of them individually?

Shawn Smith
Supervisor of Operations and Database Administration
Fort Worth Star-Telegram
817-390-7094
[Email Address Removed] Message-----
From: Long, Charles (euler:eti) [mailto:Charles.[Email Address Removed]
Sent: Thursday, December 12, 2002 9:06 AM
To: LazyDBA.com Discussion
Subject: RE: Replication Help


Hi Tony,

A good English dictionary (r for replication, c for common and s for sense)
sounds like a good start point for your man.

With heartfelt apologies, I think, in looking for what you've requested, I
may have found how what you're sensibly resisting could be done. It is
apparently possible to specify transformable replications using a DTS packet
in between. I have not investigated in depth; I noticed attached constraints
on updates in the subscriber, but I'm not sure how extensive they are.
Obviously if the database can only be updated by the distributor, the user
might as well have as many extra columns as he fancies - so long as the
disks come off his budget. It does occur to me that if transformable
distribution enables the requested feature but negates any potential
benefit as well, then the makings of a power-user-friendly argument would be
there.

Charles

> -----Original Message-----
> From: Maskevich, Tony [SMTP:Tony.[Email Address Removed] Sent: Thursday, December 12, 2002 2:03 PM
> To: LazyDBA.com Discussion
> Subject: Replication Help
>
> I have a user who wants to add a column to the subscription table in a
> SQL 2000 Transactional Replication Scenario. This causes it to fail
> as I expect but he is a power user and I need documentation to argue
> my point. Can anyone point me to a Microsoft Q article or a web link
> I can use to back up
> my argument.
>
> Any help would really be appreciated.
>
> Tony
>

---------------------------------------------------------------------
TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY To
unsubscribe, e-mail: mssqldba-[Email Address Removed] For additional
commands, e-mail: mssqldba-[Email Address Removed]MS Sql Server LazyDBA home page