I have seen conflicting info on this one:
Do I need to enable cross database ownership chaining on databases that
participate in Merge replication (publishers and subscribers)? I have seen
info pointing to maybe yes, maybe no...
anyone have comments on this?
DJC,
I'm not aware of any issues having been reported.
In what context have you heard of problems arising? Maybe from the SP3
readme - there was an issue which has been clarified in the ReadMe
additions:
Clarification to Section 5.3.17 - Change to Requirements for Attaching or
Restoring a Replication Database
Section 5.3.17 "Change to Requirements for Attaching or Restoring a
Replication Database" in the SQL Server 2000 SP3 Readme file incorrectly
implies that enabling cross-database ownership chaining is a requirement for
attaching or restoring replication databases after SQL Server 2000 SP3 has
been applied. The preferred method for attaching or restoring databases
after applying SQL Server 2000 SP3, is to have a member of the sysadmin
fixed server role run the sp_changedbowner stored procedure to assign
ownership of the database to the sa built-in administrator logon. For
example:
Regards,
Paul Ibison
sql
Showing posts with label merge. Show all posts
Showing posts with label merge. Show all posts
Sunday, March 25, 2012
Thursday, March 22, 2012
Do I have to reinitialize snapshot if a new table added?
Hello,
After creating a publication for Merge Replication, if I need to add or drop a simple table, do I have to reinitialize the snapshot all over again?
Thanks
Ekrem ?nsoy
Hello again,
I'm sorry for taking your time but I've found the answer from the Books Online (http://msdn2.microsoft.com/en-us/library/ms152493.aspx)
Thanks
Ekrem ?nsoy
Monday, March 19, 2012
DMo Example of merge replication
I purchased the SQL DMO book that Mark Allison participated in writing. I
read the chapter on merge replication , however, the chapter only discusses
the setup / config of merge replication. I am interested in the code where a
user would click a button and start a pull subscription. Does anyone have
any examples to share or guidance?
Paul - the first link doesn't work and the second one is a link to info about
the ActiveX object.
I am looking for info specifically on SQL DMO and merge replication.
Any other ideas?
"MSSQLServerDeveloper" wrote:
> I purchased the SQL DMO book that Mark Allison participated in writing. I
> read the chapter on merge replication , however, the chapter only discusses
> the setup / config of merge replication. I am interested in the code where a
> user would click a button and start a pull subscription. Does anyone have
> any examples to share or guidance?
>
|||The first link works - it's just that the text has wrapped in the message. I
don't know of a specifically SQLDMO script which initializes or synchronizes
replication, but the ActiveX object is designed for specifically this use.
Rgds,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)
|||try something like this
Option explicit
Const SQLDMOSubscription_Anonymous = 2
Const SQLDMOReplSecurity_Normal = 0
Const SQLDMOReplSecurity_Integrated = 1
Const SQLDMOSubscription_All = 3
Const SQLDMOMergeSubscriber_Default = 2
dim objServer,objReplication,objReplicationDatabases,o bjReplicationDatabase,
objMergePullSubscription,objMergePullSubscriptions , objReplicationSecurity
set objServer = CreateObject("SQLDMO.SQLServer")
objServer.Connect
"SubscriberServerName","sa","PaulIbisonIsADoofusAn dHeDancesLikeAGurl"
set objReplication=objServer.Replication
set objReplicationDatabases=objReplication.Replication Databases
set objReplicationDatabase=objReplicationDatabases("su b")
set objMergePullSubscription=CreateObject("SQLDMO.Merg ePullSubscription2")
set objReplicationSecurity=objMergePullSubscription.Di stributorSecurity
objReplicationSecurity.SecurityMode=SQLDMOReplSecu rity_Normal
objReplicationSecurity.StandardLogin="sa"
objReplicationSecurity.StandardPassword="PaulIbiso nIsADoofusAndHeDancesLikeA
Gurl"
with objMergePullSubscription
.AltSnapshotFolder="C:\temp\"
.Distributor="PublisherServerName"
.DistributorSecurity.SecurityMode=SQLDMOReplSecuri ty_Normal
.DistributorSecurity.StandardLogin="sa"
..DistributorSecurity.StandardPassword="PaulIbison IsADoofusAndHeDancesLikeAGu
rl"
.Publisher= "PublisherServerName"
.PublicationDB="pubs"
.Publication="test"
.PublisherSecurity.SecurityMode=SQLDMOReplSecurity _Normal
.PublisherSecurity.StandardLogin="sa"
.PublisherSecurity.StandardPassword="se1cure#"
.SubscriberType =SQLDMOMergeSubscriber_Default
.SubscriptionType = SQLDMOSubscription_Anonymous
.SubscriberSecurityMode=SQLDMOReplSecurity_Normal
.SubscriberLogin="sa"
.SubscriberPassword="PaulIbisonIsADoofusAndHeDance sLikeAGurl"
.UseFTP=False
end with
set objMergePullSubscriptions=objReplicationDatabase.M ergePullSubscriptions
objMergePullSubscriptions.Add objMergePullSubscription
set objMergePullSubscription=Nothing
set objMergePullSubscriptions=Nothing
set objReplicationDatabases=Nothing
set objReplication=Nothing
set objServer=Nothing
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
"MSSQLServerDeveloper" <MSSQLServerDeveloper@.discussions.microsoft.com>
wrote in message news:AAE00CF7-C4FD-48D2-A815-FF60B824D249@.microsoft.com...
> I purchased the SQL DMO book that Mark Allison participated in writing. I
> read the chapter on merge replication , however, the chapter only
discusses
> the setup / config of merge replication. I am interested in the code
where a
> user would click a button and start a pull subscription. Does anyone have
> any examples to share or guidance?
>
|||Hilary - Thanks very much - I'll give it a try. Not til next week, but I
will keep you posted. Regards
"Hilary Cotter" wrote:
> try something like this
> Option explicit
> Const SQLDMOSubscription_Anonymous = 2
> Const SQLDMOReplSecurity_Normal = 0
> Const SQLDMOReplSecurity_Integrated = 1
> Const SQLDMOSubscription_All = 3
> Const SQLDMOMergeSubscriber_Default = 2
> dim objServer,objReplication,objReplicationDatabases,o bjReplicationDatabase,
> objMergePullSubscription,objMergePullSubscriptions , objReplicationSecurity
> set objServer = CreateObject("SQLDMO.SQLServer")
> objServer.Connect
> "SubscriberServerName","sa","PaulIbisonIsADoofusAn dHeDancesLikeAGurl"
> set objReplication=objServer.Replication
> set objReplicationDatabases=objReplication.Replication Databases
> set objReplicationDatabase=objReplicationDatabases("su b")
> set objMergePullSubscription=CreateObject("SQLDMO.Merg ePullSubscription2")
> set objReplicationSecurity=objMergePullSubscription.Di stributorSecurity
> objReplicationSecurity.SecurityMode=SQLDMOReplSecu rity_Normal
> objReplicationSecurity.StandardLogin="sa"
> objReplicationSecurity.StandardPassword="PaulIbiso nIsADoofusAndHeDancesLikeA
> Gurl"
> with objMergePullSubscription
> .AltSnapshotFolder="C:\temp\"
> .Distributor="PublisherServerName"
> .DistributorSecurity.SecurityMode=SQLDMOReplSecuri ty_Normal
> .DistributorSecurity.StandardLogin="sa"
> ..DistributorSecurity.StandardPassword="PaulIbison IsADoofusAndHeDancesLikeAGu
> rl"
> .Publisher= "PublisherServerName"
> .PublicationDB="pubs"
> .Publication="test"
> .PublisherSecurity.SecurityMode=SQLDMOReplSecurity _Normal
> .PublisherSecurity.StandardLogin="sa"
> .PublisherSecurity.StandardPassword="se1cure#"
> .SubscriberType =SQLDMOMergeSubscriber_Default
> .SubscriptionType = SQLDMOSubscription_Anonymous
> .SubscriberSecurityMode=SQLDMOReplSecurity_Normal
> .SubscriberLogin="sa"
> .SubscriberPassword="PaulIbisonIsADoofusAndHeDance sLikeAGurl"
> .UseFTP=False
> end with
> set objMergePullSubscriptions=objReplicationDatabase.M ergePullSubscriptions
> objMergePullSubscriptions.Add objMergePullSubscription
> set objMergePullSubscription=Nothing
> set objMergePullSubscriptions=Nothing
> set objReplicationDatabases=Nothing
> set objReplication=Nothing
> set objServer=Nothing
>
> --
> Hilary Cotter
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602.html
> "MSSQLServerDeveloper" <MSSQLServerDeveloper@.discussions.microsoft.com>
> wrote in message news:AAE00CF7-C4FD-48D2-A815-FF60B824D249@.microsoft.com...
> discusses
> where a
>
>
|||btw - I like the password.
"Hilary Cotter" wrote:
> try something like this
> Option explicit
> Const SQLDMOSubscription_Anonymous = 2
> Const SQLDMOReplSecurity_Normal = 0
> Const SQLDMOReplSecurity_Integrated = 1
> Const SQLDMOSubscription_All = 3
> Const SQLDMOMergeSubscriber_Default = 2
> dim objServer,objReplication,objReplicationDatabases,o bjReplicationDatabase,
> objMergePullSubscription,objMergePullSubscriptions , objReplicationSecurity
> set objServer = CreateObject("SQLDMO.SQLServer")
> objServer.Connect
> "SubscriberServerName","sa","PaulIbisonIsADoofusAn dHeDancesLikeAGurl"
> set objReplication=objServer.Replication
> set objReplicationDatabases=objReplication.Replication Databases
> set objReplicationDatabase=objReplicationDatabases("su b")
> set objMergePullSubscription=CreateObject("SQLDMO.Merg ePullSubscription2")
> set objReplicationSecurity=objMergePullSubscription.Di stributorSecurity
> objReplicationSecurity.SecurityMode=SQLDMOReplSecu rity_Normal
> objReplicationSecurity.StandardLogin="sa"
> objReplicationSecurity.StandardPassword="PaulIbiso nIsADoofusAndHeDancesLikeA
> Gurl"
> with objMergePullSubscription
> .AltSnapshotFolder="C:\temp\"
> .Distributor="PublisherServerName"
> .DistributorSecurity.SecurityMode=SQLDMOReplSecuri ty_Normal
> .DistributorSecurity.StandardLogin="sa"
> ..DistributorSecurity.StandardPassword="PaulIbison IsADoofusAndHeDancesLikeAGu
> rl"
> .Publisher= "PublisherServerName"
> .PublicationDB="pubs"
> .Publication="test"
> .PublisherSecurity.SecurityMode=SQLDMOReplSecurity _Normal
> .PublisherSecurity.StandardLogin="sa"
> .PublisherSecurity.StandardPassword="se1cure#"
> .SubscriberType =SQLDMOMergeSubscriber_Default
> .SubscriptionType = SQLDMOSubscription_Anonymous
> .SubscriberSecurityMode=SQLDMOReplSecurity_Normal
> .SubscriberLogin="sa"
> .SubscriberPassword="PaulIbisonIsADoofusAndHeDance sLikeAGurl"
> .UseFTP=False
> end with
> set objMergePullSubscriptions=objReplicationDatabase.M ergePullSubscriptions
> objMergePullSubscriptions.Add objMergePullSubscription
> set objMergePullSubscription=Nothing
> set objMergePullSubscriptions=Nothing
> set objReplicationDatabases=Nothing
> set objReplication=Nothing
> set objServer=Nothing
>
> --
> Hilary Cotter
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602.html
> "MSSQLServerDeveloper" <MSSQLServerDeveloper@.discussions.microsoft.com>
> wrote in message news:AAE00CF7-C4FD-48D2-A815-FF60B824D249@.microsoft.com...
> discusses
> where a
>
>
|||Hilary,
what makes me think you're getting that Friday feeling?
Paul
|||was it the virus I emailed you? The postings I have being doing in your name
in alt.bedwetting? The huge amount of spam I have been sending out in your
name?
Please help me figure this one out?
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
"Paul Ibison" <Paul.Ibison@.Pygmalion.Com> wrote in message
news:071101c4ffe3$937a9580$a501280a@.phx.gbl...
> Hilary,
> what makes me think you're getting that Friday feeling?
> Paul
|||Ah,
so you're the reason I keep getting orders for caseloads
of Viagra and penile extension operations. Might have
known. Anyway, must dash - it's 7:15 on Friday evening,
there's nobody else here and I'm the mug who'se doing the
database rollouts.
Paul
|||um...that wasn't me - must have been your wife!
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
"Paul" <anonymous@.discussions.microsoft.com> wrote in message
news:077b01c4ffed$3e18a0f0$a501280a@.phx.gbl...
> Ah,
> so you're the reason I keep getting orders for caseloads
> of Viagra and penile extension operations. Might have
> known. Anyway, must dash - it's 7:15 on Friday evening,
> there's nobody else here and I'm the mug who'se doing the
> database rollouts.
> Paul
>
read the chapter on merge replication , however, the chapter only discusses
the setup / config of merge replication. I am interested in the code where a
user would click a button and start a pull subscription. Does anyone have
any examples to share or guidance?
Paul - the first link doesn't work and the second one is a link to info about
the ActiveX object.
I am looking for info specifically on SQL DMO and merge replication.
Any other ideas?
"MSSQLServerDeveloper" wrote:
> I purchased the SQL DMO book that Mark Allison participated in writing. I
> read the chapter on merge replication , however, the chapter only discusses
> the setup / config of merge replication. I am interested in the code where a
> user would click a button and start a pull subscription. Does anyone have
> any examples to share or guidance?
>
|||The first link works - it's just that the text has wrapped in the message. I
don't know of a specifically SQLDMO script which initializes or synchronizes
replication, but the ActiveX object is designed for specifically this use.
Rgds,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)
|||try something like this
Option explicit
Const SQLDMOSubscription_Anonymous = 2
Const SQLDMOReplSecurity_Normal = 0
Const SQLDMOReplSecurity_Integrated = 1
Const SQLDMOSubscription_All = 3
Const SQLDMOMergeSubscriber_Default = 2
dim objServer,objReplication,objReplicationDatabases,o bjReplicationDatabase,
objMergePullSubscription,objMergePullSubscriptions , objReplicationSecurity
set objServer = CreateObject("SQLDMO.SQLServer")
objServer.Connect
"SubscriberServerName","sa","PaulIbisonIsADoofusAn dHeDancesLikeAGurl"
set objReplication=objServer.Replication
set objReplicationDatabases=objReplication.Replication Databases
set objReplicationDatabase=objReplicationDatabases("su b")
set objMergePullSubscription=CreateObject("SQLDMO.Merg ePullSubscription2")
set objReplicationSecurity=objMergePullSubscription.Di stributorSecurity
objReplicationSecurity.SecurityMode=SQLDMOReplSecu rity_Normal
objReplicationSecurity.StandardLogin="sa"
objReplicationSecurity.StandardPassword="PaulIbiso nIsADoofusAndHeDancesLikeA
Gurl"
with objMergePullSubscription
.AltSnapshotFolder="C:\temp\"
.Distributor="PublisherServerName"
.DistributorSecurity.SecurityMode=SQLDMOReplSecuri ty_Normal
.DistributorSecurity.StandardLogin="sa"
..DistributorSecurity.StandardPassword="PaulIbison IsADoofusAndHeDancesLikeAGu
rl"
.Publisher= "PublisherServerName"
.PublicationDB="pubs"
.Publication="test"
.PublisherSecurity.SecurityMode=SQLDMOReplSecurity _Normal
.PublisherSecurity.StandardLogin="sa"
.PublisherSecurity.StandardPassword="se1cure#"
.SubscriberType =SQLDMOMergeSubscriber_Default
.SubscriptionType = SQLDMOSubscription_Anonymous
.SubscriberSecurityMode=SQLDMOReplSecurity_Normal
.SubscriberLogin="sa"
.SubscriberPassword="PaulIbisonIsADoofusAndHeDance sLikeAGurl"
.UseFTP=False
end with
set objMergePullSubscriptions=objReplicationDatabase.M ergePullSubscriptions
objMergePullSubscriptions.Add objMergePullSubscription
set objMergePullSubscription=Nothing
set objMergePullSubscriptions=Nothing
set objReplicationDatabases=Nothing
set objReplication=Nothing
set objServer=Nothing
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
"MSSQLServerDeveloper" <MSSQLServerDeveloper@.discussions.microsoft.com>
wrote in message news:AAE00CF7-C4FD-48D2-A815-FF60B824D249@.microsoft.com...
> I purchased the SQL DMO book that Mark Allison participated in writing. I
> read the chapter on merge replication , however, the chapter only
discusses
> the setup / config of merge replication. I am interested in the code
where a
> user would click a button and start a pull subscription. Does anyone have
> any examples to share or guidance?
>
|||Hilary - Thanks very much - I'll give it a try. Not til next week, but I
will keep you posted. Regards
"Hilary Cotter" wrote:
> try something like this
> Option explicit
> Const SQLDMOSubscription_Anonymous = 2
> Const SQLDMOReplSecurity_Normal = 0
> Const SQLDMOReplSecurity_Integrated = 1
> Const SQLDMOSubscription_All = 3
> Const SQLDMOMergeSubscriber_Default = 2
> dim objServer,objReplication,objReplicationDatabases,o bjReplicationDatabase,
> objMergePullSubscription,objMergePullSubscriptions , objReplicationSecurity
> set objServer = CreateObject("SQLDMO.SQLServer")
> objServer.Connect
> "SubscriberServerName","sa","PaulIbisonIsADoofusAn dHeDancesLikeAGurl"
> set objReplication=objServer.Replication
> set objReplicationDatabases=objReplication.Replication Databases
> set objReplicationDatabase=objReplicationDatabases("su b")
> set objMergePullSubscription=CreateObject("SQLDMO.Merg ePullSubscription2")
> set objReplicationSecurity=objMergePullSubscription.Di stributorSecurity
> objReplicationSecurity.SecurityMode=SQLDMOReplSecu rity_Normal
> objReplicationSecurity.StandardLogin="sa"
> objReplicationSecurity.StandardPassword="PaulIbiso nIsADoofusAndHeDancesLikeA
> Gurl"
> with objMergePullSubscription
> .AltSnapshotFolder="C:\temp\"
> .Distributor="PublisherServerName"
> .DistributorSecurity.SecurityMode=SQLDMOReplSecuri ty_Normal
> .DistributorSecurity.StandardLogin="sa"
> ..DistributorSecurity.StandardPassword="PaulIbison IsADoofusAndHeDancesLikeAGu
> rl"
> .Publisher= "PublisherServerName"
> .PublicationDB="pubs"
> .Publication="test"
> .PublisherSecurity.SecurityMode=SQLDMOReplSecurity _Normal
> .PublisherSecurity.StandardLogin="sa"
> .PublisherSecurity.StandardPassword="se1cure#"
> .SubscriberType =SQLDMOMergeSubscriber_Default
> .SubscriptionType = SQLDMOSubscription_Anonymous
> .SubscriberSecurityMode=SQLDMOReplSecurity_Normal
> .SubscriberLogin="sa"
> .SubscriberPassword="PaulIbisonIsADoofusAndHeDance sLikeAGurl"
> .UseFTP=False
> end with
> set objMergePullSubscriptions=objReplicationDatabase.M ergePullSubscriptions
> objMergePullSubscriptions.Add objMergePullSubscription
> set objMergePullSubscription=Nothing
> set objMergePullSubscriptions=Nothing
> set objReplicationDatabases=Nothing
> set objReplication=Nothing
> set objServer=Nothing
>
> --
> Hilary Cotter
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602.html
> "MSSQLServerDeveloper" <MSSQLServerDeveloper@.discussions.microsoft.com>
> wrote in message news:AAE00CF7-C4FD-48D2-A815-FF60B824D249@.microsoft.com...
> discusses
> where a
>
>
|||btw - I like the password.
"Hilary Cotter" wrote:
> try something like this
> Option explicit
> Const SQLDMOSubscription_Anonymous = 2
> Const SQLDMOReplSecurity_Normal = 0
> Const SQLDMOReplSecurity_Integrated = 1
> Const SQLDMOSubscription_All = 3
> Const SQLDMOMergeSubscriber_Default = 2
> dim objServer,objReplication,objReplicationDatabases,o bjReplicationDatabase,
> objMergePullSubscription,objMergePullSubscriptions , objReplicationSecurity
> set objServer = CreateObject("SQLDMO.SQLServer")
> objServer.Connect
> "SubscriberServerName","sa","PaulIbisonIsADoofusAn dHeDancesLikeAGurl"
> set objReplication=objServer.Replication
> set objReplicationDatabases=objReplication.Replication Databases
> set objReplicationDatabase=objReplicationDatabases("su b")
> set objMergePullSubscription=CreateObject("SQLDMO.Merg ePullSubscription2")
> set objReplicationSecurity=objMergePullSubscription.Di stributorSecurity
> objReplicationSecurity.SecurityMode=SQLDMOReplSecu rity_Normal
> objReplicationSecurity.StandardLogin="sa"
> objReplicationSecurity.StandardPassword="PaulIbiso nIsADoofusAndHeDancesLikeA
> Gurl"
> with objMergePullSubscription
> .AltSnapshotFolder="C:\temp\"
> .Distributor="PublisherServerName"
> .DistributorSecurity.SecurityMode=SQLDMOReplSecuri ty_Normal
> .DistributorSecurity.StandardLogin="sa"
> ..DistributorSecurity.StandardPassword="PaulIbison IsADoofusAndHeDancesLikeAGu
> rl"
> .Publisher= "PublisherServerName"
> .PublicationDB="pubs"
> .Publication="test"
> .PublisherSecurity.SecurityMode=SQLDMOReplSecurity _Normal
> .PublisherSecurity.StandardLogin="sa"
> .PublisherSecurity.StandardPassword="se1cure#"
> .SubscriberType =SQLDMOMergeSubscriber_Default
> .SubscriptionType = SQLDMOSubscription_Anonymous
> .SubscriberSecurityMode=SQLDMOReplSecurity_Normal
> .SubscriberLogin="sa"
> .SubscriberPassword="PaulIbisonIsADoofusAndHeDance sLikeAGurl"
> .UseFTP=False
> end with
> set objMergePullSubscriptions=objReplicationDatabase.M ergePullSubscriptions
> objMergePullSubscriptions.Add objMergePullSubscription
> set objMergePullSubscription=Nothing
> set objMergePullSubscriptions=Nothing
> set objReplicationDatabases=Nothing
> set objReplication=Nothing
> set objServer=Nothing
>
> --
> Hilary Cotter
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602.html
> "MSSQLServerDeveloper" <MSSQLServerDeveloper@.discussions.microsoft.com>
> wrote in message news:AAE00CF7-C4FD-48D2-A815-FF60B824D249@.microsoft.com...
> discusses
> where a
>
>
|||Hilary,
what makes me think you're getting that Friday feeling?
Paul
|||was it the virus I emailed you? The postings I have being doing in your name
in alt.bedwetting? The huge amount of spam I have been sending out in your
name?
Please help me figure this one out?
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
"Paul Ibison" <Paul.Ibison@.Pygmalion.Com> wrote in message
news:071101c4ffe3$937a9580$a501280a@.phx.gbl...
> Hilary,
> what makes me think you're getting that Friday feeling?
> Paul
|||Ah,
so you're the reason I keep getting orders for caseloads
of Viagra and penile extension operations. Might have
known. Anyway, must dash - it's 7:15 on Friday evening,
there's nobody else here and I'm the mug who'se doing the
database rollouts.
Paul
|||um...that wasn't me - must have been your wife!
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
"Paul" <anonymous@.discussions.microsoft.com> wrote in message
news:077b01c4ffed$3e18a0f0$a501280a@.phx.gbl...
> Ah,
> so you're the reason I keep getting orders for caseloads
> of Viagra and penile extension operations. Might have
> known. Anyway, must dash - it's 7:15 on Friday evening,
> there's nobody else here and I'm the mug who'se doing the
> database rollouts.
> Paul
>
DMO Anonymous Merge Pull
I adapted Hilary's DMO Example, and have tried ReplCtrl\VB\ReplSamp.vbp ...
WHAT CODE DO I NEED to .Initialize .Run .Terminate the SQLMerge?
Subscription was created using Windows Synchronization Manager,
Administrator Account on WinXPPro Laptop. VB is running in MS Access XP
Runtime .ade
CODE looks good, but is still missing 'something'
DMO Example -- last line is
objMergePullSubscriptions.Add objMergPullSubscription
Obviously FAILS because 'The subscription already exists.'
AIRCODE; Run via VPN to namedserver
Option Compare Database
Option Explicit
Private Sub cmdMergePublication_Click()
'On Error GoTo Err_cmdMergePublication_Click
Const SQLDMOSubscription_Anonymous = 2
Const SQLDMOReplSecurity_Normal = 0
Const SQLDMOReplSecurity_Integrated = 1
Const SQLDMOSubscription_All = 3
Const SQLDMOMergeSubscriber_Default = 2
Dim objServer, objReplication, objReplicationDatabases, objReplicationDatabase
Dim objMergePullSubscription, objMergePullSubscriptions,
objReplicationSecurity
Set objServer = CreateObject("SQLDMO.SQLServer")
objServer.Connect ".", "sa", "nyrv%fa"
Set objReplication = objServer.Replication
Set objReplicationDatabases = objReplication.ReplicationDatabases
Set objReplicationDatabase = objReplicationDatabases("CareSQL50207")
Set objMergePullSubscription = CreateObject("SQLDMO.MergePullSubscription2")
Set objReplicationSecurity = objMergePullSubscription.DistributorSecurity
objReplicationSecurity.SecurityMode = SQLDMOReplSecurity_Normal
objReplicationSecurity.StandardLogin = "sa"
objReplicationSecurity.StandardPassword = "d23&tmv"
With objMergePullSubscription
.AltSnapshotFolder = "C:\temp\"
.Distributor = "GSHSBS2000"
.DistributorSecurity.SecurityMode = SQLDMOReplSecurity_Normal
.DistributorSecurity.StandardLogin = "sa"
.DistributorSecurity.StandardPassword = "nyrv%fa"
.Publisher = "GSHSBS2000"
.PublicationDB = "CareSQL50207"
.Publication = "CareSQL50207"
.PublisherSecurity.SecurityMode = SQLDMOReplSecurity_Normal
.PublisherSecurity.StandardLogin = "sa"
.PublisherSecurity.StandardPassword = "nyrv%fa"
.SubscriberType = SQLDMOMergeSubscriber_Default
.SubscriptionType = SQLDMOSubscription_Anonymous
.SubscriberSecurityMode = SQLDMOReplSecurity_Normal
.SubscriberLogin = "sa"
.SubscriberPassword = "d23&tmv"
.UseFTP = False
End With
Set objMergePullSubscriptions = objReplicationDatabase.MergePullSubscriptions
'$$$$$ STOPS here: [MS][ODBC][SQLServer] The subscription already exists.
objMergePullSubscriptions.Add objMergePullSubscription
Set objMergePullSubscription = Nothing
Set objMergePullSubscriptions = Nothing
Set objReplicationDatabases = Nothing
Set objReplication = Nothing
Set objServer = Nothing
Exit_cmdMergePublication_Click:
Exit Sub
Err_cmdMergePublication_Click:
MsgBox Err.Description
Resume Exit_cmdMergePublication_Click
End Sub
TIA
Aubrey Kelley
this is to create the job, not to start it. I've been puzzling for a good
long while on trying to figure out how to start it.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Aubrey" <Aubrey@.discussions.microsoft.com> wrote in message
news:9D3A8AF9-7A89-4BCA-B3A4-0D564D00C217@.microsoft.com...
> I adapted Hilary's DMO Example, and have tried ReplCtrl\VB\ReplSamp.vbp
...
> WHAT CODE DO I NEED to .Initialize .Run .Terminate the SQLMerge?
>
> Subscription was created using Windows Synchronization Manager,
> Administrator Account on WinXPPro Laptop. VB is running in MS Access XP
> Runtime .ade
> CODE looks good, but is still missing 'something'
> DMO Example -- last line is
> objMergePullSubscriptions.Add objMergPullSubscription
> Obviously FAILS because 'The subscription already exists.'
>
> AIRCODE; Run via VPN to namedserver
> Option Compare Database
> Option Explicit
> Private Sub cmdMergePublication_Click()
> 'On Error GoTo Err_cmdMergePublication_Click
> Const SQLDMOSubscription_Anonymous = 2
> Const SQLDMOReplSecurity_Normal = 0
> Const SQLDMOReplSecurity_Integrated = 1
> Const SQLDMOSubscription_All = 3
> Const SQLDMOMergeSubscriber_Default = 2
> Dim objServer, objReplication, objReplicationDatabases,
objReplicationDatabase
> Dim objMergePullSubscription, objMergePullSubscriptions,
> objReplicationSecurity
> Set objServer = CreateObject("SQLDMO.SQLServer")
> objServer.Connect ".", "sa", "nyrv%fa"
> Set objReplication = objServer.Replication
> Set objReplicationDatabases = objReplication.ReplicationDatabases
> Set objReplicationDatabase = objReplicationDatabases("CareSQL50207")
> Set objMergePullSubscription =
CreateObject("SQLDMO.MergePullSubscription2")
> Set objReplicationSecurity = objMergePullSubscription.DistributorSecurity
> objReplicationSecurity.SecurityMode = SQLDMOReplSecurity_Normal
> objReplicationSecurity.StandardLogin = "sa"
> objReplicationSecurity.StandardPassword = "d23&tmv"
> With objMergePullSubscription
> .AltSnapshotFolder = "C:\temp\"
> .Distributor = "GSHSBS2000"
> .DistributorSecurity.SecurityMode = SQLDMOReplSecurity_Normal
> .DistributorSecurity.StandardLogin = "sa"
> .DistributorSecurity.StandardPassword = "nyrv%fa"
> .Publisher = "GSHSBS2000"
> .PublicationDB = "CareSQL50207"
> .Publication = "CareSQL50207"
> .PublisherSecurity.SecurityMode = SQLDMOReplSecurity_Normal
> .PublisherSecurity.StandardLogin = "sa"
> .PublisherSecurity.StandardPassword = "nyrv%fa"
> .SubscriberType = SQLDMOMergeSubscriber_Default
> .SubscriptionType = SQLDMOSubscription_Anonymous
> .SubscriberSecurityMode = SQLDMOReplSecurity_Normal
> .SubscriberLogin = "sa"
> .SubscriberPassword = "d23&tmv"
> .UseFTP = False
> End With
> Set objMergePullSubscriptions =
objReplicationDatabase.MergePullSubscriptions
> '$$$$$ STOPS here: [MS][ODBC][SQLServer] The subscription already exists.
> objMergePullSubscriptions.Add objMergePullSubscription
> Set objMergePullSubscription = Nothing
> Set objMergePullSubscriptions = Nothing
> Set objReplicationDatabases = Nothing
> Set objReplication = Nothing
> Set objServer = Nothing
> Exit_cmdMergePublication_Click:
> Exit Sub
> Err_cmdMergePublication_Click:
> MsgBox Err.Description
> Resume Exit_cmdMergePublication_Click
> End Sub
> --
> TIA
> Aubrey Kelley
|||Ouch! At least now I do not feel 'so dumb'. Maybe PSS will be helpful now
that we are so far. Nothing but dead ends in the past ...
Aubrey
"Hilary Cotter" wrote:
> this is to create the job, not to start it. I've been puzzling for a good
> long while on trying to figure out how to start it.
> --
> Hilary Cotter
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602.html
> Looking for a FAQ on Indexing Services/SQL FTS
> http://www.indexserverfaq.com
> "Aubrey" <Aubrey@.discussions.microsoft.com> wrote in message
> news:9D3A8AF9-7A89-4BCA-B3A4-0D564D00C217@.microsoft.com...
> ...
> objReplicationDatabase
> CreateObject("SQLDMO.MergePullSubscription2")
> objReplicationDatabase.MergePullSubscriptions
>
>
|||here is what I have so far - this will spill the anmes of the anonymous pull
subscriptions in the database Northwindsub.
Can't seem to get it to resolve to the job_id's for the merge pull though.
set objSQLServer=CreateObject("SQLDMO.SQLServer")
objSQLServer.loginSecure=True
objSQLServer.Connect "Publisher"
set objReplication=objSQLServer.Replication
wscript.echo objReplication.Distributor.DistributionServer
set objReplicationDatabase =
objReplication.ReplicationDatabases("Northwindsub" )
for each objMergepullSubscription in
objReplicationDatabase.MergepullSubscriptions
wscript.echo "objMergepullSubscription.Name"
wscript.echo objMergepullSubscription.Name
wscript.echo "objMergepullSubscription.MergeJObID"
wscript.echo objMergepullSubscription.MergeJObID
set QueryResults=objMergepullSubscription.EnumJobInfo
for b=1 to QueryResults.Rows
for a=1 to QueryResults.Columns
wscript.echo QueryResults.ColumnName(A)
wscript.echo QueryResults.GetColumnString(b,A)
next
next
wscript.echo objReplication.Distributor.DistributionServer
set QueryResults=objReplication.Distributor.EnumMergeA gentViews()
for b=1 to QueryResults.Rows
for a=1 to QueryResults.Columns
wscript.echo QueryResults.ColumnName(A)
wscript.echo QueryResults.GetColumnString(b,A)
next
next
set objDistributor=Nothing
next
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Aubrey" <Aubrey@.discussions.microsoft.com> wrote in message
news:2F4F23EF-3F58-44CD-8620-4BBA107F649F@.microsoft.com...[vbcol=seagreen]
> Ouch! At least now I do not feel 'so dumb'. Maybe PSS will be helpful now
> that we are so far. Nothing but dead ends in the past ...
> Aubrey
> "Hilary Cotter" wrote:
good[vbcol=seagreen]
ReplCtrl\VB\ReplSamp.vbp[vbcol=seagreen]
XP[vbcol=seagreen]
objMergePullSubscription.DistributorSecurity[vbcol=seagreen]
exists.[vbcol=seagreen]
WHAT CODE DO I NEED to .Initialize .Run .Terminate the SQLMerge?
Subscription was created using Windows Synchronization Manager,
Administrator Account on WinXPPro Laptop. VB is running in MS Access XP
Runtime .ade
CODE looks good, but is still missing 'something'
DMO Example -- last line is
objMergePullSubscriptions.Add objMergPullSubscription
Obviously FAILS because 'The subscription already exists.'
AIRCODE; Run via VPN to namedserver
Option Compare Database
Option Explicit
Private Sub cmdMergePublication_Click()
'On Error GoTo Err_cmdMergePublication_Click
Const SQLDMOSubscription_Anonymous = 2
Const SQLDMOReplSecurity_Normal = 0
Const SQLDMOReplSecurity_Integrated = 1
Const SQLDMOSubscription_All = 3
Const SQLDMOMergeSubscriber_Default = 2
Dim objServer, objReplication, objReplicationDatabases, objReplicationDatabase
Dim objMergePullSubscription, objMergePullSubscriptions,
objReplicationSecurity
Set objServer = CreateObject("SQLDMO.SQLServer")
objServer.Connect ".", "sa", "nyrv%fa"
Set objReplication = objServer.Replication
Set objReplicationDatabases = objReplication.ReplicationDatabases
Set objReplicationDatabase = objReplicationDatabases("CareSQL50207")
Set objMergePullSubscription = CreateObject("SQLDMO.MergePullSubscription2")
Set objReplicationSecurity = objMergePullSubscription.DistributorSecurity
objReplicationSecurity.SecurityMode = SQLDMOReplSecurity_Normal
objReplicationSecurity.StandardLogin = "sa"
objReplicationSecurity.StandardPassword = "d23&tmv"
With objMergePullSubscription
.AltSnapshotFolder = "C:\temp\"
.Distributor = "GSHSBS2000"
.DistributorSecurity.SecurityMode = SQLDMOReplSecurity_Normal
.DistributorSecurity.StandardLogin = "sa"
.DistributorSecurity.StandardPassword = "nyrv%fa"
.Publisher = "GSHSBS2000"
.PublicationDB = "CareSQL50207"
.Publication = "CareSQL50207"
.PublisherSecurity.SecurityMode = SQLDMOReplSecurity_Normal
.PublisherSecurity.StandardLogin = "sa"
.PublisherSecurity.StandardPassword = "nyrv%fa"
.SubscriberType = SQLDMOMergeSubscriber_Default
.SubscriptionType = SQLDMOSubscription_Anonymous
.SubscriberSecurityMode = SQLDMOReplSecurity_Normal
.SubscriberLogin = "sa"
.SubscriberPassword = "d23&tmv"
.UseFTP = False
End With
Set objMergePullSubscriptions = objReplicationDatabase.MergePullSubscriptions
'$$$$$ STOPS here: [MS][ODBC][SQLServer] The subscription already exists.
objMergePullSubscriptions.Add objMergePullSubscription
Set objMergePullSubscription = Nothing
Set objMergePullSubscriptions = Nothing
Set objReplicationDatabases = Nothing
Set objReplication = Nothing
Set objServer = Nothing
Exit_cmdMergePublication_Click:
Exit Sub
Err_cmdMergePublication_Click:
MsgBox Err.Description
Resume Exit_cmdMergePublication_Click
End Sub
TIA
Aubrey Kelley
this is to create the job, not to start it. I've been puzzling for a good
long while on trying to figure out how to start it.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Aubrey" <Aubrey@.discussions.microsoft.com> wrote in message
news:9D3A8AF9-7A89-4BCA-B3A4-0D564D00C217@.microsoft.com...
> I adapted Hilary's DMO Example, and have tried ReplCtrl\VB\ReplSamp.vbp
...
> WHAT CODE DO I NEED to .Initialize .Run .Terminate the SQLMerge?
>
> Subscription was created using Windows Synchronization Manager,
> Administrator Account on WinXPPro Laptop. VB is running in MS Access XP
> Runtime .ade
> CODE looks good, but is still missing 'something'
> DMO Example -- last line is
> objMergePullSubscriptions.Add objMergPullSubscription
> Obviously FAILS because 'The subscription already exists.'
>
> AIRCODE; Run via VPN to namedserver
> Option Compare Database
> Option Explicit
> Private Sub cmdMergePublication_Click()
> 'On Error GoTo Err_cmdMergePublication_Click
> Const SQLDMOSubscription_Anonymous = 2
> Const SQLDMOReplSecurity_Normal = 0
> Const SQLDMOReplSecurity_Integrated = 1
> Const SQLDMOSubscription_All = 3
> Const SQLDMOMergeSubscriber_Default = 2
> Dim objServer, objReplication, objReplicationDatabases,
objReplicationDatabase
> Dim objMergePullSubscription, objMergePullSubscriptions,
> objReplicationSecurity
> Set objServer = CreateObject("SQLDMO.SQLServer")
> objServer.Connect ".", "sa", "nyrv%fa"
> Set objReplication = objServer.Replication
> Set objReplicationDatabases = objReplication.ReplicationDatabases
> Set objReplicationDatabase = objReplicationDatabases("CareSQL50207")
> Set objMergePullSubscription =
CreateObject("SQLDMO.MergePullSubscription2")
> Set objReplicationSecurity = objMergePullSubscription.DistributorSecurity
> objReplicationSecurity.SecurityMode = SQLDMOReplSecurity_Normal
> objReplicationSecurity.StandardLogin = "sa"
> objReplicationSecurity.StandardPassword = "d23&tmv"
> With objMergePullSubscription
> .AltSnapshotFolder = "C:\temp\"
> .Distributor = "GSHSBS2000"
> .DistributorSecurity.SecurityMode = SQLDMOReplSecurity_Normal
> .DistributorSecurity.StandardLogin = "sa"
> .DistributorSecurity.StandardPassword = "nyrv%fa"
> .Publisher = "GSHSBS2000"
> .PublicationDB = "CareSQL50207"
> .Publication = "CareSQL50207"
> .PublisherSecurity.SecurityMode = SQLDMOReplSecurity_Normal
> .PublisherSecurity.StandardLogin = "sa"
> .PublisherSecurity.StandardPassword = "nyrv%fa"
> .SubscriberType = SQLDMOMergeSubscriber_Default
> .SubscriptionType = SQLDMOSubscription_Anonymous
> .SubscriberSecurityMode = SQLDMOReplSecurity_Normal
> .SubscriberLogin = "sa"
> .SubscriberPassword = "d23&tmv"
> .UseFTP = False
> End With
> Set objMergePullSubscriptions =
objReplicationDatabase.MergePullSubscriptions
> '$$$$$ STOPS here: [MS][ODBC][SQLServer] The subscription already exists.
> objMergePullSubscriptions.Add objMergePullSubscription
> Set objMergePullSubscription = Nothing
> Set objMergePullSubscriptions = Nothing
> Set objReplicationDatabases = Nothing
> Set objReplication = Nothing
> Set objServer = Nothing
> Exit_cmdMergePublication_Click:
> Exit Sub
> Err_cmdMergePublication_Click:
> MsgBox Err.Description
> Resume Exit_cmdMergePublication_Click
> End Sub
> --
> TIA
> Aubrey Kelley
|||Ouch! At least now I do not feel 'so dumb'. Maybe PSS will be helpful now
that we are so far. Nothing but dead ends in the past ...
Aubrey
"Hilary Cotter" wrote:
> this is to create the job, not to start it. I've been puzzling for a good
> long while on trying to figure out how to start it.
> --
> Hilary Cotter
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602.html
> Looking for a FAQ on Indexing Services/SQL FTS
> http://www.indexserverfaq.com
> "Aubrey" <Aubrey@.discussions.microsoft.com> wrote in message
> news:9D3A8AF9-7A89-4BCA-B3A4-0D564D00C217@.microsoft.com...
> ...
> objReplicationDatabase
> CreateObject("SQLDMO.MergePullSubscription2")
> objReplicationDatabase.MergePullSubscriptions
>
>
|||here is what I have so far - this will spill the anmes of the anonymous pull
subscriptions in the database Northwindsub.
Can't seem to get it to resolve to the job_id's for the merge pull though.
set objSQLServer=CreateObject("SQLDMO.SQLServer")
objSQLServer.loginSecure=True
objSQLServer.Connect "Publisher"
set objReplication=objSQLServer.Replication
wscript.echo objReplication.Distributor.DistributionServer
set objReplicationDatabase =
objReplication.ReplicationDatabases("Northwindsub" )
for each objMergepullSubscription in
objReplicationDatabase.MergepullSubscriptions
wscript.echo "objMergepullSubscription.Name"
wscript.echo objMergepullSubscription.Name
wscript.echo "objMergepullSubscription.MergeJObID"
wscript.echo objMergepullSubscription.MergeJObID
set QueryResults=objMergepullSubscription.EnumJobInfo
for b=1 to QueryResults.Rows
for a=1 to QueryResults.Columns
wscript.echo QueryResults.ColumnName(A)
wscript.echo QueryResults.GetColumnString(b,A)
next
next
wscript.echo objReplication.Distributor.DistributionServer
set QueryResults=objReplication.Distributor.EnumMergeA gentViews()
for b=1 to QueryResults.Rows
for a=1 to QueryResults.Columns
wscript.echo QueryResults.ColumnName(A)
wscript.echo QueryResults.GetColumnString(b,A)
next
next
set objDistributor=Nothing
next
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Aubrey" <Aubrey@.discussions.microsoft.com> wrote in message
news:2F4F23EF-3F58-44CD-8620-4BBA107F649F@.microsoft.com...[vbcol=seagreen]
> Ouch! At least now I do not feel 'so dumb'. Maybe PSS will be helpful now
> that we are so far. Nothing but dead ends in the past ...
> Aubrey
> "Hilary Cotter" wrote:
good[vbcol=seagreen]
ReplCtrl\VB\ReplSamp.vbp[vbcol=seagreen]
XP[vbcol=seagreen]
objMergePullSubscription.DistributorSecurity[vbcol=seagreen]
exists.[vbcol=seagreen]
Wednesday, March 7, 2012
Distributor server
I have a merge replication environment with 1 publisher/distributor in the
same machine and 3 subscribers with a lot of data to merge. The link between
them is slow.
I'm with performance problems with my applications I think that job
replications could be punish this performance.
Setup another machine to be a Distributor Server is a good idea ?
thank you for assistance.
Tony
Absolutely not. The location of the distribution server has little impact
with merge replication.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
"toryi" <toryi@.ig.com.br> wrote in message
news:%23oqjrx6AFHA.3504@.TK2MSFTNGP12.phx.gbl...
> I have a merge replication environment with 1 publisher/distributor in the
> same machine and 3 subscribers with a lot of data to merge. The link
between
> them is slow.
> I'm with performance problems with my applications I think that job
> replications could be punish this performance.
> Setup another machine to be a Distributor Server is a good idea ?
> thank you for assistance.
> Tony
>
|||What advantage I'll have in setup another machine to be a Distributor server
?
"Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message
news:%23iuKZW7AFHA.3016@.tk2msftngp13.phx.gbl...[vbcol=seagreen]
> Absolutely not. The location of the distribution server has little impact
> with merge replication.
> --
> Hilary Cotter
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602.html
> "toryi" <toryi@.ig.com.br> wrote in message
> news:%23oqjrx6AFHA.3504@.TK2MSFTNGP12.phx.gbl...
the
> between
>
same machine and 3 subscribers with a lot of data to merge. The link between
them is slow.
I'm with performance problems with my applications I think that job
replications could be punish this performance.
Setup another machine to be a Distributor Server is a good idea ?
thank you for assistance.
Tony
Absolutely not. The location of the distribution server has little impact
with merge replication.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
"toryi" <toryi@.ig.com.br> wrote in message
news:%23oqjrx6AFHA.3504@.TK2MSFTNGP12.phx.gbl...
> I have a merge replication environment with 1 publisher/distributor in the
> same machine and 3 subscribers with a lot of data to merge. The link
between
> them is slow.
> I'm with performance problems with my applications I think that job
> replications could be punish this performance.
> Setup another machine to be a Distributor Server is a good idea ?
> thank you for assistance.
> Tony
>
|||What advantage I'll have in setup another machine to be a Distributor server
?
"Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message
news:%23iuKZW7AFHA.3016@.tk2msftngp13.phx.gbl...[vbcol=seagreen]
> Absolutely not. The location of the distribution server has little impact
> with merge replication.
> --
> Hilary Cotter
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602.html
> "toryi" <toryi@.ig.com.br> wrote in message
> news:%23oqjrx6AFHA.3504@.TK2MSFTNGP12.phx.gbl...
the
> between
>
Distributor on another server?
Can the distributor be on another server that does not have SQL Server on
it. Using SQL 2k merge replication. Thanks.
David
No, it must have a version of SQL Server on it.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"David Chase" <dlchase@.lifetimeinc.com> wrote in message
news:eofDI%232IGHA.1180@.TK2MSFTNGP09.phx.gbl...
> Can the distributor be on another server that does not have SQL Server on
> it. Using SQL 2k merge replication. Thanks.
> David
>
it. Using SQL 2k merge replication. Thanks.
David
No, it must have a version of SQL Server on it.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"David Chase" <dlchase@.lifetimeinc.com> wrote in message
news:eofDI%232IGHA.1180@.TK2MSFTNGP09.phx.gbl...
> Can the distributor be on another server that does not have SQL Server on
> it. Using SQL 2k merge replication. Thanks.
> David
>
Friday, February 24, 2012
Distribution Agent History Clean Up Fails
Hi everyone.
i'm using sql database 7.0 setup for merge replication.suddenly i found out
that the "Agent History Cleanup:Distribution" had a red x mark.When i
examined,it shows that the agent did not run on its specied running
schedule.Even if i run it manually,still it won't work. When i check the
history of the agent why it fails to run it state their that:
could not find the index entry for RID '361526d0688a801749800300101801000'
in index page (1:1084), index ID 0, database 'distribution'. [SQLSTATE HY000]
(Error 644). The step failed.
Is this error will affect the replication process of my server?How can i fix
this one?
I will really appreciate any help you could give and thanksin advance.
I'd run dbcc checkdb on the distribution database.
Also consider dbcc dbreindex on each table in the distribution database.
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com .
|||hi sir.first i want to thank you for your response.
I still have some query about my problem sir.
I already run a dbcc checkdb on my distribution database,but unfortunately
it still not solve my problem.
The dbcc checkdb returns a result that "checkdb found 0 allocation errors
and 0 consistency errors in my database".
Is there other way to resolve this problem sir?
Will this miscellaneous agent error affects my database replication?
Thank you and more power.
"Paul Ibison" wrote:
> I'd run dbcc checkdb on the distribution database.
> Also consider dbcc dbreindex on each table in the distribution database.
> Cheers,
> Paul Ibison SQL Server MVP, www.replicationanswers.com .
>
>
|||OK - then please try running dbcc dbreinxdex on all tables in the
distribution database and we'll see if this fixes it.
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com .
i'm using sql database 7.0 setup for merge replication.suddenly i found out
that the "Agent History Cleanup:Distribution" had a red x mark.When i
examined,it shows that the agent did not run on its specied running
schedule.Even if i run it manually,still it won't work. When i check the
history of the agent why it fails to run it state their that:
could not find the index entry for RID '361526d0688a801749800300101801000'
in index page (1:1084), index ID 0, database 'distribution'. [SQLSTATE HY000]
(Error 644). The step failed.
Is this error will affect the replication process of my server?How can i fix
this one?
I will really appreciate any help you could give and thanksin advance.
I'd run dbcc checkdb on the distribution database.
Also consider dbcc dbreindex on each table in the distribution database.
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com .
|||hi sir.first i want to thank you for your response.
I still have some query about my problem sir.
I already run a dbcc checkdb on my distribution database,but unfortunately
it still not solve my problem.
The dbcc checkdb returns a result that "checkdb found 0 allocation errors
and 0 consistency errors in my database".
Is there other way to resolve this problem sir?
Will this miscellaneous agent error affects my database replication?
Thank you and more power.
"Paul Ibison" wrote:
> I'd run dbcc checkdb on the distribution database.
> Also consider dbcc dbreindex on each table in the distribution database.
> Cheers,
> Paul Ibison SQL Server MVP, www.replicationanswers.com .
>
>
|||OK - then please try running dbcc dbreinxdex on all tables in the
distribution database and we'll see if this fixes it.
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com .
Tuesday, February 14, 2012
Distributed transaction
Hi all,
I am trying to merge data of 2 tables on different servers with an insert statement.
INSERT INTO SERVER1.db.owner.table
select s2.* from SERVER2.db.owner.table as s2
LEFT JOIN SERVER1.db.owner.table as s1
ON s1.key=s2.key
where s1.key is null
I got this error.
The operation could not be performed because the OLE DB provider 'SQLOLEDB' was unable to begin a distributed transaction.
[OLE/DB provider returned message: New transaction cannot enlist in the specified transaction coordinator. ]
OLE DB error trace [OLE/DB Provider 'SQLOLEDB' ITransactionJoin::JoinTransaction returned 0x8004d00a].
while the select query is giving the result.
I have done simmilar inserts on some other tables which worked fine
I have created sp_addlinkedserver.
and DTC set on both servers.
any help will be greatly appreciatedDid you execute this on Server1 or Server2? What OS and sp are on the respective servers?
-PatP|||Are you doing it within a transaction? You can successfully bypass engagement of MSDTC by preceeding your INSERT with SET IMPLICIT_TRANSACTIONS OFF.|||Thanks for the reply.
I have tried it on both servers .
os:w2k and sp3.
It is not with in transaction.
error still occurs.
I am trying to merge data of 2 tables on different servers with an insert statement.
INSERT INTO SERVER1.db.owner.table
select s2.* from SERVER2.db.owner.table as s2
LEFT JOIN SERVER1.db.owner.table as s1
ON s1.key=s2.key
where s1.key is null
I got this error.
The operation could not be performed because the OLE DB provider 'SQLOLEDB' was unable to begin a distributed transaction.
[OLE/DB provider returned message: New transaction cannot enlist in the specified transaction coordinator. ]
OLE DB error trace [OLE/DB Provider 'SQLOLEDB' ITransactionJoin::JoinTransaction returned 0x8004d00a].
while the select query is giving the result.
I have done simmilar inserts on some other tables which worked fine
I have created sp_addlinkedserver.
and DTC set on both servers.
any help will be greatly appreciatedDid you execute this on Server1 or Server2? What OS and sp are on the respective servers?
-PatP|||Are you doing it within a transaction? You can successfully bypass engagement of MSDTC by preceeding your INSERT with SET IMPLICIT_TRANSACTIONS OFF.|||Thanks for the reply.
I have tried it on both servers .
os:w2k and sp3.
It is not with in transaction.
error still occurs.
Subscribe to:
Posts (Atom)