Hi
Can someone please tell me, when i setup a publication for
transaction replication (push only), sometimes it says:
"SQL Server requires that all articles in a publication
allowing updatable subscriptions contain a
uniqueidentifier column named 'MSrepl_tran_version' used
for tracking changes to the replicated data. SQL Server
will add such a column to published tables that do not
have one"
But other times it does not ask to do this, and i have
successfully had a replication running without the
requirements is says. Do i need it or not?
Hi
If you want the changes to be replicated from the subscriber to publisher,
using immediate updating or queed updating, it becomes a requirement that
uniqueidentifier column is needed. If you dont want the reverse update, then
you may not need that column. Hope it helps
shrini
"gravity" <anonymous@.discussions.microsoft.com> wrote in message
news:1be901c42700$200f1880$a301280a@.phx.gbl...
> Hi
> Can someone please tell me, when i setup a publication for
> transaction replication (push only), sometimes it says:
> "SQL Server requires that all articles in a publication
> allowing updatable subscriptions contain a
> uniqueidentifier column named 'MSrepl_tran_version' used
> for tracking changes to the replicated data. SQL Server
> will add such a column to published tables that do not
> have one"
>
> But other times it does not ask to do this, and i have
> successfully had a replication running without the
> requirements is says. Do i need it or not?
Showing posts with label push. Show all posts
Showing posts with label push. Show all posts
Monday, March 26, 2012
Wednesday, March 21, 2012
msi push install upgrade
Is it possible to upgrade about 80 clients from SQL 7 client to SQL 2000
client automatically using group policy push and msi technology?
Aswered in .clients "Subject: SQL 7 to 2K client upgrade"
"Dex Dexter" wrote:
> Is it possible to upgrade about 80 clients from SQL 7 client to SQL 2000
> client automatically using group policy push and msi technology?
client automatically using group policy push and msi technology?
Aswered in .clients "Subject: SQL 7 to 2K client upgrade"
"Dex Dexter" wrote:
> Is it possible to upgrade about 80 clients from SQL 7 client to SQL 2000
> client automatically using group policy push and msi technology?
Subscribe to:
Posts (Atom)