Replication to different table structure

I had set up some Snapshot and Transactional replication in the past but
would like to see if following is possible.
Is it possible to do either snapshot or transactionl replication between
tables with 2 different table structure? Lets say I have a tableA which i
like to replicate to TableB. But TableB has few additional columns from
tableA. Also, How about datatype difference on some columns between TableA
and TableB?
Version is Sql server 2000 sp4.
I appreciate your reply.
Filtering (vertical) can be used to restrict the columns. Where the
datatypes are different there are a few posibilities, but replicating
indexed views is quite straightforward.
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com
|||Have a look at this:
http://www.dbazine.com/sql/sql-articles/cotter1
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
"James" <kush@.brandes.com> wrote in message
news:uc8kggmaHHA.808@.TK2MSFTNGP04.phx.gbl...
>I had set up some Snapshot and Transactional replication in the past but
>would like to see if following is possible.
> Is it possible to do either snapshot or transactionl replication between
> tables with 2 different table structure? Lets say I have a tableA which i
> like to replicate to TableB. But TableB has few additional columns from
> tableA. Also, How about datatype difference on some columns between TableA
> and TableB?
> Version is Sql server 2000 sp4.
> I appreciate your reply.
>
|||http://www.dbazine.com/sql/sql-articles/cotter1
I just get a page prompting to renew the domain name... do you have another
link Hilary?
"Hilary Cotter" wrote:

> Have a look at this:
> http://www.dbazine.com/sql/sql-articles/cotter1
> --
> 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
>
> "James" <kush@.brandes.com> wrote in message
> news:uc8kggmaHHA.808@.TK2MSFTNGP04.phx.gbl...
>
>
|||Wow, I just checked this link and it was valid, and now I get the domain
expired as well
Have a look at this:
http://209.85.165.104/search?q=cache:4m4CLStYfWIJ:www.dbazine.com/sql/sql-articles/cotter1+http://www.dbazine.com/sql/sql-articles/cotter1&hl=en&ct=clnk&cd=1&gl=us
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
"Steve Hall" <SteveHall@.discussions.microsoft.com> wrote in message
news:4E6A1EF4-E639-4ED7-B4BA-F6DEE42F016E@.microsoft.com...[vbcol=seagreen]
> http://www.dbazine.com/sql/sql-articles/cotter1
> I just get a page prompting to renew the domain name... do you have
> another
> link Hilary?
>
> "Hilary Cotter" wrote:
|||Thanks Hilary,
I got the same text minus the images from google cache and
waybackmachine.org. Just got finished reading it and a few of your other
articles on dbdirections.com.
Steve
"Hilary Cotter" wrote:

> Wow, I just checked this link and it was valid, and now I get the domain
> expired as well
> Have a look at this:
> http://209.85.165.104/search?q=cache:4m4CLStYfWIJ:www.dbazine.com/sql/sql-articles/cotter1+http://www.dbazine.com/sql/sql-articles/cotter1&hl=en&ct=clnk&cd=1&gl=us
> --
> 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
>
> "Steve Hall" <SteveHall@.discussions.microsoft.com> wrote in message
> news:4E6A1EF4-E639-4ED7-B4BA-F6DEE42F016E@.microsoft.com...
>
>
|||Thanks Hilary! Helpful article.
I am still having some trouble though. I am trying to implement some of the
suggestion from that Article for Case 2 (where subscriber has more columns
than publisher) and I am using Snapshot replication only.
Suggestion1: I precreated the table on the subscriber and provide default
value for the column (which doesn't exist on publisher), but when the
distributer agent runs it gives me following error:
"Unexpected EOF encountered in BCP data-file"
Suggestion 2: "Supply a value for those columns in the replication stored
procedure". Where can I find this SP? It doesn't exist on Subscription
database.
Suggestion 3: "Index View". haven't tried yet. going to try very soon.
"Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message
news:eoznYMuaHHA.4396@.TK2MSFTNGP06.phx.gbl...
> Have a look at this:
> http://www.dbazine.com/sql/sql-articles/cotter1
> --
> 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
>
> "James" <kush@.brandes.com> wrote in message
> news:uc8kggmaHHA.808@.TK2MSFTNGP04.phx.gbl...
>
|||Could you post the table schema on the publisher and what you want it to
look like on the subscriber?
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
"James" <kush@.brandes.com> wrote in message
news:ux0YSQwaHHA.1388@.TK2MSFTNGP05.phx.gbl...
> Thanks Hilary! Helpful article.
> I am still having some trouble though. I am trying to implement some of
> the suggestion from that Article for Case 2 (where subscriber has more
> columns than publisher) and I am using Snapshot replication only.
> Suggestion1: I precreated the table on the subscriber and provide default
> value for the column (which doesn't exist on publisher), but when the
> distributer agent runs it gives me following error:
> "Unexpected EOF encountered in BCP data-file"
> Suggestion 2: "Supply a value for those columns in the replication stored
> procedure". Where can I find this SP? It doesn't exist on Subscription
> database.
> Suggestion 3: "Index View". haven't tried yet. going to try very soon.
>
>
> "Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message
> news:eoznYMuaHHA.4396@.TK2MSFTNGP06.phx.gbl...
>

replication table size

Hi,
I would like to know the following :
1. During replication , is the data being transmitted in binary format
2. where do i get to check the size of the whole replication(in bytes/KB) ?
3. where do i get to check the size of a single table being replicated (in
bytes/KB)
appreciate any advice
tks & rdgs
Message posted via droptable.com
http://www.droptable.com/Uwe/Forums...-msde/200512/1
Hi,
I know from some previous postings that sp_spaceused (see BOL for more
details) can be used to find out the size of a db/table but is that the size
being transmitted during Replication ?
and also how do i check the size of a packet (is it defaulted to 4096 k) ?
tks & rdgs
maxzsim wrote:
>Hi,
> I would like to know the following :
> 1. During replication , is the data being transmitted in binary format
> 2. where do i get to check the size of the whole replication(in bytes/KB) ?
> 3. where do i get to check the size of a single table being replicated (in
>bytes/KB)
> appreciate any advice
>tks & rdgs
Message posted via droptable.com
http://www.droptable.com/Uwe/Forums...-msde/200512/1

Replication sometimes does not delete all records

Hi all,
I have a following problem with my replication.
I have 3 machines - 1 is publisher and its own distributor, and two are
subscribers. The replication topology model is "central publisher".
The problem concerns the merge replication with filtering (filter is
"2=1"). This replication should take any records inserted into
replicated tables on subscribers and copy them to main server (typical
merge process for new entries). Received rows are checked against the
filter condition and are immediately deleted on subscribers because the
"2=1" condition is impossible.
This is working fine, but sometimes it happens that some rows are not
deleted on subscribers. They are copied properly, but sometimes you can
see the situation when there was 15371 inserts and 15270 deletes. They
are not taken into consideration during the next replication (they are
just left, cluttering the tables on subscribers).
All machines working on sql server 2k with sp2.
Did someone encountered such behaviour? I'm new to replication and I
don't know what can I do to analyse what's going on.
Regards
Xavier
Does anything show up in the conflict viewer?
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
|||> Does anything show up in the conflict viewer?
No, there are no conflicts shown. There are no errors either. Everything
goes smooth (with one exception).
Regards
|||I'd run a validation to verify everything is working fine.
The record being uploaded/downloaded is likely a metadata record for the system tables.
I am perplexed by your filter. If you are filtering updates coming from your subscriber you are also filtering going to your publisher which begs the question - why are you replicating this table?
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
|||> I am perplexed by your filter. If you are filtering updates coming from your subscriber you are also filtering going to your publisher which begs the question - why are you replicating this table?
the task i want to achieve is to move the data from distributed machine
to one central server. is there something i missed?
sql

Replication Setup Issues

While trying to configure replication from and to SQL Server 2000 boxes, I
encountered the following error, which I was not able to get past. The
error is encountered after completing the "Push Subscription Wizard" which
is set to create the database and initialize the schema and data. The
database gets created, but the schema does not.
Does anyone have advice on how to get past this error?
If not, I have questions further on regarding my test environment...
The process could not connect to Subscriber '<SERVERNAME>'.
Login failed for user '(null)'. Reason: Not associated with a trusted SQL
Server connection.
(Source: <SERVERNAME> (Data source); Error number: 18452)
I am connected using windows authentication, and I am an administrator on
both boxes. I can connect to either database and perform any action I want,
but I still keep getting this error. I have not found any way to specify a
login for replication, I assume the job runs either under my login or as SA.
I changed the scheduled task to be owned by SA, and attempted to run it as
both "Self" and "DBO", with no luck. I kept getting the same error. Some
of the IDs that exist in our production database do not exist in the
database we are replicating to, although SA exists, as does my account.
Normally I do not use Enterprise manager for anything and I script
everything out, but the only instructions I had were for EM. Would I be
better off using a script in QA for setting up replication?
Regarding my test environment...
Now, after spending a couple of hours on this error, I decided to go back to
my test environment (where everything worked the first time) and make it
look more like my production environment so I could do another round of
testing. I restored the master database and my 3 database which will be
replicated, but the backups were form different dates and I ran into all
kinds of conflicts. Essentially, SQL Server said the replication
definitions were invalid, and would not let me remove them. Next week, when
time allows, I will be getting a cold backup of the entire database to
attach to, hopefully that will get my test database in a state where I can
do another round of testing.
Am I on the right track with my test environment? What is the proper way to
copy a replication database, and remove the replication?
Any advice will be greatly appreciated.
Are you using sql server logins for the distribution agent, and the
subscriber is set to only allow windows (trusted) authentication? This could
be one cause of the error.
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com
|||Both of the databases are set up to allow both SQL Server and trusted
authentication. I confirmed by logging into each server as SA, just to be
sure.
I am, however, performing all of the setup using trusted authentication,
under my own account, which has administrative priviledges.
I never specified a logon for the distribution agent, however. Maybe that
is the problem? I was never actually prompted to do so, and was unable to
find where to specify it. I am the owner of the distribution agent
process, and the first process in the scheduled job is set to run as (Self),
so I assume it is running under my account. I tried changing this to DBA,
and I tried changing the owner to SA, neither made a difference.
"Paul Ibison" <Paul.Ibison@.Pygmalion.Com> wrote in message
news:exM%23TihUHHA.3652@.TK2MSFTNGP04.phx.gbl...
> Are you using sql server logins for the distribution agent, and the
> subscriber is set to only allow windows (trusted) authentication? This
could
> be one cause of the error.
> Cheers,
> Paul Ibison SQL Server MVP, www.replicationanswers.com
>
|||Jim,
just testing all posibilities here so pls can you check what the following
script returns at the subscriber.
Use Master
go
Select @.@.Servername
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com
|||Excellent catch. My test database comes back with the production database
name. The question is, how do I correct this, or how do I get the test
database to match my production database configuration?
"Paul Ibison" <Paul.Ibison@.Pygmalion.Com> wrote in message
news:ua103$CVHHA.4784@.TK2MSFTNGP03.phx.gbl...
> Jim,
> just testing all posibilities here so pls can you check what the following
> script returns at the subscriber.
> Use Master
> go
> Select @.@.Servername
> Cheers,
> Paul Ibison SQL Server MVP, www.replicationanswers.com
>
>
>
|||ok, I found this in BOL explaining how to change the server name. The
question is, will this be enough to get the restored database in a testable
state, or am I going about this the wrong way? Tonight I intend to take a
full cold backup from production and reattach to all the databases on test.
How to change to the current server name in the SQL Server 6.5 master
database (ISQL/w)
To change to the current server name in the SQL Server 6.5 master database
1.. Start Microsoft SQL ServerT in minimal configuration mode. In a
command prompt window, from the \Mssql\Binn directory, run:
sqlservr -f
2.. On the Start menu, point to Programs /Microsoft SQL Server 6.5, and then
click ISQL/w.
3.. Enter the sa password, and then click Connect.
4.. Execute SELECT @.@.SERVERNAME to retrieve the former server name.
5.. Execute sp_dropserver to drop the former server.
6.. Execute sp_addserver to add the current server.
7.. Stop SQL Server. In the command prompt window, press Ctrl+C.
8.. Restart SQL Server.
9.. Execute SELECT @.@.SERVERNAME to verify the current server name.
Examples
--Start SQL Server in minimal configuration mode.
--Retrieve the former server name.
SELECT @.@.SERVERNAME
--Drop the server returned from the previous select.
sp_dropserver 'SERVER6X'
--Add the current server.
sp_addserver 'SERVER70', local
--Stop SQL Server.
--Restart SQL Server in minimal configuration mode.
--Verify the current server name.
SELECT @.@.SERVERNAME
"Jim Underwood" <james.underwoodATfallonclinic.com> wrote in message
news:uDG$BKDVHHA.2212@.TK2MSFTNGP02.phx.gbl...[vbcol=seagreen]
> Excellent catch. My test database comes back with the production database
> name. The question is, how do I correct this, or how do I get the test
> database to match my production database configuration?
> "Paul Ibison" <Paul.Ibison@.Pygmalion.Com> wrote in message
> news:ua103$CVHHA.4784@.TK2MSFTNGP03.phx.gbl...
following
>
|||Jim,
this should be enough to get the subscriber set up. For step 6 you just have
to remember the 'local' switch.
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com
|||Paul, thank you for the assistance. I'll post back in a couple of days to
let everyone know how I made out.
I have added your site to my online SQL Server library. I have a feeling it
will come in useful.
Thanks again,
Jim
"Paul Ibison" <Paul.Ibison@.Pygmalion.Com> wrote in message
news:%23Lh$XgDVHHA.4756@.TK2MSFTNGP06.phx.gbl...
> Jim,
> this should be enough to get the subscriber set up. For step 6 you just
have
> to remember the 'local' switch.
> Cheers,
> Paul Ibison SQL Server MVP, www.replicationanswers.com
>
|||I was finally able to get my test environment up and running, after renaming
my server, deleting the entries in the distribution database, and updating
the server name in the msdb.dbo.jobs table.
The test environment replicated without any issue, so I do not know why I am
having trouble in production.
Maybe I just need to remove the replication entirely and start from scratch?
Before I go that route, does anyone know what would be likely to cause this
error when trying to run the distribution agent?
The process could not connect to Subscriber '<SERVERNAME>'.
Login failed for user '(null)'. Reason: Not associated with a trusted SQL
Server connection.
(Source: <SERVERNAME> (Data source); Error number: 18452)
"Jim Underwood" <james.underwoodATfallonclinic.com> wrote in message
news:e5aCzMhUHHA.5012@.TK2MSFTNGP04.phx.gbl...
> While trying to configure replication from and to SQL Server 2000 boxes, I
> encountered the following error, which I was not able to get past. The
> error is encountered after completing the "Push Subscription Wizard" which
> is set to create the database and initialize the schema and data. The
> database gets created, but the schema does not.
> Does anyone have advice on how to get past this error?
> If not, I have questions further on regarding my test environment...
> ----
--
> --
> The process could not connect to Subscriber '<SERVERNAME>'.
> Login failed for user '(null)'. Reason: Not associated with a trusted SQL
> Server connection.
> (Source: <SERVERNAME> (Data source); Error number: 18452)
> ----
--
> --
> I am connected using windows authentication, and I am an administrator on
> both boxes. I can connect to either database and perform any action I
want,
> but I still keep getting this error. I have not found any way to specify
a
> login for replication, I assume the job runs either under my login or as
SA.
> I changed the scheduled task to be owned by SA, and attempted to run it as
> both "Self" and "DBO", with no luck. I kept getting the same error.
Some
> of the IDs that exist in our production database do not exist in the
> database we are replicating to, although SA exists, as does my account.
> Normally I do not use Enterprise manager for anything and I script
> everything out, but the only instructions I had were for EM. Would I be
> better off using a script in QA for setting up replication?
> Regarding my test environment...
> Now, after spending a couple of hours on this error, I decided to go back
to
> my test environment (where everything worked the first time) and make it
> look more like my production environment so I could do another round of
> testing. I restored the master database and my 3 database which will be
> replicated, but the backups were form different dates and I ran into all
> kinds of conflicts. Essentially, SQL Server said the replication
> definitions were invalid, and would not let me remove them. Next week,
when
> time allows, I will be getting a cold backup of the entire database to
> attach to, hopefully that will get my test database in a state where I can
> do another round of testing.
> Am I on the right track with my test environment? What is the proper way
to
> copy a replication database, and remove the replication?
> Any advice will be greatly appreciated.
>
|||OK, I removed the replication entirely and started over, with the same
problems as before. It turned out to be an NT account/permissions issue.
The account that runs the SQL Server Agent on the distributor needs to have
access to the subscriber server as well.
Just to repeat the error:
> ----
> The process could not connect to Subscriber '<SERVERNAME>'.
> Login failed for user '(null)'. Reason: Not associated with a trusted SQL
> Server connection.
> (Source: <SERVERNAME> (Data source); Error number: 18452)
I looked at the security event logs on the subscriber server and saw a login
failure when I was trying to push the subscription. The ID that was
erroring out was a local ID on the distributor. The SQL Server Agent was
being run under this local account. Creating the same local account on the
subscriber server and giving it the required permissions, corrected the
problem.

Replication setup Error..

When I tried to configure replication, the following error comes out.
What is that about and any idea?When I tried to configure replication, the following error comes out.
What is that about and any idea?

Try this Microsoft article:
http://support.microsoft.com/?id=321822

Replication Screwup

Running SQL 2005 on Win 2003....
First, I cannot find sp_MSload_replication_status. When I run it, I
get the following error
Msg 2812, Level 16, State 62, Line 1
Could not find stored procedure 'sp_MSload_replication_status'.
Is the SP not a part of 2005?
Second... I attempted to remove publications & push subscriptions,
from the publisher, via a script, see below...
DECLARE @.subscriptionDB AS sysname
SET @.subscriptionDB = N'EDI'
-- Remove replication objects from a subscription database (if
necessary).
USE master
EXEC sp_removedbreplication @.subscriptionDB
GO
This removed the Publication & Subscriptions from SMS, but Replicaiton
Manager still shows them. I have tried numerous scripts with no luck.
How do I clean up replication manger? I tought
sp_removedbreplication removed everything.
AHIA,
Larry...
I have deleted all jobs that reference this database and run
sp_removedbreplication 'EDI'
sp_replicationdboption 'edi','publish','False'
The subscriptions still exist in the replication monitor with the
message...
The concurrent snapshot for publication 'EDI to 04' is not available
because it has not been fully generated or the Log Reader Agent is not
running to activate it. If generation of the concurrent snapshot was
interrupted, the Snapshot Agent for the public
HELP!!!!
|||Did you check the logreader and snapshot jobs on the distribution server?
It could be the snapshot job is still enabled and trying to run.
-Chuck
On 3 May 2007 11:13:58 -0700, LPR-3rd wrote:

> I have deleted all jobs that reference this database and run
> sp_removedbreplication 'EDI'
> sp_replicationdboption 'edi','publish','False'
> The subscriptions still exist in the replication monitor with the
> message...
> The concurrent snapshot for publication 'EDI to 04' is not available
> because it has not been fully generated or the Log Reader Agent is not
> running to activate it. If generation of the concurrent snapshot was
> interrupted, the Snapshot Agent for the public
>
> HELP!!!!
|||sql 2000 only.
"LPR-3rd" <lreames@.gmail.com> wrote in message
news:1178211126.029986.247150@.y80g2000hsf.googlegr oups.com...
> Running SQL 2005 on Win 2003....
> First, I cannot find sp_MSload_replication_status. When I run it, I
> get the following error
> Msg 2812, Level 16, State 62, Line 1
> Could not find stored procedure 'sp_MSload_replication_status'.
> Is the SP not a part of 2005?
>
> Second... I attempted to remove publications & push subscriptions,
> from the publisher, via a script, see below...
> DECLARE @.subscriptionDB AS sysname
> SET @.subscriptionDB = N'EDI'
> -- Remove replication objects from a subscription database (if
> necessary).
> USE master
> EXEC sp_removedbreplication @.subscriptionDB
> GO
> This removed the Publication & Subscriptions from SMS, but Replicaiton
> Manager still shows them. I have tried numerous scripts with no luck.
> How do I clean up replication manger? I tought
> sp_removedbreplication removed everything.
> AHIA,
> Larry...
>
|||I had this issue after recoving a crashed database. on server 2005
Dropping / recreating the publications and subscriptions didn't do the trick.
I had to "Disable Replication" , causing all replication related data to be
dropped from the server.
Then I just went through the "Disrtibution" wizard, connected to a
publisher, recreated the pubs and subs and all was well. Didn't have to
rename or do anything else with the source database.

Replication Questions?

Hi,

I'm having a headache with the following questions weavering around...Hope that someone can help me with the answers.

1) I've implemented a immediate updating transactional replication on 2 servers. The loopback detection is also set to true. Under normal circumstances, when there is an transaction at the subscriber, it should be replicated to the publisher. However, this was not the case here. There were some transaction in the subscriber, but they were not replicated to the publisher. Is it because of the "loopback detection" option?

2) If a bi-directional transaction is to be implemented as according to the BOL, there will be 2 distributors. When a publisher has a transaction, it will be replicated to the subscriber. When the subscriber commit the transaction, will the transaction be sent back to the publisher's distribution database? or will the distribution agent at the subscriber will know that it originated from the publisher and will not sent it to the publisher?

Pls pardon my long msg. Any advice is welcome.

no advice available?|||

Did you set up immediate updating subscriber using the UI/wizards? If so, do you see the triggers on the subscriber tables, they should be named something like trg_MSsync_ins_<table name>, trg_MSsync_upd_<table name> and trg_MSsync_del_<table name>.

What I'd do is profile the subscriber and publisher when making changes at subscriber to see what code of the trigger is getting executed.

Replication problems

Hi group
I have the following setup:
A primary sqlserver running windows 2000 server OS
a secondary sqlserver running windows 2003 server OS
Both sqlservers run sqlserver 2000 software, and both logon with the
local administrator account. Both administrator account have the same
password, so accessing \\<servername>\c$\....\repldata shouldnt be a
problem.
the primary sqlserver has been configured as the publication server,
publicating a database called repli_test, as snapshot
The secondary sqlserver has a pull subscription to the repli_test
database.
When I try to pull the database, I get the following error:
The job failed. Unable to determine if the owner
(SQL-BACKUP\Administrator) of job
SQLSERVER-repli_test-repli_test-SQL-BACKUP-repli_test-9DA1AF79-158C-49BD-89B6-64D8F9EF2C21
has server access
(reason: Could not obtain information about Windows NT group/user
'SQL-BACKUP\Administrator'. [SQLSTATE 42000] (Error 8198)).
any suggestions to a solution?
TIA
Kaare
Try changing the job owner to sa.
Rgds,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)
|||Thank you very much for your reply. It really did the trick.
Unfortunally Im stock on another problem. Replication doesnt seem to
work, if a table contains more than 255 columns. Is there any workaround
on this issue?
TIA
Kaare
|||The main advised workaround is to partition the table and then replicate as
two articles in the same publication. From the point of view of the system,
this could be made transparent as you could have a view which unions the
data from the 2 tables, and call the view the same as the curent table. This
would be taking advantage of non-distributed partitioned views.
Rgds,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)

Replication problems

I am trying to get replication to work on my system and keep getting the
following problem trying to start up the Push to my servers.
All the schemas seem to be generated on all the servers, but not the tables.
After telling it to initialize the subscriptions I get the following
message:
***********************************************************************
Subscriptions were created successfully at the following Subscribers:
PTERADON
SQL Server Enterprise Manager could not start the service
'SQLServerAgent' on server 'DINO'.
5 - (Access is denied)
The subscription at Subscriber 'PTERADON' cannot be initialized
immediately because the snapshot for this publication is not yet
available. To initialize the subscription, start the Distribution Agent
after the snapshot is available.
***************************************************************************
SQLServerAgent is running on the Server "Dino", so I don't know why I am
getting that message.
Also, in the Replication Monitor, almost all the folders have a red
circle with an X in it.
In the "Snapshot agent" folder I have an item "northwind" (which is what
I am trying to publish), with the following message:
The process could not bulk copy out of table
'[dbo].[syncobj_0x4630333239354338]'.
In the "log reader agents", I get the following:
The license for this installation of SQL Server does not permit Log
Reader Agent to run at the Publisher.
Could not get license information correctly.
I also get the License message for the distribution agents.
What License are they talking about?
Thanks,
Tom.Is your sql service running as user with administrative rights or is it
running as local system. Try to use user with admin rights.
"Thomas Scheiderich" <tfs@.deltanet.com> wrote in message
news:3FC462B7.6080805@.deltanet.com...
> I am trying to get replication to work on my system and keep getting the
> following problem trying to start up the Push to my servers.
> All the schemas seem to be generated on all the servers, but not the
tables.
> After telling it to initialize the subscriptions I get the following
> message:
> ***********************************************************************
> Subscriptions were created successfully at the following Subscribers:
> PTERADON
> SQL Server Enterprise Manager could not start the service
> 'SQLServerAgent' on server 'DINO'.
> 5 - (Access is denied)
> The subscription at Subscriber 'PTERADON' cannot be initialized
> immediately because the snapshot for this publication is not yet
> available. To initialize the subscription, start the Distribution Agent
> after the snapshot is available.
>
***************************************************************************
> SQLServerAgent is running on the Server "Dino", so I don't know why I am
> getting that message.
> Also, in the Replication Monitor, almost all the folders have a red
> circle with an X in it.
> In the "Snapshot agent" folder I have an item "northwind" (which is what
> I am trying to publish), with the following message:
> The process could not bulk copy out of table
> '[dbo].[syncobj_0x4630333239354338]'.
> In the "log reader agents", I get the following:
> The license for this installation of SQL Server does not permit Log
> Reader Agent to run at the Publisher.
> Could not get license information correctly.
> I also get the License message for the distribution agents.
> What License are they talking about?
> Thanks,
> Tom.
>|||Dalibor Cvijetinovic wrote:
> Is your sql service running as user with administrative rights or is it
> running as local system. Try to use user with admin rights.
>
No. I have both set up as SqlAgentCmdExec and it has executive priviledges.
All the tasks have these license errors as shown below and may be why I
can't get this to work correctly.
Where do they come from and why am I getting them. Did I not load
something correctly when I set up Sql Server 7'
Thanks,
Tom.
>
> "Thomas Scheiderich" <tfs@.deltanet.com> wrote in message
> news:3FC462B7.6080805@.deltanet.com...
>>I am trying to get replication to work on my system and keep getting the
>>following problem trying to start up the Push to my servers.
>>All the schemas seem to be generated on all the servers, but not the
> tables.
>>After telling it to initialize the subscriptions I get the following
>>message:
>>***********************************************************************
>>Subscriptions were created successfully at the following Subscribers:
>>PTERADON
>>SQL Server Enterprise Manager could not start the service
>>'SQLServerAgent' on server 'DINO'.
>>5 - (Access is denied)
>>The subscription at Subscriber 'PTERADON' cannot be initialized
>>immediately because the snapshot for this publication is not yet
>>available. To initialize the subscription, start the Distribution Agent
>>after the snapshot is available.
>>
> ***************************************************************************
>>SQLServerAgent is running on the Server "Dino", so I don't know why I am
>>getting that message.
>>Also, in the Replication Monitor, almost all the folders have a red
>>circle with an X in it.
>>In the "Snapshot agent" folder I have an item "northwind" (which is what
>>I am trying to publish), with the following message:
>>The process could not bulk copy out of table
>>'[dbo].[syncobj_0x4630333239354338]'.
>>In the "log reader agents", I get the following:
>>The license for this installation of SQL Server does not permit Log
>>Reader Agent to run at the Publisher.
>>Could not get license information correctly.
>>I also get the License message for the distribution agents.
>>What License are they talking about?
>>Thanks,
>>Tom.
>>
>

Replication problem... Please Help!

Hi,
I have the following problem with a Transactional Replication between two SQL Server 2000:
- One Database is replicated from one server to the other and it works well.
- I have cancelled the distribution, the publication and the subscription in the right order. So technically, there should be no trace left of the replication.
- Then I try to run a script to alter the type of a column and I get the following error message : "Cannot alter column because it is 'REPLICATED'."
- When I look at the colstat value (in syscolumns) for this column, it has a value greater than 4096 which means that it is effectively marked for replication.
Why is that happenning?
What can I do the remove the replication traces, and then be able to change the column type?
Thanks for all your help!!!
Jenny
Hi,
When I say I "cancelled" the replication, I mean that I have deleted everything related to the replication. So in my opinion there should not be any trace left of
the replication in my tables info. Is there a way to remove the replication info on a particular table? I really don't know what to do!
Thanks,
Jenny
"ChrisR" wrote:

> When you say you cancelled distribution, do you mean you
> got rid of the distribution db or turned off the agent? If
> you mean turned it off, Im not sure where, but this info
> is still in one of the system tables probably in the
> distribution db. Ive had to mess with these before for the
> same thing. Id figure it out right now for you but Im a
> bit pressed for time. Id be willing to bank on it being in
> the MSArticles table though. Let us know if thats not it
> and if you cant figure it out.
>
>
> Replication between two SQL Server 2000:
> and it works well.
> the subscription in the right order. So technically, there
> should be no trace left of the replication.
> column and I get the following error message : "Cannot
> alter column because it is 'REPLICATED'."
> this column, it has a value greater than 4096 which means
> that it is effectively marked for replication.
> be able to change the column type?
>
|||Assuming that you actually went and ran the Disable
Publishing and Distribution Wizard so you no longer have a
Distribution database, I wouldnt know what to tell you.
Chane the column value that you were talking about and see
if that help.

>--Original Message--
>Hi,
>When I say I "cancelled" the replication, I mean that I
have deleted everything related to the replication. So in
my opinion there should not be any trace left of
> the replication in my tables info. Is there a way to
remove the replication info on a particular table? I
really don't know what to do![vbcol=seagreen]
>Thanks,
>Jenny
>"ChrisR" wrote:
you[vbcol=seagreen]
If[vbcol=seagreen]
info[vbcol=seagreen]
the[vbcol=seagreen]
in[vbcol=seagreen]
it[vbcol=seagreen]
other[vbcol=seagreen]
and[vbcol=seagreen]
there[vbcol=seagreen]
means[vbcol=seagreen]
then
>.
>
|||Use this stored Procedure sp_removedbreplication
This should solve your problem. (If you have removed using one of the wizard)
Rakesh
"ChrisR" wrote:

> Assuming that you actually went and ran the Disable
> Publishing and Distribution Wizard so you no longer have a
> Distribution database, I wouldnt know what to tell you.
> Chane the column value that you were talking about and see
> if that help.
>
> have deleted everything related to the replication. So in
> my opinion there should not be any trace left of
> remove the replication info on a particular table? I
> really don't know what to do!
> you
> If
> info
> the
> in
> it
> other
> and
> there
> means
> then
>
|||Hi Jenny,
Some of your columns are still marked for replication - see
http://support.microsoft.com/default...b;en-us;811899
for a workaround.
Cheers,
Mark
*** Sent via Developersdex http://www.codecomments.com ***
Don't just participate in USENET...get rewarded for it!

Replication problem after installing SP3a

Hi.
We installed SP3 as described in
http://support.microsoft.com/default...&Product=sql2k
And now we have following errors running merge agents:
Category:SQLSERVER
Source: DB01
Number: 207
Message: Invalid column name 'published_in_tran_pub'.
Category:COMMAND
Source: Failed Command
Number: 0
Message: {call sp_MShelpmergearticles (?, 8000000, ?) }
Can anybody help with that?
Thanks,
Vova.
Forgot to attach instdist.out file:
--- file begin
=---
1> 2> 3> 4> 5> 6> 7> 8> 9> 10> 11> 12> 13> 14> 15> 16> 17> 18> 19> 20> 21>
22> 23> 24> 25> 26> 27> 28> 29>
----
At top, db_name()=
distribution
(1 row affected)
1> 2> 3> 4> 5> 6> 1> 2> 3> 1> 2> DBCC execution completed. If DBCC printed
error messages, contact your
system administrator.
Configuration option 'allow updates' changed from 0 to 1. Run the
RECONFIGURE statement to install.
1> 2> 1> 2> 3> 1> 2> 3> 4> 5> 6> 7> 8> 9> 10> 11> 12> 13> 14> 15> 16> 17>
18> 1> 2> 3> 4> 5> 6> 7> 8>
Creating distribution tables
1> 2> 3> 4> 5> 1> 2> 3> 4> 5> 6> 7> 8> 9> 10> 11> 12> 13> 14> 15> 16> 17>
18> 19> 20> 21> 22> 23> 24> 25> 26> 27> 28> 29> 30> 31> 32> 33> 34> 35> 36>
37> 38> 39> 40> 41> 42> 43> 44> 45> 46> 47> 48> 49> 50> 51> 52> 53> 54> 55>
56> 57> 58> 59> 60> 61> 62> 63> 64> 65> 66> 67> 68> 69> 70> 71> 72> 73> 74>
75> 76> 77> 78> 79> 80> 81> 82> 83> 84> 85> 86> 87> 88> 89> 90> 91> 92> 93>
94> 95> DBCC execution completed. If DBCC printed error messages, contact
your
system administrator.
Dropping all distribution stored procedures
95> 96> 97> 98> 1> 2> 3> 4> 5> 6> 1> 2> 3> Creating procedure
sp_MSislogreaderjobnamegenerated
98> 99> 100> 101> 102> 103> 1> 2> 3> Creating procedure
sp_MSisqueuereaderjobnamegenerated
Creating procedure sp_MSissnapshotjobnamegenerated
98> 99> 100> 101> 102> 103> 104> 105> 106> 107> 108> 1> 2> 3> 4> Creating
procedure sp_MSisdistributionjobnamegenerated
128> 129> 130> 131> 132> 1> 2> 3> 4> Creating procedure
sp_MSismergejobnamegenerated
5> 6> 7> 8> Creating 'fn_MSmask_agent_type'.
1> 2> 3> 4> 5> 6> 7> 8> 9> 10> 11> 12> 13> 14> 15> 16> 17> 18> 19> 20> 21>
22> 23> 24> 25> 26> 27> 28> 1> 2> 3> Creating 'sp_MScheck_pull_access'.
128> 129> 130> 131> 132> 133> 134> 135> 1> 2> 3> 4> Creating
'sp_MSquery_syncstates'.
1> 2> 3> 4> 5> 6> 7> 8> 9> 10> 11> 12> 13> 1> 2> 3> 4> Creating
'sp_MSset_syncstate'.
Creating 'sp_MSadd_repl_command'.
79> 80> 81> 82> 1> 2> 3> 4> Creating 'sp_MSadd_repl_commands27'.
1323> 1324> 1325> 1326> 1327> 1328> 1329> 1> 2> 3> Creating
'sp_MSadd_repl_commands27hp6x'.
15> 16> 17> 18> 19> Creating 'sp_MSadd_repl_commands27hp'.
11> 12> 13> 14> 15> 16> 17> 18> 19> 20> 21> Creating
'sp_MSadd_repl_commands27hp_mcit'.
188> 189> 190> 191> 192> 193> 194> 195> 196> 197> 198> 1> 2> 3> 4> Creating
'sp_MSvalidate_distpublisher'.
1> 2> 3> 4> 5> 6> 7> 8> 9> 10> 11> 12> 13> 14> 15> 16> 17> 18> 19> 20> 21>
22> 23> 24> 25> 26> 27> 28> 29> 30> 31> 32> 33> 34> 35> 36> 37> 38> 39> 40>
41> 42> 43> 44> 45> 46> 47> 48> 1> 2> 3> Creating
'sp_MSdrop_distribution_agent'.
1> 2> 3> 4> 5> 6> 7> 8> 9> 10> 11> 12> 13> 14> 15> 16> 17> 18> 19> 20> 21>
3> Creating 'sp_MSdrop_distribution_agentid'.
1> 2> 3> 4> 5> 6> 7> 8> 9> 10> 11> 12> 13> 14> 15> 16> 17> 18> 19> 20> 21>
22> 23> 24> 25> 26> 27> 28> 29> 30> 31> 32> 33> 34> 35> 36> 37> 38> 39> 40>
41> 42> 43> 44> 45> 46> 1> 2> 3> Creating 'sp_MSdrop_qreader_agent'.
1> 2> 3> 4> 5> 6> 7> 8> 9> 10> 11> 12> 13> 14> 15> 16> 17> 18> 19> 20> 21>
22> 23> 24> 25> 26> 27> 28> 29> 30> 31> 32> 33> 34> 35> 36> 37> 38> 39> 40>
41> 42> 43> 44> 45> 46> 47> 48> 49> 50> 51> 52> 53> 54> 55> 56> 57> 58> 59>
60> 61> 62> 63> 64> 65> 66> 67> 68> 69> 70> 71> 72> 73> 74> 75> 1> 2> 3>
Creating 'sp_MSdrop_qreader_history'.
1> 2> 3> 4> 5> 6> 7> 8> 9> 10> 11> 12> 13> 14> 15> 1> 2> 3> Creating
'sp_MSdrop_merge_agentid'.
1> 2> 3> 4> 5> 6> 7> 8> 9> 10> 11> 12> 13> 14> 15> 16> 17> 18> 19> 20> 21>
22> 23> 24> 25> 26> 27> 28> 29> 30> 31> 32> 33> 34> 35> 36> 37> 38> 39> 40>
41> 42> 43> 44> 45> 1> 2> 3> Creating 'sp_MSadd_qreader_agent'.
248> 249> 250> 251> 252> 253> 254> 255> 1> 2> 3> Creating
'sp_MSadd_distribution_agent'.
Cannot add rows to sysdepends for the current stored procedure because
it depends on the missing object 'sp_MSenableagentoffload'. The stored
procedure will still be created.
Cannot add rows to sysdepends for the current stored procedure because
it depends on the missing object 'sp_MSdisableagentoffload'. The
stored procedure will still be created.
1> 2> 3> Creating 'sp_MSdrop_agent_entry'.
1> 2> 3> 4> 5> 6> 7> 8> 9> 10> 11> 12> 13> 14> 15> 1> 2> 3> 4> Creating
'sp_MSdrop_merge_agent'.
128> 129> 130> 131> 132> 1> 2> 3> Creating 'sp_MSgetagentoffloadinfo'.
1> 2> 3> 4> 5> 6> 7> 8> 9> 10> 11> 12> 13> 14> 15> 16> 17> 18> 19> 20> 21>
22> 23> 24> 25> 26> 27> 28> 29> 30> 31> 32> 33> 34> 35> 36> 37> 38> 39> 40>
41> 42> 43> 44> 45> 46> 47> 48> 49> 50> 51> 52> 53> 54> 55> 56> 57> 58> 59>
60> 61> 62> 63> 64> 65> 1> 2> 3> Creating 'sp_MSadd_merge_agent'.
353> 354> 355> 356> Cannot add rows to sysdepends for the current stored
procedure because
it depends on the missing object 'sp_MSenableagentoffload'. The stored
procedure will still be created.
Cannot add rows to sysdepends for the current stored procedure because
it depends on the missing object 'sp_MSdisableagentoffload'. The
stored procedure will still be created.
1> 2> 3> Creating 'sp_MSdrop_subscription'.
278> 279> 280> 281> 282> 283> 284> 285> 286> 287> 288> 1> 2> 3> Creating
'sp_MSadd_subscription'.
563> 564> 565> 566> 567> 568> 569> 1> 2> 3> Creating
'sp_MSupdate_subscription'.
6> 7> 8> Creating 'sp_MSget_repl_commands'.
383> 384> 385> 386> 387> 388> 389> 390> 1> 2> 3> 4> 5> Creating
'sp_MSget_repl_cmds_anonymous'.
1> 2> 3> 4> 5> 6> 7> 8> 9> 10> 11> 12> 13> 14> 15> 16> 17> 18> 19> 20> 21>
22> 23> 24> 25> 26> 27> 28> 29> 30> 31> 32> 33> 34> 35> 36> 37> 38> 39> 40>
41> 42> 43> 1> 2> 3> 4> 5> Creating 'sp_MSanonymous_status'.
1> 2> 3> 4> 5> 6> 7> 8> 9> 10> 11> 12> 13> 14> 15> 16> 17> 18> 19> 20> 21>
22> 23> 24> 25> 26> 27> 28> 29> 30> 31> 32> 33> 34> 35> 36> 37> 38> 39> 40>
41> Cannot add rows to sysdepends for the current stored procedure because
it depends on the missing object 'dbo.sp_MSsubscription_status'. The
stored procedure will still be created.
1> 2> 3> Creating 'sp_MSadd_anonymous_agent'.
3> 4> Creating 'sp_MSsubscription_status'.
6> Creating 'sp_MSget_last_transaction'.
60> 61> 62> 63> 64> 65> 66> 1> 2> 3> Creating 'sp_MSadd_subscriber_info'.
98> 99> 100> 101> 102> 103> 104> 105> 106> 107> 108> 109> 1> 2> 3> Creating
'sp_MSadd_subscriber_schedule'.
1> 2> 3> 4> 5> 6> 7> 8> 9> 10> 11> 12> 13> 14> 15> 16> 17> 18> 19> 20> 21>
22> 23> 24> 25> 26> 27> 28> 29> 30> 31> 32> 33> 34> 35> 36> 37> 38> 39> 40>
41> 42> 43> 44> 45> 46> 47> 48> 49> 50> 51> 52> 53> 54> 1> 2> 3> 4> 5>
Creating 'sp_MSupdate_subscriber_info'.
158> 159> 160> 161> 162> 163> 164> 165> 166> 167> 1> 2> 3> Creating
'sp_MScheck_Jet_Subscriber'.
1> 2> 3> 4> 5> 6> 7> 8> 9> 10> 11> 12> 13> 14> 15> 1> 2> 3> 4> 5> 6> 7>
Creating 'sp_MScheckretention'.
1> 2> 3> 4> 5> 6> 7> 8> 9> 10> 11> 12> 13> 14> 15> 16> 17> 18> 19> 20> 21>
22> 23> 24> 25> 26> 27> 28> 29> 30> 31> 32> 1> 2> 3> Creating
'sp_MSupdate_subscriber_schedule'.
1> 2> 3> 4> 5> 6> 7> 8> 9> 10> 11> 12> 13> 14> 15> 16> 17> 18> 19> 20> 21>
22> 23> 24> 25> 26> 27> 28> 29> 30> 31> 32> 33> 34> 35> 36> 37> 38> 39> 40>
41> 42> 43> 44> 45> 46> 47> 48> 49> 50> 51> 52> 53> 54> 55> 56> 57> 58> 59>
60> 61> 62> 63> 64> 65> 66> 67> 68> 69> 70> 71> 72> 73> 74> 75> 76> 77> 78>
79> 80> 81> 82> 83> 84> 85> 86> 87> 88> 89> 90> 91> 92> 93> 94> 95> 96> 97>
98> 99> 100> 101> 102> 103> 104> 105> 106> 107> 1> 2> 3> 4> Creating
'sp_MSdrop_subscriber_info'.
1> 2> 3> 4> 5> 6> 7> 8> 9> 10> 11> 12> 13> 14> 15> 16> 17> 18> 19> 20> 21>
22> 23> 24> 25> 26> 27> 28> 29> 30> 31> 32> 33> 34> 35> 36> 37> 38> 39> 40>
41> 42> 43> 44> 45> 46> 47> 48> 1> 2> 3> 4> 5> 6> 7> Creating
'sp_MScleanup_agent_entry'.
1> 2> 3> 4> 5> 6> 7> 8> 9> 10> 11> 12> 13> 14> 15> 16> 17> 18> 19> 20> 21>
22> 23> 24> 25> 26> 27> 28> 29> 30> 31> 32> 33> 34> 35> 36> 37> 38> 39> 40>
41> 42> 43> 44> 45> 46> 47> 48> 49> 50> 51> 52> 53> 54> 55> 56> 57> 58> 59>
60> 61> 62> 63> 64> 65> 66> 67> 68> 69> 70> 71> 72> 73> 74> 75> 76> 77> 78>
79> 80> 81> 82> 83> 84> 85> 86> 87> 88> 89> 90> 1> 2> 3> Creating
'sp_MShelp_subscription_status'.
1> 2> 3> 4> 5> 6> 7> 8> 9> 10> 11> 12> 13> 14> 15> 16> 17> 18> 19> 20> 21>
22> 23> 24> 25> 26> 27> 28> 29> 30> 31> 32> 33> 34> 35> 36> 37> 38> 39> 40>
41> 42> 43> 44> 45> 46> 47> 48> 49> 50> 51> 52> 53> 54> 55> 56> 57> 58> 59>
60> 61> 62> 63> 64> 65> 66> 67> 68> 69> 70> 71> 72> 73> 74> 75> 76> 77> 78>
79> 80> 81> 82> 1> 2> 3> 4> 5> Creating 'sp_MShelp_subscriber_info'.
1> 2> 3> 4> 5> 6> 7> 8> 9> 10> 11> 12> 13> 14> 15> 16> 17> 18> 19> 20> 21>
22> 23> 24> 25> 26> 27> 28> 29> 30> 31> 32> 33> 34> 35> 36> 37> 38> 39> 40>
41> 42> 43> 44> 45> 46> 47> 48> 49> 50> 51> 52> 53> 54> 55> 56> 57> 58> 59>
60> 61> 62> 63> 64> 65> 66> 67> 68> 69> 70> 71> 72> 73> 74> 75> 76> 77> 78>
79> 80> 81> 82> 83> 84> 85> 86> 87> 88> 89> 90> 91> 92> 93> 1> 2> 3>
Creating 'sp_MSdistribution_counters'.
1> 2> 3> 4> 5> 6> 7> 8> 9> 10> 11> 12> 13> 14> 15> 16> 17> 18> 19> 20> 21>
22> 23> 24> 25> 26> 27> 28> 29> 30> 31> 32> 33> 34> 35> 36> 37> 38> 39> 40>
41> 42> 43> 44> 45> 46> 47> 48> 49> 50> 51> 52> 53> 54> 55> 56> 57> 58> 59>
60> 61> 62> 63> 64> 65> 66> 67> 68> 69> 70> 71> 72> 73> 74> 75> 76> 77> 78>
79> 80> 81> 82> 83> 84> 85> 86> 87> 88> 89> 90> 91> 92> 93> 94> 95> 96> 97>
98> 99> 100> 101> 102> 103> 104> 105> 106> 107> 108> 109> 110> 111> 112>
113> 114> 115> 116> 117> 118> 119> 120> 121> 122> 123> 124> 125> 126> 127>
128> 129> 130> 131> 132> 133> 134> 135> 1> 2> 3> Creating
'sp_MSremove_published_jobs'.
1> 2> 3> 4> 5> 6> 7> 8> 1> 2> 3> Creating 'sp_MSset_snapshot_xact_seqno'.
1> 2> 3> 4> 5> 6> 7> 8> 9> 10> 11> 12> 13> 14> 15> 16> 17> 18> 19> 20> 21>
22> 23> 24> 25> 26> 27> 28> 29> 30> 31> 32> 33> 34> 35> 36> 37> 38> 39> 40>
41> 42> 43> 44> 45> 46> 47> 48> 49> 50> 51> 52> 53> 54> 55> 56> 57> 58> 59>
60> 61> 62> 63> 64> 65> 66> 67> 68> 69> 70> 71> 72> 73> 74> 75> 76> 77> 78>
79> 80> 81> 82> 83> 84> 85> 86> 87> 88> 89> 90> 91> 92> 93> 94> 95> 96> 97>
98> 99> 100> 101> 102> 103> 104> 105> 106> 107> 108> 109> 110> 111> 112>
113> 1> 2> 3> 4> Creating 'sp_MSdrop_article'.
1> 2> 3> 4> 5> 6> 7> 8> 9> 10> 11> 12> 13> 14> 15> 16> 17> 18> 19> 20> 21>
22> 23> 24> 25> 26> 27> 28> 29> 30> 31> 32> 33> 34> 35> 36> 37> 38> 39> 40>
41> 42> 43> 44> 45> 46> 47> 48> 49> 50> 51> 52> 53> 54> 55> 56> 57> 58> 59>
60> 61> 62> 63> 64> 65> 66> 67> 68> 69> 70> 71> 72> 73> 74> 75> 76> 77> 78>
79> 80> 81> 82> 83> 84> 85> 86> 87> 88> 89> 90> 91> 92> 93> 94> 95> 96> 97>
98> 99> 100> 101> 102> 103> 104> 105> 106> 107> 108> 109> 110> 111> 112>
113> 114> 115> 116> 117> 118> 119> 120> 121> 122> 123> 124> 125> 126> 127>
1> 2> 3> Creating 'sp_MSdrop_snapshot_agent'.
1> 2> 3> 4> 5> 6> 7> 8> 9> 10> 11> 12> 13> 14> 15> 16> 17> 18> 19> 20> 21>
22> 23> 24> 25> 26> 27> 28> 29> 30> 31> 32> 33> 34> 35> 36> 37> 38> 39> 40>
41> 42> 43> 44> 45> 46> 47> 48> 49> 50> 51> 52> 53> 54> 55> 56> 57> 58> 59>
60> 61> 62> 63> 64> 65> 66> 67> 68> 69> 70> 71> 72> 73> 74> 75> 76> 77> 78>
79> 80> 81> 82> 83> 84> 85> 86> 87> 88> 89> 90> 91> 92> 93> 94> 95> 96> 97>
98> 99> 100> 101> 102> 1> 2> 3> 4> Creating 'sp_MSdrop_logreader_agent'.
1> 2> 3> 4> 5> 6> 7> 8> 9> 10> 11> 12> 13> 14> 15> 16> 17> 18> 19> 20> 21>
22> 23> 24> 25> 26> 27> 28> 29> 30> 31> 32> 33> 34> 35> 36> 37> 38> 39> 40>
41> 42> 43> 44> 45> 46> 47> 48> 49> 50> 51> 52> 53> 54> 55> 56> 57> 58> 59>
60> 61> 62> 63> 64> 65> 66> 67> 68> 69> 70> 71> 72> 73> 74> 75> 76> 77> 78>
79> 80> 81> 82> 83> 84> 85> 86> 87> 88> 89> 90> 91> 92> 93> 94> 95> 96> 97>
98> 99> 100> 1> 2> 3> Creating 'sp_MSdrop_publication'.
233> 234> 235> 236> 237> Cannot add rows to sysdepends for the current
stored procedure because
it depends on the missing object 'sp_MSreplremoveuncdir'. The stored
procedure will still be created.
Cannot add rows to sysdepends for the current stored procedure because
it depends on the missing object 'sp_MSreplremoveuncdir'. The stored
procedure will still be created.
1> 2> Creating 'sp_MSadd_snapshot_agent'.
Creating 'sp_MSadd_logreader_agent'.
1> 2> 3> Creating 'sp_MSadd_publication'.
2> 3> Creating 'sp_MSrepl_raiserror'.
1> 2> 3> 4> 5> 6> 7> 8> 9> 10> 11> 12> 13> 14> 15> 16> 17> 18> 19> 20> 21>
22> 23> 24> 25> 26> 27> 28> 29> 30> 1> 2> 3> Creating
'sp_MSget_new_errorid'.
1> 2> 3> 4> 5> 6> 7> 8> 9> 10> 11> 12> 13> 14> 15> 16> 17> 18> 19> 20> 21>
22> 23> 24> 25> 26> 27> 28> 29> 30> 31> 32> 33> 34> 1> 2> 3> Creating
'sp_MSadd_qreader_history'.
233> 234> 1> 2> 3> Creating 'sp_MSadd_snapshot_history'.
158> 159> 160> 161> 162> 163> 164> 165> 166> 1> 2> 3> 4> Creating
'sp_MSadd_logreader_history'.
1> 2> 3> 4> 5> 6> 7> 8> 9> 10> 11> 12> 13> 14> 15> 16> 17> 18> 19> 20> 21>
22> 23> 24> 25> 26> 27> 28> 29> 30> 31> 32> 33> 34> 35> 36> 37> 38> 39> 40>
41> 42> 43> 44> 45> 46> 47> 48> 49> 50> 51> 52> 53> 54> 55> 56> 57> 58> 59>
60> 61> 62> 63> 64> 65> 66> 67> 68> 69> 70> 71> 72> 73> 74> 75> 76> 77> 78>
79> 80> 81> 82> 83> 84> 85> 86> 87> 88> 89> 90> 91> 92> 93> 94> 95> 96> 97>
98> 99> 100> 101> 102> 103> 104> 105> 106> 107> 108> 109> 110> 111> 112>
113> 114> 115> 116> 117> 118> 119> 120> 121> 122> 123> 124> 125> 126> 127>
128> 129> 130> 131> 132> 133> 134> 135> 136> 137> 138> 139> 140> 141> 142>
143> 144> 145> 146> 147> 148> 149> 150> 151> 152> 153> 154> 155> 156> 157>
158> 159> 160> 161> 162> 163> 164> 165> 166> 167> 168> 169> 170> 171> 172>
173> 174> 175> 176> 177> 178> 179> 180> 181> 182> 183> 184> 185> 186> 187>
188> 189> 190> 191> 192> 193> 194> 195> 196> 197> 198> 199> 200> 201> 202>
203> 204> 205> 206> 207> 208> 209> 210> 211> 212> 213> 214> 215> 216> 217>
218> 219> 220> 221> 222> 223> 224> 225> 226> 227> 228> 229> 230> 231> 232>
233> 234> 235> 236> 237> 238> 239> 240> 241> 242> 243> 244> 245> 246> 247>
248> 249> 250> 251> 252> 253> 254> 255> 256> 257> 258> 259> 260> 261> 262>
1> 2> 3> Creating 'sp_MSadd_distribution_history'.
1> 2> 3> 4> 5> 6> 7> 8> 9> 10> 11> 12> 13> 14> 15> 16> 17> 18> 19> 20> 21>
22> 23> 24> 25> 26> 27> 28> 29> 30> 31> 32> 33> 34> 35> 36> 37> 38> 39> 40>
41> 42> 43> 44> 45> 46> 47> 48> 49> 50> 51> 52> 53> 54> 55> 56> 57> 58> 59>
60> 61> 62> 63> 64> 65> 66> 67> 68> 69> 70> 71> 72> 73> 74> 75> 76> 77> 78>
79> 80> 81> 82> 83> 84> 85> 86> 87> 88> 89> 90> 91> 92> 93> 94> 95> 96> 97>
98> 99> 100> 101> 102> 103> 104> 105> 106> 107> 108> 109> 110> 111> 112>
113> 114> 115> 116> 117> 118> 119> 120> 121> 122> 123> 124> 125> 126> 127>
128> 129> 130> 131> 132> 133> 134> 135> 136> 137> 138> 139> 140> 141> 142>
143> 144> 145> 146> 147> 148> 149> 150> 151> 152> 153> 154> 155> 156> 157>
158> 159> 160> 161> 162> 163> 164> 165> 166> 167> 168> 169> 170> 171> 172>
173> 174> 175> 176> 177> 178> 179> 180> 181> 182> 183> 184> 185> 186> 187>
188> 189> 190> 191> 192> 193> 194> 195> 196> 197> 198> 199> 200> 201> 202>
203> 204> 205> 206> 207> 208> 209> 210> 211> 212> 213> 214> 215> 216> 217>
218> 219> 220> 221> 222> 223> 224> 225> 226> 227> 228> 229> 230> 231> 232>
233> 234> 235> 236> 237> 238> 239> 240> 241> 242> 243> 244> 245> 246> 247>
248> 249> 250> 251> 252> 253> 254> 255> 256> 257> 258> 259> 260> 261> 262>
263> 264> 265> 266> 267> 268> 269> 270> 271> 272> 273> 274> 275> 276> 277>
278> 279> 280> 281> 282> 283> 284> 285> 286> 287> 288> 289> 290> 291> 292>
293> 294> 295> 296> 297> 298> 299> 300> 301> 302> 303> 304> 305> 306> 307>
308> 309> 310> 311> 312> 313> 314> 315> 316> 317> 318> 319> 320> 321> 322>
323> 324> 325> 326> 327> 328> 329> 330> 331> 332> 333> 334> 335> 336> 337>
338> 339> 340> 341> 342> 343> 344> 345> 346> 347> 348> 349> 350> 351> 352>
353> 354> 355> 356> 357> 358> 359> 360> 361> 362> 363> 364> 365> 366> 367>
368> 369> 370> 371> 372> 373> 374> 375> 376> 377> 378> 379> 380> 381> 382>
383> 384> 385> 386> 387> 388> 389> 390> 391> 392> 393> 394> 1> 2> 3>
Creating 'sp_MSsubscription_cleanup'.
1> 2> 3> 4> 5> 6> 7> 8> 9> 10> 11> 12> 13> 14> 15> 16> 17> 18> 19> 20> 21>
22> 23> 24> 25> 26> 27> 28> 29> 30> 31> 32> 33> 34> 35> 36> 37> 38> 39> 40>
41> 42> 43> 44> 45> 46> 47> 48> 49> 50> 51> 52> 53> 54> 55> 56> 57> 58> 59>
60> 61> 62> 63> 64> 65> 66> 67> 68> 69> 70> 71> 72> 73> 74> 75> 76> 77> 78>
79> 80> 81> 82> 83> 84> 85> 86> 87> 88> 89> 90> 91> 92> 93> 94> 95> 96> 97>
98> 99> 100> 101> 102> 103> 104> 105> 106> 107> 108> 109> 110> 111> 112>
113> 114> 115> 116> 117> 118> 119> 120> 121> 122> 123> 124> 125> 126> 127>
128> 129> 130> 131> 132> 133> 134> 135> 136> 137> 138> 139> 140> 141> 142>
143> 144> 145> 146> 147> 148> 149> 150> 151> 152> 153> 154> 155> 156> 157>
158> 159> 160> 161> 162> 163> 164> 165> 166> 167> 168> 169> 170> 171> 172>
173> 174> 175> 176> 177> 178> 179> 180> 181> 182> 183> 184> 185> 186> 187>
188> 189> 190> 1> 2> 3> Creating 'sp_MSreplremoveuncdir'.
1> 2> 3> 4> 5> 6> 7> 8> 9> 10> 11> 12> 13> 14> 15> 16> 17> 18> 19> 20> 21>
22> 23> 24> 25> 26> 27> 28> 29> 30> 31> 32> 33> 34> 35> 36> 37> 38> 39> 40>
41> 42> 43> 44> 45> 46> 47> 1> 2> 3> Creating 'sp_MSdrop_snapshot_dirs'.
1> 2> 3> 4> 5> 6> 7> 8> 9> 10> 11> 12> 13> 14> 15> 16> 17> 18> 19> 20> 21>
22> 23> 24> 25> 26> 27> 28> 29> 30> 31> 32> 33> 34> 35> 36> 37> 38> 39> 40>
41> 42> 43> 1> 2> 3> Creating 'sp_MSfast_delete_trans'.
1> 2> 3> 4> 5> 6> 7> 8> 9> 10> 11> 12> 1> 2> 3> Creating
'sp_MSdelete_dodelete'.
1> 2> 3> 4> 5> 6> 7> 8> 9> 10> 11> 12> 13> 14> 15> 16> 17> 18> 1> 2> 3>
Creating 'sp_MSdelete_publisherdb_trans'.
1> 2> 3> 4> 5> 6> 7> 8> 9> 10> 11> 12> 13> 14> 15> 16> 17> 18> 19> 20> 21>
22> 23> 24> 25> 26> 27> 28> 29> 30> 31> 32> 33> 34> 35> 36> 37> 38> 39> 40>
41> 42> 43> 44> 45> 46> 47> 48> 49> 50> 51> 52> 53> 54> 55> 56> 57> 58> 59>
60> 61> 62> 63> 64> 65> 66> 67> 68> 69> 70> 71> 72> 73> 74> 75> 76> 77> 78>
79> 80> 81> 82> 83> 84> 85> 86> 87> 88> 89> 90> 91> 92> 93> 94> 95> 96> 97>
98> 99> 100> 101> 102> 103> 104> 105> 106> 107> 108> 109> 110> 111> 112>
113> 114> 115> 116> 117> 118> 119> 120> 121> 122> 123> 124> 125> 126> 127>
128> 129> 130> 131> 132> 133> 134> 135> 136> 137> 138> 139> 140> 141> 142>
143> 144> 145> 146> 147> 148> 149> 150> 151> 152> 153> 154> 155> 156> 157>
158> 159> 160> 161> 162> 163> 164> 165> 166> 167> 168> 169> 170> 171> 172>
173> 174> 175> 176> 177> 178> 179> 180> 181> 182> 183> 184> 185> 186> 187>
188> 189> 190> 191> 192> 193> 194> 195> 196> 197> 198> 199> 200> 201> 202>
203> 204> 205> 206> 207> 208> 209> 210> 211> 212> 213> 214> 215> 216> 217>
218> 219> 220> 221> 222> 1> 2> 3> Creating 'sp_MSmaximum_cleanup_seqno'.
1> 2> 3> 4> 5> 6> 7> 8> 9> 10> 11> 12> 13> 14> 15> 16> 17> 18> 19> 20> 21>
22> 23> 24> 25> 26> 27> 28> 29> 30> 31> 32> 33> 34> 35> 36> 37> 38> 39> 40>
41> 42> 43> 44> 45> 46> 47> 48> 49> 50> 51> 52> 53> 54> 55> 56> 57> 58> 59>
60> 61> 62> 63> 64> 65> 66> 67> 68> 69> 70> 71> 72> 73> 74> 75> 76> 77> 78>
79> 80> 81> 82> 83> 84> 85> 86> 87> 88> 89> 90> 91> 92> 93> 94> 95> 96> 97>
98> 99> 100> 101> 102> 103> 104> 105> 106> 107> 108> 109> 110> 111> 112>
113> 114> 115> 116> 117> 118> 119> 120> 121> 122> 123> 124> 125> 126> 127>
128> 129> 130> 131> 132> 133> 134> 135> 136> 137> 138> 139> 140> 141> 142>
143> 144> 145> 146> 147> 148> 149> 150> 151> 152> 153> 154> 155> 156> 1> 2>
3> Creating 'sp_MSdistribution_delete'.
1> 2> 3> 4> 5> 6> 7> 8> 9> 10> 11> 12> 13> 14> 15> 16> 17> 18> 19> 20> 21>
22> 23> 24> 25> 26> 27> 28> 29> 30> 31> 32> 33> 34> 35> 36> 37> 38> 39> 40>
41> 42> 43> 44> 45> 46> 47> 48> 49> 50> 51> 52> 53> 54> 55> 56> 57> 58> 59>
60> 61> 62> 63> 64> 65> 66> 67> 68> 69> 70> 71> 72> 73> 74> 1> 2> 3> 4>
Creating 'sp_MSdistribution_cleanup'.
1> 2> 3> 4> 5> 6> 7> 8> 9> 10> 11> 12> 13> 14> 15> 16> 17> 18> 19> 20> 21>
22> 23> 24> 25> 26> 27> 28> 29> 30> 31> 32> 33> 34> 35> 36> 37> 38> 39> 40>
41> 42> 43> 44> 45> 46> 47> 48> 49> 50> 51> 52> 53> 54> 55> 56> 57> 58> 59>
60> 61> 1> 2> 3> Creating 'sp_MShistory_cleanup'.
1> 2> 3> 4> 5> 6> 7> 8> 9> 10> 11> 12> 13> 14> 15> 16> 17> 18> 19> 20> 21>
22> 23> 24> 25> 26> 27> 28> 29> 30> 31> 32> 33> 34> 35> 36> 37> 38> 39> 40>
41> 42> 43> 44> 45> 46> 47> 48> 49> 50> 51> 52> 53> 54> 55> 56> 57> 58> 59>
60> 61> 62> 63> 64> 65> 66> 67> 68> 69> 70> 71> 72> 73> 74> 75> 76> 77> 78>
79> 80> 81> 82> 83> 84> 85> 86> 87> 88> 89> 90> 91> 92> 93> 94> 95> 96> 97>
98> 99> 100> 101> 102> 103> 104> 105> 106> 107> 108> 109> 110> 111> 112>
113> 114> 115> 116> 117> 118> 119> 120> 121> 122> 123> 124> 125> 126> 127>
128> 129> 130> 131> 132> 133> 134> 135> 136> 137> 138> 139> 140> 141> 142>
143> 144> 145> 146> 147> 148> 149> 150> 151> 152> 153> 154> 155> 156> 157>
158> 159> 160> 161> 162> 163> 164> 165> 166> 167> 168> 169> 170> 171> 172>
173> 174> 175> 176> 177> 1> 2> 3> Creating 'sp_MSget_repl_version'.
1> 2> 3> 4> 5> 6> 7> 8> 9> 10> 1> 2> 3> Creating 'sp_MSenum_subscriptions'.
1> 2> 3> 4> 5> 6> 7> 8> 9> 10> 11> 12> 13> 14> 15> 16> 17> 18> 19> 20> 21>
22> 23> 24> 25> 26> 27> 28> 29> 30> 31> 32> 33> 34> 35> 36> 37> 38> 39> 40>
41> 42> 43> 44> 45> 46> 47> 48> 49> 50> 51> 52> 53> 54> 55> 56> 57> 58> 59>
60> 61> 62> 63> 64> 65> 66> 67> 68> 69> 70> 71> 72> 73> 74> 75> 76> 77> 78>
79> 80> 81> 82> 83> 84> 85> 86> 87> 88> 89> 90> 91> 92> 93> 94> 95> 96> 97>
98> 99> 100> 101> 102> 103> 104> 105> 106> 107> 108> 109> 110> 111> 112>
113> 114> 115> 116> 117> 118> 119> 120> 121> 122> 123> 124> 125> 126> 127>
128> 129> 130> 131> 132> 133> 134> 135> 136> 137> 138> 139> 140> 141> 142>
143> 144> 145> 146> 147> 148> 149> 150> 151> 152> 153> 154> 155> 156> 157>
158> 159> 160> 161> 162> 163> 164> 165> 166> 1> 2> 3> 4> Creating
'sp_MSIfExistsSubscription'.
1> 2> 3> 4> 5> 6> 7> 8> 9> 10> 11> 12> 13> 14> 15> 16> 17> 18> 19> 20> 21>
22> 23> 24> 25> 26> 27> 28> 29> 30> 31> 32> 33> 34> 35> 36> 37> 38> 39> 40>
41> 42> 43> 44> 45> 46> 47> 48> 49> 50> 51> 52> 1> 2> 3> 4> Creating
'sp_MSenum_snapshot'.
1> 2> 3> 4> 5> 6> 7> 8> 9> 10> 11> 12> 13> 14> 15> 16> 17> 18> 19> 20> 21>
22> 23> 24> 25> 26> 27> 28> 29> 30> 31> 32> 33> 34> 35> 36> 37> 38> 39> 40>
41> 42> 43> 44> 45> 46> 47> 48> 49> 50> 51> 52> 53> 54> 55> 56> 57> 58> 59>
60> 61> 62> 63> 64> 65> 66> 67> 68> 69> 70> 71> 72> 73> 74> 75> 76> 77> 78>
79> 80> 81> 82> 83> 84> 85> 86> 87> 88> 89> 90> 91> 92> 93> 94> 95> 96> 97>
98> 99> 100> 101> 102> 103> 104> 105> 106> 1> 2> 3> Creating
'sp_MSenum_snapshot_s'.
1> 2> 3> 4> 5> 6> 7> 8> 9> 10> 11> 12> 13> 14> 15> 16> 17> 18> 19> 20> 21>
22> 23> 24> 25> 26> 27> 28> 29> 30> 31> 32> 33> 34> 35> 36> 37> 38> 39> 40>
41> 42> 43> 44> 45> 46> 47> 48> 49> 50> 51> 52> 53> 54> 55> 56> 57> 58> 59>
60> 61> 62> 63> 64> 65> 66> 67> 68> 69> 70> 71> 72> 73> 74> 75> 76> 77> 78>
79> 80> 81> 82> 83> 84> 85> 86> 87> 88> 89> 90> 91> 92> 93> 94> 95> 96> 97>
1> 2> 3> 4> Creating 'sp_MSenum_snapshot_sd'.
1> 2> 3> 4> 5> 6> 7> 8> 9> 10> 11> 12> 13> 14> 15> 16> 17> 18> 19> 20> 21>
22> 23> 24> 25> 26> 27> 28> 29> 30> 31> 32> 33> 34> 35> 36> 37> 38> 39> 40>
41> 42> 43> 44> 45> 46> 47> 48> 49> 50> 51> 52> 53> 54> 55> 56> 57> 58> 59>
60> 61> 62> 63> 64> 65> 66> 67> 68> 69> 70> 71> 72> 1> 2> 3> 4> Creating
'sp_MSenum_logreader'.
1> 2> 3> 4> 5> 6> 7> 8> 9> 10> 11> 12> 13> 14> 15> 16> 17> 18> 19> 20> 21>
22> 23> 24> 25> 26> 27> 28> 29> 30> 31> 32> 33> 34> 35> 36> 37> 38> 39> 40>
41> 42> 43> 44> 45> 46> 47> 48> 49> 50> 51> 52> 53> 54> 55> 56> 57> 58> 59>
60> 61> 62> 63> 64> 65> 66> 67> 68> 69> 70> 71> 72> 73> 74> 75> 76> 77> 78>
79> 80> 81> 82> 83> 84> 85> 86> 87> 88> 89> 90> 91> 92> 93> 94> 95> 96> 97>
98> 99> 100> 101> 102> 1> 2> 3> 4> Creating 'sp_MSenum_logreader_s'.
1> 2> 3> 4> 5> 6> 7> 8> 9> 10> 11> 12> 13> 14> 15> 16> 17> 18> 19> 20> 21>
22> 23> 24> 25> 26> 27> 28> 29> 30> 31> 32> 33> 34> 35> 36> 37> 38> 39> 40>
41> 42> 43> 44> 45> 46> 47> 48> 49> 50> 51> 52> 53> 54> 55> 56> 57> 58> 59>
60> 61> 62> 63> 64> 65> 66> 67> 68> 69> 70> 71> 72> 73> 74> 75> 76> 77> 78>
79> 80> 81> 82> 83> 1> 2> 3> Creating 'sp_MSenum_logreader_sd'.
1> 2> 3> 4> 5> 6> 7> 8> 9> 10> 11> 12> 13> 14> 15> 16> 17> 18> 19> 20> 21>
22> 23> 24> 25> 26> 27> 28> 29> 30> 31> 32> 33> 34> 35> 36> 37> 38> 39> 40>
41> 42> 43> 44> 45> 1> 2> 3> Creating 'sp_MSenum_qreader'.
1> 2> 3> 4> 5> 6> 7> 8> 9> 10> 11> 12> 13> 14> 15> 16> 17> 18> 19> 20> 21>
22> 23> 24> 25> 26> 27> 28> 29> 30> 31> 32> 33> 34> 35> 36> 37> 38> 39> 40>
41> 42> 43> 44> 45> 46> 47> 48> 49> 50> 51> 52> 53> 54> 55> 56> 57> 58> 59>
60> 61> 62> 63> 64> 65> 66> 67> 68> 69> 70> 71> 72> 73> 74> 75> 76> 77> 78>
79> 80> 81> 82> 83> 84> 85> 86> 87> 88> 89> 90> 91> 92> 93> 94> 95> 96> 97>
98> 99> 100> 101> 102> 103> 104> 105> 106> 107> 108> 109> 110> 111> 112>
113> 114> 115> 116> 1> 2> 3> 4> Creating 'sp_MSenum_qreader_s'.
1> 2> 3> 4> 5> 6> 7> 8> 9> 10> 11> 12> 13> 14> 15> 16> 17> 18> 19> 20> 21>
22> 23> 24> 25> 26> 27> 28> 29> 30> 31> 32> 33> 34> 35> 36> 37> 38> 39> 40>
41> 42> 43> 44> 45> 46> 47> 48> 49> 50> 51> 52> 53> 54> 55> 56> 57> 58> 59>
60> 61> 62> 63> 64> 65> 66> 67> 68> 69> 70> 71> 72> 73> 74> 75> 76> 77> 78>
79> 80> 81> 82> 83> 84> 85> 86> 87> 88> 89> 90> 91> 92> 93> 94> 95> 96> 97>
98> 99> 100> 101> 102> 103> 104> 105> 106> 107> 108> 109> 110> 111> 112>
113> 114> 115> 116> 117> 118> 119> 120> 121> 122> 123> 124> 125> 126> 127>
128> 129> 130> 131> 132> 133> 134> 135> 136> 137> 138> 139> 140> 141> 142>
143> 144> 145> 146> 147> 148> 149> 150> 151> 152> 153> 154> 155> 156> 157>
158> 159> 160> 161> 162> 163> 164> 165> 166> 167> 168> 169> 170> 171> 172>
173> 174> 175> 176> 177> 178> 179> 180> 181> 182> 183> 184> 185> 186> 187>
188> 189> 190> 191> 192> 193> 194> 195> 196> 197> 198> 199> 200> 201> 202>
203> 204> 205> 206> 207> 208> 209> 210> 211> 212> 213> 214> 215> 216> 217>
218> 219> 220> 221> 222> 223> 224> 225> 226> 227> 228> 229> 230> 231> 232>
233> 1> 2> 3> 4> Creating 'sp_MSenum_qreader_sd'.
1> 2> 3> 4> 5> 6> 7> 8> 9> 10> 11> 12> 13> 14> 15> 16> 17> 18> 19> 20> 21>
22> 23> 24> 25> 26> 27> 28> 29> 30> 31> 32> 33> 34> 35> 36> 37> 38> 39> 40>
41> 42> 43> 44> 45> 46> 47> 48> 49> 50> 51> 52> 53> 54> 55> 56> 57> 58> 59>
60> 61> 62> 63> 64> 65> 66> 67> 68> 69> 70> 71> 72> 73> 74> 75> 76> 77> 78>
79> 80> 81> 82> 83> 84> 85> 1> 2> 3> Creating 'sp_MSenum_distribution'.
1> 2> 3> 4> 5> 6> 7> 8> 9> 10> 11> 12> 13> 14> 15> 16> 17> 18> 19> 20> 21>
22> 23> 24> 25> 26> 27> 28> 29> 30> 31> 32> 33> 34> 35> 36> 37> 38> 39> 40>
41> 42> 43> 44> 45> 46> 47> 48> 49> 50> 51> 52> 53> 54> 55> 56> 57> 58> 59>
60> 61> 62> 63> 64> 65> 66> 67> 68> 69> 70> 71> 72> 73> 74> 75> 76> 77> 78>
79> 80> 81> 82> 83> 84> 85> 86> 87> 88> 89> 90> 91> 92> 93> 94> 95> 96> 97>
98> 99> 100> 101> 102> 103> 104> 105> 106> 107> 108> 109> 110> 111> 112>
113> 114> 115> 116> 117> 118> 119> 120> 121> 122> 123> 124> 125> 126> 127>
128> 129> 130> 131> 132> 133> 134> 135> 136> 137> 138> 139> 1> 2> 3> 4>
Creating 'sp_MSenum_distribution_s'.
1> 2> 3> 4> 5> 6> 7> 8> 9> 10> 11> 12> 13> 14> 15> 16> 17> 18> 19> 20> 21>
22> 23> 24> 25> 26> 27> 28> 29> 30> 31> 32> 33> 34> 35> 36> 37> 38> 39> 40>
41> 42> 43> 44> 45> 46> 47> 48> 49> 50> 51> 52> 53> 54> 55> 56> 57> 58> 59>
60> 61> 62> 63> 64> 65> 66> 67> 68> 69> 70> 71> 72> 73> 74> 75> 76> 77> 78>
79> 80> 81> 82> 83> 84> 85> 86> 87> 88> 1> 2> 3> 4> Creating
'sp_MSenum_distribution_sd'.
1> 2> 3> 4> 5> 6> 7> 8> 9> 10> 11> 12> 13> 14> 15> 16> 17> 18> 19> 20> 21>
22> 23> 24> 25> 26> 27> 28> 29> 30> 31> 32> 33> 34> 35> 36> 37> 38> 39> 40>
41> 42> 43> 44> 45> 46> 47> 48> 49> 50> 51> 52> 1> 2> 3> 4> Creating
'sp_MSadd_merge_history'.
1> 2> 3> 4> 5> 6> 7> 8> 9> 10> 11> 12> 13> 14> 15> 16> 17> 18> 19> 20> 21>
22> 23> 24> 25> 26> 27> 28> 29> 30> 31> 32> 33> 34> 35> 36> 37> 38> 39> 40>
41> 42> 43> 44> 45> 46> 47> 48> 49> 50> 51> 52> 53> 54> 55> 56> 57> 58> 59>
60> 61> 62> 63> 64> 65> 66> 67> 68> 69> 70> 71> 72> 73> 74> 75> 76> 77> 78>
79> 80> 81> 82> 83> 84> 85> 86> 87> 88> 89> 90> 91> 92> 93> 94> 95> 96> 97>
98> 99> 100> 101> 102> 103> 104> 105> 106> 107> 108> 109> 110> 111> 112>
113> 114> 115> 116> 117> 118> 119> 120> 121> 122> 123> 124> 125> 126> 127>
128> 129> 130> 131> 132> 133> 134> 135> 136> 137> 138> 139> 140> 141> 142>
143> 144> 145> 146> 147> 148> 149> 150> 151> 152> 153> 154> 155> 156> 157>
158> 159> 160> 161> 162> 163> 164> 165> 166> 167> 168> 169> 170> 171> 172>
173> 174> 175> 176> 177> 178> 179> 180> 181> 182> 183> 184> 185> 186> 187>
188> 189> 190> 191> 192> 193> 194> 195> 196> 197> 198> 199> 200> 201> 202>
203> 204> 205> 206> 207> 208> 209> 210> 211> 212> 213> 214> 215> 216> 217>
218> 219> 220> 221> 222> 223> 224> 225> 226> 227> 228> 229> 230> 231> 232>
233> 234> 235> 236> 237> 238> 239> 240> 241> 242> 243> 244> 245> 246> 247>
248> 249> 250> 251> 252> 253> 254> 255> 256> 257> 258> 259> 260> 261> 262>
263> 264> 265> 266> 267> 268> 269> 270> 271> 272> 273> 274> 275> 276> 277>
278> 279> 280> 281> 282> 283> 284> 285> 286> 287> 288> 289> 290> 291> 292>
293> 294> 295> 296> 297> 298> 299> 300> 301> 302> 303> 304> 305> 306> 307>
308> 309> 310> 311> 1> 2> 3> Creating 'sp_MSenum_merge'.
1> 2> 3> 4> 5> 6> 7> 8> 9> 10> 11> 12> 13> 14> 15> 16> 17> 18> 19> 20> 21>
22> 23> 24> 25> 26> 27> 28> 29> 30> 31> 32> 33> 34> 35> 36> 37> 38> 39> 40>
41> 42> 43> 44> 45> 46> 47> 48> 49> 50> 51> 52> 53> 54> 55> 56> 57> 58> 59>
60> 61> 62> 63> 64> 65> 66> 67> 68> 69> 70> 71> 72> 73> 74> 75> 76> 77> 78>
79> 80> 81> 82> 83> 84> 85> 86> 87> 88> 89> 90> 91> 92> 93> 94> 95> 96> 97>
98> 99> 100> 101> 102> 103> 104> 105> 106> 107> 108> 109> 110> 111> 112>
113> 114> 115> 116> 117> 118> 119> 120> 121> 122> 123> 124> 125> 126> 127>
128> 129> 130> 131> 132> 133> 134> 135> 136> 137> 138> 139> 140> 141> 142>
143> 144> 145> 146> 147> 148> 149> 150> 151> 152> 153> 154> 155> 156> 157>
158> 159> 160> 161> 162> 163> 164> 165> 166> 167> 168> 169> 170> 1> 2> 3> 4>
Creating 'sp_MSenum_merge_s'.
1> 2> 3> 4> 5> 6> 7> 8> 9> 10> 11> 12> 13> 14> 15> 16> 17> 18> 19> 20> 21>
22> 23> 24> 25> 26> 27> 28> 29> 30> 31> 32> 33> 34> 35> 36> 37> 38> 39> 40>
41> 42> 43> 44> 45> 46> 47> 48> 49> 50> 51> 52> 53> 54> 55> 56> 57> 58> 59>
60> 61> 62> 63> 64> 65> 66> 67> 68> 69> 70> 71> 72> 73> 74> 75> 76> 77> 78>
79> 80> 81> 82> 83> 84> 85> 86> 87> 88> 89> 90> 91> 92> 93> 94> 95> 96> 97>
1> 2> 3> Creating 'sp_MSenum_merge_sd'.
1> 2> 3> 4> 5> 6> 7> 8> 9> 10> 11> 12> 13> 14> 15> 16> 17> 18> 19> 20> 21>
22> 23> 24> 25> 26> 27> 28> 29> 30> 31> 32> 33> 34> 35> 36> 37> 38> 39> 40>
41> 42> 43> 44> 45> 46> 47> 48> 49> 50> 51> 52> 53> 54> 55> 56> 57> 1> 2> 3>
Creating 'sp_MSenableagentoffload'.
1> 2> 3> 4> 5> 6> 7> 8> 9> 10> 11> 12> 13> 14> 15> 16> 17> 18> 19> 20> 21>
22> 23> 24> 25> 26> 27> 28> 29> 30> 31> 32> 33> 34> 35> 36> 37> 38> 39> 40>
41> 42> 43> 44> 45> 46> 47> 48> 49> 50> 51> 52> 53> 54> 55> 56> 57> 58> 59>
60> 61> 62> 63> 64> 65> 66> 67> 68> 69> 70> 71> 72> 73> 74> 75> 76> 77> 78>
79> 80> 81> 82> 83> 84> 85> 86> 87> 88> 89> 90> 91> 92> 93> 94> 95> 96> 97>
98> 99> 100> 101> 102> 103> 104> 105> 106> 107> 108> 109> 110> 111> 112>
113> 114> 115> 116> 117> 118> 119> 120> 121> 122> 123> 124> 125> 126> 127>
128> 129> 130> 131> 132> 133> 134> 135> 136> 137> 138> 139> 140> 141> 142>
143> 144> 145> 146> 147> 148> 149> 150> 151> 152> 153> 154> 155> 156> 157>
158> 159> 160> 161> 162> 163> 164> 165> 166> 167> 168> 169> 170> 171> 172>
173> 174> 175> 176> 177> 178> 179> 180> 181> 182> 183> 184> 185> 186> 187>
188> 189> 190> 191> 192> 193> 194> 195> 196> 197> 1> 2> 3> Creating
'sp_MSdisableagentoffload'.
1> 2> 3> 4> 5> 6> 7> 8> 9> 10> 11> 12> 13> 14> 15> 16> 17> 18> 19> 20> 21>
22> 23> 24> 25> 26> 27> 28> 29> 30> 31> 32> 33> 34> 35> 36> 37> 38> 39> 40>
41> 42> 43> 44> 45> 46> 47> 48> 49> 50> 51> 52> 53> 54> 55> 56> 57> 58> 59>
60> 61> 62> 63> 64> 65> 66> 67> 68> 69> 70> 71> 72> 73> 74> 75> 76> 77> 78>
79> 80> 81> 82> 83> 84> 85> 86> 87> 88> 89> 1> 2> 3> Creating
'sp_MSadd_repl_error'.
1> 2> 3> 4> 5> 6> 7> 8> 9> 10> 11> 12> 13> 14> 15> 16> 17> 18> 19> 20> 21>
22> 23> 24> 25> 26> 27> 28> 29> 30> 31> 32> 33> 34> 35> 1> 2> 3> 4> Creating
'sp_MSadd_repl_alert'.
1> 2> 3> 4> 5> 6> 7> 8> 9> 10> 11> 12> 13> 14> 15> 16> 17> 18> 19> 20> 21>
22> 23> 24> 25> 26> 27> 28> 29> 30> 31> 32> 33> 34> 35> 36> 37> 38> 39> 40>
41> 42> 43> 44> 45> 46> 47> 48> 49> 50> 51> 52> 53> 54> 55> 56> 57> 58> 59>
60> 61> 62> 63> 64> 65> 66> 67> 68> 69> 70> 71> 72> 73> 74> 75> 76> 77> 78>
79> 80> 81> 82> 83> 84> 85> 86> 87> 88> 89> 90> 91> 92> 93> 94> 95> 96> 1>
2> 3> Creating 'sp_MSadd_replmergealert'.
1> 2> 3> 4> 5> 6> 7> 8> 9> 10> 11> 12> 13> 14> 15> 16> 17> 18> 19> 20> 21>
22> 23> 24> 25> 26> 27> 28> 29> 30> 31> 32> 33> 34> 1> 2> 3> 4> Creating
'sp_MSget_repl_error'.
1> 2> 3> 4> 5> 6> 7> 8> 9> 10> 11> 12> 13> 14> 15> 16> 17> 18> 19> 20> 1> 2>
3> 4> Creating 'sp_MSdist_activate_auto_sub'.
1> 2> 3> 4> 5> 6> 7> 8> 9> 10> 11> 12> 13> 14> 15> 16> 17> 18> 19> 20> 21>
22> 23> 24> 25> 26> 27> 28> 29> 30> 31> 32> 33> 34> 35> 36> 37> 38> 39> 1>
2> 3> Creating 'sp_MSlock_auto_sub'.
1> 2> 3> 4> 5> 6> 7> 8> 9> 10> 11> 12> 13> 14> 15> 16> 17> 18> 19> 20> 21>
22> 23> 24> 25> 26> 27> 28> 29> 30> 31> 32> 33> 34> 35> 36> 37> 38> 39> 40>
41> 42> 43> 44> 45> 46> 47> 48> 49> 50> 51> 52> 53> 54> 55> 56> 57> 58> 59>
1> 2> 3> Creating 'sp_MSget_new_xact_seqno'.
1> 2> 3> 4> 5> 6> 7> 8> 9> 10> 11> 12> 13> 14> 15> 16> 17> 18> 19> 20> 21>
22> 23> 24> 25> 26> 27> 28> 29> 30> 31> 32> 33> 34> 35> 36> 37> 38> 39> 40>
41> 42> 43> 44> 45> 46> 47> 48> 49> 50> 51> 52> 53> 54> 55> 56> 57> 58> 59>
60> 61> 62> 63> 64> 65> 66> 67> 68> 69> 70> 71> 72> 73> 74> 75> 76> 77> 78>
79> 80> 81> 82> 83> 84> 85> 1> 2> 3> 4> 5> Creating
'sp_MSchange_publication'.
1> 2> 3> 4> 5> 6> 7> 8> 9> 10> 11> 12> 13> 14> 15> 16> 17> 18> 19> 20> 21>
22> 23> 24> 25> 26> 27> 28> 29> 30> 31> 32> 33> 34> 35> 36> 37> 38> 39> 40>
41> 42> 43> 44> 45> 46> 47> 48> 49> 50> 51> 52> 53> 54> 55> 56> 57> 58> 59>
60> 61> 62> 63> 64> 65> 66> 67> 68> 69> 70> 71> 72> 73> 74> 75> 76> 77> 78>
79> 80> 81> 82> 83> 84> 85> 86> 87> 88> 89> 90> 91> 92> 93> 94> 95> 96> 97>
98> 99> 100> 101> 102> 103> 104> 105> 106> 107> 108> 109> 110> 111> 112>
113> 114> 115> 116> 117> 118> 119> 120> 121> 122> 123> 124> 125> 126> 127>
128> 129> 130> 131> 132> 133> 134> 135> 136> 137> 138> 139> 140> 141> 142>
143> 144> 145> 146> 147> 148> 149> 150> 151> 152> 153> 154> 155> 156> 157>
158> 159> 160> 161> 162> 163> 164> 165> 166> 167> 168> 169> 170> 171> 172>
173> 174> 175> 176> 177> 178> 179> 180> 181> 182> 183> 184> 185> 186> 187>
188> 189> 190> 191> 192> 193> 194> 195> 196> 197> 198> 1> 2> 3> 4> Creating
'sp_MSadd_article'.
1> 2> 3> 4> 5> 6> 7> 8> 9> 10> 11> 12> 13> 14> 15> 16> 17> 18> 19> 20> 21>
22> 23> 24> 25> 26> 27> 28> 29> 30> 31> 32> 33> 34> 35> 36> 37> 38> 39> 40>
41> 42> 43> 44> 45> 46> 47> 48> 49> 50> 51> 52> 53> 54> 55> 56> 57> 58> 59>
60> 61> 62> 63> 64> 65> 66> 67> 68> 69> 70> 71> 72> 73> 74> 75> 76> 77> 78>
79> 80> 81> 82> 83> 84> 85> 86> 87> 88> 89> 90> 91> 92> 93> 94> 95> 96> 97>
98> 99> 100> 101> 102> 103> 104> 105> 106> 107> 108> 109> 110> 111> 112>
113> 114> 115> 116> 117> 118> 119> 120> 121> 122> 123> 124> 125> 126> 127>
128> 129> 130> 131> 132> 133> 134> 135> 136> 137> 138> 139> 140> 141> 142>
143> 144> 145> 146> 147> 148> 149> 150> 151> 152> 153> 154> 155> 156> 157>
158> 159> 160> 161> 162> 163> 164> 165> 166> 167> 168> 169> 170> 171> 172>
173> 174> 175> 176> 177> 178> 179> 180> 181> 182> 183> 184> 185> 186> 187>
188> 189> 190> 191> 192> 193> 194> 195> 196> 197> 198> 199> 200> 201> 202>
203> 204> 205> 206> 207> 208> 209> 210> 211> 212> 213> 214> 215> 216> 217>
218> 219> 1> 2> 3> Creating 'sp_MSchange_article'.
1> 2> 3> 4> 5> 6> 7> 8> 9> 10> 11> 12> 13> 14> 15> 16> 17> 18> 19> 20> 21>
22> 23> 24> 25> 26> 27> 28> 29> 30> 31> 32> 33> 34> 35> 36> 37> 38> 39> 40>
41> 42> 43> 44> 45> 46> 47> 48> 49> 50> 51> 52> 53> 54> 55> 56> 57> 58> 59>
60> 61> 62> 63> 64> 65> 66> 67> 68> 69> 70> 71> 72> 73> 74> 75> 76> 77> 78>
79> 80> 81> 82> 83> 84> 85> 86> 87> 88> 89> 90> 91> 92> 93> 94> 95> 96> 97>
98> 99> 100> 101> 102> 103> 104> 105> 106> 107> 108> 109> 1> 2> 3> 4>
Creating 'sp_MShelp_publication'.
1> 2> 3> 4> 5> 6> 7> 8> 9> 10> 11> 12> 13> 14> 15> 16> 17> 18> 19> 20> 21>
22> 23> 24> 25> 26> 27> 28> 29> 30> 31> 32> 33> 34> 35> 36> 37> 38> 39> 40>
41> 42> 43> 44> 45> 46> 47> 48> 49> 50> 51> 52> 53> 54> 55> 56> 57> 58> 59>
60> 61> 62> 63> 64> 65> 66> 67> 68> 69> 70> 71> 72> 73> 74> 75> 76> 77> 78>
79> 80> 81> 82> 83> 84> 85> 86> 87> 88> 1> 2> 3> Creating
'sp_MShelp_article'.
1> 2> 3> 4> 5> 6> 7> 8> 9> 10> 11> 12> 13> 14> 15> 16> 17> 18> 1> 2> 3>
Creating 'sp_MShelp_subscription'.
1> 2> 3> 4> 5> 6> 7> 8> 9> 10> 11> 12> 13> 14> 15> 16> 17> 18> 19> 20> 21>
22> 23> 24> 1> 2> 3> Creating 'sp_MSadd_subscription_3rd'.
1> 2> 3> 4> 5> 6> 7> 8> 9> 10> 11> 12> 13> 14> 15> 16> 17> 18> 19> 20> 21>
22> 23> 24> 25> 26> 27> 28> 29> 30> 31> 32> 33> 34> 35> 36> 37> 38> 39> 40>
41> 42> 43> 44> 45> 46> 47> 48> 49> 50> 51> 52> 53> 54> 55> 56> 57> 58> 59>
60> 61> 62> 63> 64> 65> 66> 67> 68> 69> 70> 71> 72> 73> 74> 75> 76> 77> 78>
79> 80> 81> 82> 83> 84> 85> 86> 87> 88> 89> 90> 91> 92> 93> 94> 95> 96> 97>
98> 99> 100> 101> 102> 103> 104> 105> 106> 107> 108> 109> 110> 111> 112>
113> 114> 115> 116> 117> 118> 119> 120> 121> 122> 123> 124> 125> 126> 127>
128> 129> 130> 131> 132> 133> 134> 135> 136> 137> 138> 139> 140> 141> 142>
143> 144> 145> 146> 147> 148> 149> 150> 151> 152> 153> 154> 155> 156> 157>
158> 1> 2> 3> Creating 'sp_MSdrop_subscription_3rd'.
1> 2> 3> 4> 5> 6> 7> 8> 9> 10> 11> 12> 13> 14> 15> 16> 17> 18> 19> 20> 21>
22> 23> 24> 25> 26> 27> 28> 29> 30> 31> 32> 33> 34> 35> 36> 37> 38> 39> 40>
41> 42> 43> 44> 45> 46> 47> 48> 49> 50> 51> 52> 53> 54> 55> 56> 57> 58> 59>
60> 61> 62> 63> 64> 65> 66> 67> 68> 69> 70> 71> 72> 73> 74> 75> 76> 77> 78>
79> 80> 81> 82> 83> 84> 85> 86> 87> 88> 89> 90> 91> 92> 93> 94> 95> 96> 97>
98> 99> 100> 101> 102> 103> 104> 105> 1> 2> 3> Creating
'sp_MSactivate_subscriptions'.
1> 2> 3> 4> 5> 6> 7> 8> 9> 10> 11> 12> 13> 14> 15> 16> 17> 18> 19> 20> 21>
22> 23> 24> 25> 26> 27> 28> 29> 30> 31> 32> 33> 34> 35> 36> 37> 38> 39> 40>
41> 42> 43> 44> 45> 46> 47> 48> 49> 50> 51> 52> 53> 54> 55> 56> 57> 1> 2>
Creating 'sp_MSdrop_merge_subscription'.
1> 2> 3> 4> 5> 6> 7> 8> 9> 10> 11> 12> 13> 14> 15> 16> 17> 18> 19> 20> 21>
22> 23> 24> 25> 26> 27> 28> 29> 30> 31> 32> 33> 34> 35> 36> 37> 38> 39> 40>
41> 42> 43> 44> 45> 46> 47> 48> 49> 50> 51> 52> 53> 54> 55> 56> 57> 58> 59>
60> 61> 62> 63> 64> 65> 66> 67> 68> 69> 70> 71> 72> 73> 74> 75> 76> 77> 78>
79> 80> 81> 82> 83> 84> 85> 86> 87> 88> 89> 90> 91> 92> 93> 94> 95> 96> 97>
98> 99> 100> 101> 102> 103> 104> 105> 106> 107> 108> 109> 110> 111> 112>
113> 114> 115> 116> 117> 118> 119> 120> 121> 122> 123> 124> 125> 126> 127>
128> 129> 130> 131> 132> 133> 134> 135> 136> 137> 138> 139> 140> 141> 142>
1> 2> 3> Creating 'sp_MSadd_merge_subscription'.
1> 2> 3> 4> 5> 6> 7> 8> 9> 10> 11> 12> 13> 14> 15> 16> 17> 18> 19> 20> 21>
22> 23> 24> 25> 26> 27> 28> 29> 30> 31> 32> 33> 34> 35> 36> 37> 38> 39> 40>
41> 42> 43> 44> 45> 46> 47> 48> 49> 50> 51> 52> 53> 54> 55> 56> 57> 58> 59>
60> 61> 62> 63> 64> 65> 66> 67> 68> 69> 70> 71> 72> 73> 74> 75> 76> 77> 78>
79> 80> 81> 82> 83> 84> 85> 86> 87> 88> 89> 90> 91> 92> 93> 94> 95> 96> 97>
98> 99> 100> 101> 102> 103> 104> 105> 106> 107> 108> 109> 110> 111> 112>
113> 114> 115> 116> 117> 118> 119> 120> 121> 122> 123> 124> 125> 126> 127>
128> 129> 130> 131> 132> 133> 134> 135> 136> 137> 138> 139> 140> 141> 142>
143> 144> 145> 146> 147> 148> 149> 150> 151> 152> 153> 154> 155> 156> 157>
158> 159> 160> 161> 162> 163> 164> 165> 166> 167> 168> 169> 170> 171> 172>
173> 174> 175> 176> 177> 178> 179> 180> 181> 182> 183> 184> 185> 186> 187>
188> 189> 190> 191> 192> 193> 194> 195> 196> 197> 198> 199> 200> 201> 202>
203> 204> 205> 206> 207> 208> 209> 210> 211> 212> 213> 214> 215> 216> 217>
218> 1> 2> 3> Creating 'sp_MSenum_merge_subscriptions'.
1> 2> 3> 4> 5> 6> 7> 8> 9> 10> 11> 12> 13> 14> 15> 16> 17> 18> 19> 20> 21>
22> 23> 24> 25> 26> 27> 28> 29> 30> 31> 32> 33> 34> 35> 36> 37> 38> 39> 40>
41> 42> 43> 44> 45> 46> 47> 48> 49> 50> 51> 52> 53> 54> 55> 56> 57> 58> 59>
60> 61> 62> 63> 64> 65> 66> 67> 68> 69> 70> 71> 72> 73> 74> 75> 76> 77> 78>
79> 80> 81> 82> 83> 84> 85> 86> 87> 88> 89> 90> 91> 92> 93> 94> 95> 96> 97>
98> 99> 100> 101> 102> 103> 104> 105> 106> 107> 108> 109> 110> 111> 112>
113> 114> 115> 116> 117> 118> 119> 120> 121> 122> 123> 124> 125> 126> 127>
128> 129> 130> 131> 132> 133> 134> 135> 136> 137> 138> 139> 140> 141> 142>
143> 144> 145> 146> 147> 148> 149> 150> 151> 152> 153> 154> 155> 156> 157>
158> 159> 160> 161> 162> 163> 164> 165> 166> 167> 168> 169> 170> 171> 172>
173> 174> 1> 2> 3> Creating 'sp_update_agent_profile'.
1> 2> 3> 4> 5> 6> 7> 8> 9> 10> 11> 12> 13> 14> 15> 16> 17> 18> 19> 20> 21>
22> 23> 24> 25> 26> 27> 28> 29> 30> 31> 32> 33> 34> 35> 36> 37> 38> 39> 40>
41> 42> 43> 44> 45> 46> 47> 48> 49> 50> 51> 52> 53> 54> 55> 56> 57> 58> 59>
60> 61> 62> 63> 64> 65> 66> 67> 68> 69> 70> 1> 2> 3> 4> Creating
'sp_MSprofile_in_use'.
1> 2> 3> 4> 5> 6> 7> 8> 9> 10> 11> 12> 13> 14> 15> 16> 17> 18> 19> 20> 21>
22> 23> 24> 25> 26> 27> 28> 29> 30> 31> 1> 2> 3> 4> Creating
'sp_MSreset_subscription'.
1> 2> 3> 4> 5> 6> 7> 8> 9> 10> 11> 12> 13> 14> 15> 16> 17> 18> 19> 20> 21>
22> 23> 24> 25> 26> 27> 28> 29> 30> 31> 32> 33> 34> 35> 36> 37> 38> 39> 40>
41> 42> 43> 44> 45> 46> 47> 48> 49> 50> 51> 52> 53> 54> 55> 56> 57> 58> 59>
60> 61> 62> 63> 64> 65> 66> 67> 68> 69> 70> 71> 72> 73> 74> 75> 76> 1> 2> 3>
Creating 'sp_MSget_subscription_guid'.
1> 2> 3> 4> 5> 6> 7> 8> 9> 10> 11> 12> 13> 14> 15> 16> 17> 18> 19> 20> 1> 2>
3> 4> Creating 'sp_MSreset_subscription_seqno'.
1> 2> 3> 4> 5> 6> 7> 8> 9> 10> 11> 12> 13> 14> 15> 16> 17> 18> 19> 20> 21>
22> 23> 24> 25> 26> 27> 28> 29> 30> 31> 32> 33> 34> 35> 36> 37> 38> 39> 40>
41> 42> 43> 44> 45> 46> 47> 48> 49> 50> 51> 52> 53> 54> 55> 56> 57> 58> 59>
60> 61> 62> 63> 64> 65> 66> 67> 68> 69> 70> 71> 72> 73> 74> 75> 76> 77> 78>
79> 80> 81> 82> 83> 84> 85> 86> 87> 88> 89> 90> 91> 92> 93> 94> 95> 96> 97>
98> 99> 100> 101> 102> 103> 104> 105> 106> 107> 108> 109> 110> 111> 1> 2> 3>
4> Creating 'sp_MShelp_profile'.
1> 2> 3> 4> 5> 6> 7> 8> 9> 10> 11> 12> 13> 14> 15> 16> 17> 18> 19> 20> 21>
22> 23> 24> 25> 26> 27> 28> 29> 30> 31> 32> 33> 34> 35> 36> 37> 38> 39> 40>
41> 42> 43> 44> 45> 46> 47> 48> 49> 50> 51> 52> 53> 54> 55> 56> 57> 58> 59>
60> 61> 62> 63> 64> 65> 66> 67> 68> 69> 70> 71> 72> 73> 74> 75> 76> 77> 78>
79> 80> 81> 82> 83> 84> 85> 86> 87> 88> 89> 1> 2> 3> Creating
'sp_MShelp_snapshot_agentid'.
1> 2> 3> 4> 5> 6> 7> 8> 9> 10> 11> 12> 13> 14> 15> 16> 17> 18> 19> 20> 21>
22> 23> 24> 25> 26> 27> 28> 29> 30> 31> 32> 33> 34> 35> 36> 37> 38> 39> 40>
41> 42> 43> 44> 45> 46> 47> 48> 49> 50> 51> 52> 53> 54> 55> 56> 57> 58> 59>
60> 61> 62> 63> 64> 65> 1> 2> 3> Creating 'sp_MShelp_logreader_agentid'.
1> 2> 3> 4> 5> 6> 7> 8> 9> 10> 11> 12> 13> 14> 15> 16> 17> 18> 19> 20> 21>
22> 23> 24> 25> 26> 27> 28> 29> 30> 31> 32> 33> 34> 35> 36> 37> 38> 39> 40>
41> 42> 43> 44> 45> 46> 47> 48> 49> 50> 51> 52> 53> 54> 55> 56> 57> 58> 59>
60> 61> 62> 63> 64> 65> 66> 67> 1> 2> 3> 4> 5> 6> 7> 8> Creating
'sp_MSadd_merge_anonymous_agent'.
1> 2> 3> 4> 5> 6> 7> 8> 9> 10> 11> 12> 13> 14> 15> 16> 17> 18> 19> 20> 21>
22> 23> 24> 25> 26> 27> 28> 29> 30> 31> 32> 33> 34> 35> 36> 37> 38> 39> 40>
41> 42> 43> 44> 45> 46> 47> 48> 49> 50> 51> 52> 53> 54> 55> 56> 57> 58> 59>
60> 61> 62> 63> 64> 65> 66> 67> 68> 69> 70> 71> 72> 73> 74> 75> 76> 77> 78>
79> 80> 81> 82> 83> 84> 85> 86> 87> 88> 89> 90> 91> 92> 93> 94> 95> 96> 97>
98> 99> 100> 101> 102> 103> 104> 105> 106> 107> 108> 109> 110> 111> 112>
113> 114> 115> 116> 117> 118> 119> 120> 121> 122> 123> 124> 125> 126> 127>
128> 129> 130> 131> 132> 133> 134> 135> 136> 137> 138> 139> 140> 141> 142>
143> 144> 1> 2> 3> 4> Creating 'sp_MShelp_merge_agentid'.
1> 2> 3> 4> 5> 6> 7> 8> 9> 10> 11> 12> 13> 14> 15> 16> 17> 18> 19> 20> 21>
22> 23> 24> 25> 26> 27> 28> 29> 30> 31> 32> 33> 34> 35> 36> 37> 38> 39> 40>
41> 42> 43> 44> 45> 46> 47> 48> 49> 50> 51> 52> 53> 54> 55> 56> 57> 58> 59>
60> 61> 62> 63> 64> 65> 66> 67> 68> 69> 70> 71> 72> 73> 74> 75> 76> 77> 78>
79> 80> 81> 82> 83> 84> 85> 86> 87> 88> 89> 90> 91> 92> 93> 94> 95> 96> 97>
98> 99> 100> 101> 102> 103> 104> 105> 106> 107> 108> 109> 110> 111> 1> 2> 3>
Creating 'sp_MSdistpublisher_cleanup'.
1> 2> 3> 4> 5> 6> 7> 8> 9> 10> 11> 12> 13> 14> 15> 16> 17> 18> 19> 20> 21>
22> 23> 24> 25> 26> 27> 28> 29> 30> 31> 32> 33> 34> 35> 36> 37> 38> 39> 40>
41> 42> 43> 44> 45> 46> 47> 48> 49> 50> 51> 52> 53> 54> 55> 56> 57> 58> 59>
60> 61> 62> 63> 64> 65> 66> 67> 68> 69> 70> 71> 72> 73> 74> 75> 76> 77> 78>
79> 80> 81> 82> 83> 84> 85> 86> 87> 88> 89> 90> 91> 92> 93> 94> 95> 96> 97>
98> 99> 100> 101> 102> 103> 104> 105> 106> 107> 108> 109> 110> 111> 112>
113> 114> 115> 116> 117> 118> 119> 120> 121> 1> 2> 3> Creating
'sp_MSenum_replication_status'.
1> 2> 3> 4> 5> 6> 7> 8> 9> 10> 11> 12> 13> 14> 15> 16> 17> 18> 19> 20> 21>
22> 23> 24> 25> 26> 27> 28> 29> 30> 31> 32> 33> 34> 35> 36> 37> 38> 39> 40>
41> 42> 43> 44> 45> 46> 47> 48> 49> 50> 51> 52> 53> 54> 55> 56> 57> 58> 59>
60> 61> 62> 63> 64> 65> 66> 67> 68> 69> 70> 71> 72> 73> 74> 75> 76> 77> 78>
79> 80> 81> 82> 83> 84> 85> 86> 87> 88> 89> 90> 91> 92> 93> 94> 95> 96> 97>
98> 99> 100> 101> 102> 103> 104> 105> 106> 107> 108> 109> 110> 111> 112>
113> 114> 115> 116> 117> 118> 119> 120> 121> 122> 123> 124> 125> 126> 127>
128> 129> 130> 131> 132> 133> 134> 135> 136> 137> 138> 139> 140> 141> 142>
143> 144> 145> 146> 147> 148> 149> 150> 151> 152> 153> 154> 1> 2> 3>
Creating 'sp_MSagent_stethoscope'.
1> 2> 3> 4> 5> 6> 7> 8> 9> 10> 11> 12> 13> 14> 15> 16> 17> 18> 19> 20> 21>
22> 23> 24> 25> 26> 27> 28> 29> 30> 31> 32> 33> 34> 35> 36> 37> 38> 39> 40>
41> 42> 43> 44> 45> 46> 47> 48> 49> 50> 51> 52> 53> 54> 55> 56> 57> 58> 59>
60> 61> 62> 63> 64> 65> 66> 67> 68> 69> 70> 71> 72> 73> 74> 75> 76> 77> 78>
79> 80> 81> 82> 83> 84> 85> 86> 87> 88> 89> 90> 91> 92> 93> 94> 95> 96> 97>
98> 99> 100> 101> 102> 103> 104> 105> 106> 107> 108> 109> 110> 111> 112>
113> 114> 115> 116> 117> 118> 119> 120> 121> 122> 123> 124> 125> 126> 127>
128> 129> 130> 131> 132> 133> 134> 135> 136> 137> 138> 139> 140> 141> 142>
143> 144> 145> 146> 147> 148> 149> 150> 151> 152> 153> 154> 155> 156> 157>
158> 159> 160> 161> 162> 163> 164> 165> 166> 167> 168> 169> 170> 171> 172>
173> 174> 175> 176> 177> 178> 179> 180> 181> 182> 183> 184> 185> 186> 187>
188> 189> 190> 191> 192> 193> 194> 195> 196> 197> 198> 199> 200> 201> 202>
203> 204> 205> 1> 2> 3> Creating 'sp_MSlock_distribution_agent'.
1> 2> 3> 4> 5> 6> 7> 8> 9> 10> 11> 12> 13> 14> 15> 16> 1> 2> 3> Creating
'sp_MSdetect_nonlogged_shutdown'.
1> 2> 3> 4> 5> 6> 7> 8> 9> 10> 11> 12> 13> 14> 15> 16> 17> 18> 19> 20> 21>
22> 23> 24> 25> 26> 27> 28> 29> 30> 31> 32> 33> 34> 35> 36> 37> 38> 39> 40>
41> 42> 43> 44> 45> 46> 47> 48> 49> 50> 51> 52> 53> 54> 55> 56> 57> 58> 59>
60> 61> 62> 63> 64> 65> 66> 67> 68> 69> 70> 71> 72> 73> 74> 75> 76> 77> 78>
79> 80> 81> 82> 83> 84> 85> 86> 87> 88> 89> 90> 91> 92> 93> 94> 95> 96> 97>
98> 99> 100> 101> 102> 103> 104> 105> 106> 107> 108> 109> 110> 111> 112>
113> 114> 115> 116> 117> 118> 119> 120> 121> 122> 123> 124> 125> 126> 127>
128> 129> 130> 131> 132> 133> 134> 135> 136> 137> 138> 139> 140> 141> 142>
143> 144> 145> 146> 147> 148> 149> 150> 151> 152> 153> 154> 1> 2> 3>
Creating 'sp_MSenumerate_PAL'.
1> 2> 3> 4> 5> 6> 7> 8> 9> 10> 11> 12> 13> 14> 15> 16> 17> 18> 19> 20> 21>
22> 23> 24> 25> 26> 27> 28> 29> 30> 31> 1> 2> 3> 4> 5> Creating
'sp_MSpublication_access'.
1> 2> 3> 4> 5> 6> 7> 8> 9> 10> 11> 12> 13> 14> 15> 16> 17> 18> 19> 20> 21>
22> 23> 24> 25> 26> 27> 28> 29> 30> 31> 32> 33> 34> 35> 36> 37> 38> 39> 40>
41> 42> 43> 44> 45> 46> 47> 48> 49> 50> 51> 52> 53> 54> 55> 56> 57> 58> 59>
60> 61> 62> 63> 64> 65> 66> 67> 68> 69> 70> 71> 72> 73> 74> 75> 76> 77> 78>
79> 80> 81> 82> 83> 84> 85> 86> 87> 88> 89> 90> 91> 92> 93> 94> 95> 96> 97>
98> 99> 100> 101> 102> 103> 104> 105> 106> 107> 108> 109> 110> 111> 112>
113> 114> 115> 116> 117> 118> 119> 120> 121> 122> 123> 124> 125> 126> 127>
128> 129> 130> 131> 132> 133> 134> 135> 136> 137> 138> 139> 140> 141> 142>
143> 144> 145> 146> 147> 148> 149> 150> 151> 152> 153> 154> 155> 156> 157>
158> 159> 160> 161> 162> 163> 164> 165> 166> 167> 168> 169> 170> 171> 172>
173> 174> 175> 176> 177> 178> 179> 180> 181> 182> 183> 184> 185> 186> 187>
188> 189> 1> 2> 3> 4> Creating 'sp_MSdrop_6x_publication'.
1> 2> 3> 4> 5> 6> 7> 8> 9> 10> 11> 12> 13> 14> 15> 16> 17> 18> 19> 20> 21>
22> 23> 24> 1> 2> 3> Creating 'sp_MShelp_distribution_agentid'.
1> 2> 3> 4> 5> 6> 7> 8> 9> 10> 11> 12> 13> 14> 15> 16> 17> 18> 19> 20> 21>
22> 23> 24> 25> 26> 27> 28> 29> 30> 31> 32> 33> 34> 35> 36> 37> 38> 39> 40>
41> 42> 43> 44> 45> 46> 47> 48> 49> 50> 51> 52> 53> 54> 55> 56> 57> 58> 59>
60> 61> 62> 63> 64> 65> 66> 67> 68> 69> 70> 71> 72> 73> 74> 75> 76> 77> 78>
79> 80> 81> 82> 83> 84> 85> 86> 87> 88> 89> 90> 91> 92> 93> 94> 95> 96> 97>
98> 99> 100> 101> 102> 103> 104> 105> 106> 107> 108> 109> 110> 111> 112>
113> 114> 115> 116> 117> 118> 119> 120> 121> 122> 123> 124> 125> 126> 127>
128> 129> 130> 131> 132> 133> 134> 135> 136> 137> 138> 139> 140> 141> 142>
143> 144> 145> 146> 147> 148> 149> 150> 151> 152> 153> 154> 155> 156> 157>
158> 159> 160> 161> 162> 163> 164> 165> 166> 167> 168> 169> 170> 171> 172>
173> 174> 175> 176> 177> 178> 179> 180> 181> 182> 183> 184> 185> 186> 187>
188> 189> 190> 191> 192> 193> 194> 195> 196> 197> 198> 199> 200> 201> 202>
203> 204> 205> 206> 207> 208> 209> 210> 211> 212> 213> 214> 215> 216> 217>
218> 219> 220> 221> 222> 223> 224> 225> 226> 227> 228> 229> 230> 231> 232>
233> 234> 235> 236> 237> 238> 239> 240> 241> 242> 243> 244> 245> 246> 247>
248> 249> 250> 251> 252> 253> 254> 255> 256> 257> 258> 259> 260> 261> 262>
263> 264> 265> 266> 267> 268> 269> 270> 271> 272> 273> 274> 275> 276> 277>
278> 279> 1> 2> 3> Creating 'sp_MScheck_tran_retention'.
1> 2> 3> 4> 5> 6> 7> 8> 9> 10> 11> 12> 13> 14> 15> 16> 17> 18> 19> 20> 21>
22> 23> 24> 25> 26> 27> 28> 29> 30> 31> 32> 33> 34> 35> 36> 37> 38> 39> 40>
41> 42> 43> 44> 45> 46> 1> 2> 3> Creating 'sp_MSmarkreinit'.
1> 2> 3> 4> 5> 6> 7> 8> 9> 10> 11> 12> 13> 14> 15> 16> 17> 18> 19> 20> 21>
22> 23> 24> 25> 26> 27> 28> 29> 30> 31> 32> 33> 34> 35> 36> 37> 38> 39> 40>
41> 42> 43> 44> 45> 46> 47> 48> 49> 50> 51> 52> 53> 54> 55> 56> 57> 58> 59>
60> 61> 62> 63> 64> 65> 1> 2> 3> Creating procedure
sp_MSfetchAdjustidentityrange
1> 2> 3> 4> 5> 6> 7> 8> 9> 10> 11> 12> 13> 14> 15> 16> 17> 18> 19> 20> 21>
22> 23> 24> 25> 26> 27> 28> 29> 30> 31> 32> 33> 34> 35> 36> 37> 38> 39> 40>
41> 42> 43> 44> 45> 46> 47> 48> 49> 50> 51> 52> 53> 54> 55> 56> 57> 58> 59>
60> 61> 62> 63> 64> 65> 66> 67> 68> 69> 70> 71> 72> 73> 74> 75> 76> 77> 78>
79> 80> 81> 82> 83> 84> 85> 86> 87> 88> 89> 90> 91> 92> 93> 94> 95> 96> 97>
98> 99> 100> 101> 102> 103> 104> 105> 106> 107> 108> 109> 110> 1> 2> 1> 2>
1> 2> 3> Creating 'sp_MSreinit_subscription'.
1> 2> 3> 4> 5> 6> 7> 8> 9> 10> 11> 12> 13> 14> 15> 16> 17> 18> 19> 20> 21>
22> 23> 24> 25> 1> 2> 3> 4> 5> 6> 7> 8> 9> 10> Creating view
MSdistribution_status
1> 2> 3> 4> 5> 6> 7> 8> 9> 10> 11> 12> 13> 14> 15> 16> 17> 1> 2> 3> 4> 5> 6>
1> 2> 3> 4> Creating 'sp_browsereplcmds'.
1> 2> 3> 4> 5> 6> 7> 8> 9> 10> 11> 12> 13> 14> 15> 16> 17> 18> 19> 20> 21>
22> 23> 24> 25> 26> 27> 28> 29> 30> 31> 32> 33> 34> 35> 36> 37> 38> 39> 40>
41> 42> 43> 44> 45> 46> 47> 48> 49> 50> 51> 52> 53> 54> 55> 56> 57> 58> 59>
60> 61> 62> 63> 64> 65> 66> 67> 68> 69> 70> 71> 72> 73> 74> 75> 76> 77> 78>
79> 80> 81> 82> 83> 84> 85> 86> 87> 88> 89> 90> 91> 92> 93> 94> 95> 96> 97>
98> 99> 100> 101> 102> 103> 104> 105> 106> 1> 2> 3> 4> 5> Creating
'sp_dumpparamcmd'.
1> 2> 3> 4> 5> 6> 7> 8> 9> 10> 11> 12> 13> 14> 15> 16> 17> 18> 19> 20> 1> 2>
3> Creating 'sp_MSbrowsesnapshotfolder'.
1> 2> 3> 4> 5> 6> 7> 8> 9> 10> 11> 12> 13> 14> 15> 16> 17> 18> 19> 20> 21>
22> 23> 24> 25> 26> 27> 28> 29> 30> 31> 32> 33> 34> 35> 36> 37> 38> 39> 40>
41> 42> 43> 44> 45> 46> 47> 48> 49> 50> 51> 52> 53> 54> 55> 56> 57> 58> 59>
60> 61> 62> 63> 64> 65> 66> 67> 68> 69> 70> 71> 72> 73> 74> 75> 76> 77> 78>
79> 80> 81> 82> 83> 84> 85> 86> 87> 88> 89> 90> 91> 92> 93> 94> 95> 96> 97>
98> 99> 100> 1> 2> 3> Creating 'sp_MSchange_subscription_dts_info'.
1> 2> 3> 4> 5> 6> 7> 8> 9> 10> 11> 12> 13> 14> 15> 16> 17> 18> 19> 20> 21>
22> 23> 24> 25> 26> 27> 28> 29> 30> 31> 32> 33> 34> 35> 36> 37> 38> 39> 40>
41> 42> 43> 44> 45> 46> 47> 48> 49> 50> 51> 52> 53> 54> 55> 56> 57> 58> 59>
60> 61> 62> 1> 2> 3> Creating 'sp_MSdist_adjust_identity'.
1> 2> 3> 4> 5> 6> 7> 8> 9> 10> 11> 12> 13> 14> 15> 16> 17> 18> 19> 20> 21>
22> 23> 24> 25> 26> 27> 28> 29> 30> 31> 32> 33> 34> 35> 36> 37> 38> 39> 40>
41> 42> 43> 44> 45> 46> 47> 48> 49> 50> 51> 52> 53> 54> 55> 56> 57> 58> 59>
60> 61> 62> 63> 1> 2> 3> Creating 'sp_MSrefresh_anonymous'.
1> 2> 3> 4> 5> 6> 7> 8> 9> 10> 11> 12> 13> 14> 15> 16> 17> 18> 19> 20> 21>
22> 23> 24> 25> 26> 27> 28> 29> 30> 31> 1> 2> 3> Creating
'sp_MScheck_pub_identity'.
1> 2> 3> 4> 5> 6> 7> 8> 9> 10> 11> 12> 13> 14> 15> 16> 17> 18> 19> 20> 21>
22> 23> 24> 25> 26> 27> 28> 29> 30> 31> 32> 33> 34> 35> 36> 37> 38> 39> 40>
41> 42> 43> 44> 45> 46> 47> 48> 49> 50> 51> 52> 53> 54> 55> 56> 57> 58> 59>
60> 61> 62> 1> 2> 3> Creating 'sp_MSadjust_pub_identity'.
1> 2> 3> 4> 5> 6> 7> 8> 9> 10> 11> 12> 13> 14> 15> 16> 17> 18> 19> 20> 21>
22> 23> 24> 25> 26> 27> 28> 29> 30> 31> 32> 33> 34> 35> 36> 37> 38> 39> 40>
41> 42> 43> 44> 45> 46> 47> 48> 1> 2> 3> Creating 'sp_MSinsert_identity'.
1> 2> 3> 4> 5> 6> 7> 8> 9> 10> 11> 12> 13> 14> 15> 16> 17> 18> 19> 20> 21>
22> 23> 24> 25> 26> 27> 28> 29> 30> 31> 32> 33> 34> 35> 36> 37> 38> 39> 1>
2> 3> Creating 'sp_MSget_subscription_dts_info'.
1> 2> 3> 4> 5> 6> 7> 8> 9> 10> 11> 12> 13> 14> 15> 16> 17> 18> 19> 20> 21>
1> 2> 3> Creating 'sp_MSenumdistributionagentproperties'.
1> 2> 3> 4> 5> 6> 7> 8> 9> 10> 11> 12> 13> 14> 15> 16> 17> 18> 19> 20> 21>
22> 23> 24> 25> 26> 27> 28> 29> 30> 31> 32> 33> 34> 35> 36> 37> 38> 39> 40>
41> 42> 43> 44> 45> 46> 47> 48> 49> 50> 51> 52> 53> 54> 55> 56> 57> 58> 59>
60> 61> 62> 63> 64> 65> 66> 67> 68> 69> 70> 71> 1> 2> 3> Creating
'sp_MSenum_merge_agent_properties'.
1> 2> 3> 4> 5> 6> 7> 8> 9> 10> 11> 12> 13> 14> 15> 16> 17> 18> 19> 20> 21>
22> 23> 24> 25> 26> 27> 28> 29> 30> 31> 32> 33> 34> 35> 36> 37> 38> 39> 40>
41> 42> 43> 44> 45> 46> 1> 2> 3> Creating 'sp_dropanonymoussubscription'.
1> 2> 3> 4> 5> 6> 7> 8> 9> 10> 11> 12> 13> 14> 15> 16> 17> 18> 19> 20> 21>
22> 23> 24> 25> 26> 27> 28> 29> 30> 31> 32> 33> 34> 35> 36> 37> 38> 1> 2> 3>
Creating 'sp_MSdrop_anonymous_entry'.
1> 2> 3> 4> 5> 6> 7> 8> 9> 10> 11> 12> 13> 14> 15> 16> 17> 18> 19> 20> 21>
22> 23> 24> 25> 26> 27> 28> 29> 30> 31> 32> 33> 34> 35> 36> 37> 38> 39> 40>
41> 42> 43> 44> 45> 46> 47> 48> 49> 50> 51> 52> 53> 54> 55> 56> 57> 58> 1>
2> 3> Creating 'sp_MSadddynamicsnapshotjobatdistributor'.
1> 2> 3> 4> 5> 6> 7> 8> 9> 10> 11> 12> 13> 14> 15> 16> 17> 18> 19> 20> 21>
22> 23> 24> 25> 26> 27> 28> 29> 30> 31> 32> 33> 34> 35> 36> 37> 38> 39> 40>
41> 42> 43> 44> 45> 46> 47> 48> 49> 50> 51> 52> 53> 54> 55> 56> 57> 58> 59>
60> 61> 62> 63> 64> 65> 66> 67> 68> 69> 70> 71> 72> 73> 74> 75> 76> 77> 78>
79> 80> 81> 82> 83> 84> 85> 86> 87> 88> 89> 90> 91> 92> 93> 94> 95> 96> 97>
98> 99> 100> 101> 102> 103> 104> 105> 106> 107> 108> 109> 110> 111> 112>
113> 114> 115> 116> 117> 118> 119> 120> 121> 122> 123> 124> 125> 126> 127>
128> 129> 130> 131> 132> 133> 134> 135> 136> 137> 138> 139> 140> 141> 142>
143> 144> 145> 146> 147> 148> 149> 150> 151> 152> 153> 154> 155> 156> 157>
158> 159> 160> 161> 162> 163> 164> 165> 166> 167> 168> 1> 2> 3> Creating
'sp_MSdeleterepljob'.
1> 2> 3> 4> 5> 6> 7> 8> 9> 10> 11> 12> 13> 14> 15> 16> 17> 18> 19> 20> 21>
22> 23> 24> 25> 26> 27> 28> 29> 30> 31> 1> 2> 3> Creating
'sp_MSdeletefoldercontents'.
1> 2> 3> 4> 5> 6> 7> 8> 9> 10> 11> 12> 13> 14> 15> 16> 17> 18> 19> 20> 21>
22> 23> 24> 25> 26> 27> 28> 29> 30> 31> 32> 33> 34> 35> 36> 37> 38> 39> 40>
41> 42> 43> 44> 45> 46> 47> 48> 49> 50> 51> 52> 53> 54> 55> 56> 57> 58> 59>
60> 61> 62> 63> 64> 65> 66> 67> 68> 69> 70> 71> 72> 73> 74> 75> 76> 77> 78>
79> 80> 81> 82> 83> 84> 85> 86> 87> 88> 89> 90> 91> 92> 93> 94> 95> 96> 97>
98> 99> 100> 101> 102> 103> 104> 1> 2> 3> 4> 5> 6> 7> 8> 9> 10> 11> 12> 13>
14> 15> 16> 17> 18> 19> 20> 21> 22> 23> 24> 25> 26> 27> 28> 29> 30> 31> 32>
33> 34> 35> 36> 37> 38> 39> 40> 41> 42> 43> 44> 45> 1> 2> 3> 4> 5> 6> 7> 8>
9> 10> 11> 12> 13> 14> 15> 16> 1> 2> 3> 4> 5> 6> 7> 8> 9> 10> 11> 12> 13>
14> 15> 16> 17> 18> 19> 20> 21> 22> Creating 'sp_MSispublicationqueued'.
1> 2> 3> 4> 5> 6> 7> 8> 9> 10> 11> 12> 13> 14> 15> 16> 17> 18> 19> 20> 21>
22> 23> 24> 25> 26> 27> 28> 29> 1> 2> 3> Creating 'sp_MSlog_agent_cancel'.
Adding user 'guest'.
Adding role 'replmonitor'.
DBCC execution completed. If
DBCC printed error messages, contact your
system administrator.
1> 2> 3> DBCC execution completed. If DBCC printed error messages, contact
your
system administrator.
Configuration option 'allow updates' changed from 1 to 0. Run the
RECONFIGURE statement to install.
1> 2> 3> 1> 2>
end ----
" " <hv@.mail.ru> wrote in message
news:e%230YTMhTEHA.544@.TK2MSFTNGP11.phx.gbl...
> Hi.
> We installed SP3 as described in
>
http://support.microsoft.com/default...&Product=sql2k
> And now we have following errors running merge agents:
> Category:SQLSERVER
> Source: DB01
> Number: 207
> Message: Invalid column name 'published_in_tran_pub'.
> Category:COMMAND
> Source: Failed Command
> Number: 0
> Message: {call sp_MShelpmergearticles (?, 8000000, ?) }
>
> Can anybody help with that?
> Thanks,
> Vova.
>
>
|||Looks like you need to reapply SP3a.
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
"?ìá??éê ÷ìá?éíéò" wrote:

> Hi.
> We installed SP3 as described in
> http://support.microsoft.com/default...&Product=sql2k
> And now we have following errors running merge agents:
> Category:SQLSERVER
> Source: DB01
> Number: 207
> Message: Invalid column name 'published_in_tran_pub'.
> Category:COMMAND
> Source: Failed Command
> Number: 0
> Message: {call sp_MShelpmergearticles (?, 8000000, ?) }
>
> Can anybody help with that?
> Thanks,
> Vova.
>
>
>
|||This column is related to a new merge agent parameter added with sp3. Have you applied the sp3 to publisher distributor and subscriber? Is there anything in the setup log - sqlsp.log file from the c:\windows directory - this might shed some light on any
failed actions during the sp installation.
HTH,
Paul Ibison
|||Paul,
If sp3 is applied with "backward compatibility" enabled on publisher,
would subscriber be working if it has only sp2 ? Or in any case there should
be the same version of SP applied on both servers?
Thanks,
Serge.
"Paul Ibison" <Paul.Ibison@.Pygmalion.Com> wrote in message
news:942F88CC-41AB-4119-8DB7-5169DE2FDF4A@.microsoft.com...
> This column is related to a new merge agent parameter added with sp3. Have
you applied the sp3 to publisher distributor and subscriber? Is there
anything in the setup log - sqlsp.log file from the c:\windows directory -
this might shed some light on any failed actions during the sp installation.
> HTH,
> Paul Ibison
|||Serge,
the Backwards Compatibility mode on sp3 only refers to cross-database ownership and microsoft search; it isn't really like the compatibility level setting for a database. There is no definite documentation on the various compatibilities between sql server
s using different service pack levels, I guess due to the vast number of permutations, but the recommendation is clear - to have a common service pack level across publisher, distributor and subscriber.
HTH,
Paul Ibison