Peer-to-Peer Replication (Programmatic Control and Setup)

I have reviewed the BOL documentation on how to configure Peer-to-Peer replication via T-SQL and how to use the Replication Wizard to implement replication.

What I would like to find out is how do I configure the peer-to-peer replication process to use an existing column on a table that contains a GUID instead of creating an extra column with a uniqueidentifier GUID value. When you use the Wizard each table article has this extra column added to it.

I don't seem to be able to find it in the books-on-line. Can some one point me to the correct article or BOL page.

Thank you.

...cordell...

I do not think that P2P replication adds a uniqueidentifier column to a published table. Transactional queued replicaiton and merge replication will add required columns to a table that you want to publish. Please confirm which type of replication you are trying to use.

A general suggestion is to use the UI to implement the replication scenario that you want, then use the scripting featues in the UI to see the syntax for the new column that was added.

i.e. Merge replication will add the following column to a table that is merge published...

[rowguid] [uniqueidentifier] ROWGUIDCOL NOT NULL CONSTRAINT

Check out this link for more details on how merge replcation adds a rowguid uniqueidentifier column if one does not exist -- http://msdn2.microsoft.com/en-us/library/aa256294(SQL.80).aspx

Hope this helps,

Tom

This posting is provided "AS IS" with no warranties, and confers no rights.

pckg config.

Hi,

I have configure our ssis project that will take the connection string from the database

but when i change the connection string so the pckg will take the data from another server with exact tables name it fails.

what do you think the problem is ?

I think the problem is a mistake in the changed connection string or the preparation of the additional server. Perhaps if you gave us the full error message you get, we can make an informed guess?

Can you also be clear about which connection string has changed, one contained within the configuration store, or the connection that points to the SQL Server holding the configuration table?

|||

Hi,

this is the error i get

Message
Executed as user: FLYING-CARGO\dwhadmin. ...0.3042.00 for 32-bit Copyright (C) Microsoft Corp 1984-2005. All rights reserved. Started: 12:48:14 Error: 2007-07-10 12:48:16.00 Code: 0xC0202009 Source: Load AirPort_City_Codes airport_city_codes [31] Description: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80040E14. An OLE DB record is available. Source: "Microsoft SQL Native Client" Hresult: 0x80040E14 Description: "Statement(s) could not be prepared.". An OLE DB record is available. Source: "Microsoft SQL Native Client" Hresult: 0x80040E14 Description: "Invalid object name 'export_db_drp.dbo.airport_city_codes'.". End Error Error: 2007-07-10 12:48:16.02 Code: 0xC004706B Source: Load AirPort_City_Codes DTS.Pipeline Description: "component "airport_city_codes" (31)" failed validation and returned validation status "VS_ISBROKEN". End Error Error: 2007-07-10 12:48:16.02 Code: 0xC00470... The package execution fa... The step failed.

what i've changed is the connection string of my erp db.

|||

what i've changed is the connection string of my erp db which store in my configuration table.

10x.

|||10x i've fix it.|||Could you post the resolution?|||

Hi steam5,

Description: "Invalid object name 'export_db_drp.dbo.airport_city_codes'." draws my attention. If you are executing a query, check if that runs successfully on the SSMS Query Editor after connecting to the ServerName you have changed. If succeeded, use the OLEDB source preview to look for top few rows.

Thanks

Subhash Subramanyam

sql

PASV ftp?

Hi!
We installed a new router and now the ftp server only works in passive mode.
Is there a way to configure the replication agent to transfer the snapshot
using PASV?
Replication is merge pull.
Thanks.
Carlos Gutirrez
carlosg@.sca.com.mx
no, SQL Server replication only supports the ftp command set used by
Microsoft FTP server. You are free to use any other vendor's FTP server, but
are restricted to Microsoft's FTP command set.
Hilary Cotter
Looking for a book on SQL Server replication?
http://www.nwsu.com/0974973602.html
"Carlos Gutierrez" <carlosg@.sca.com.mx> wrote in message
news:wk0Nc.20534756$Of.3407707@.news.easynews.com.. .
> Hi!
> We installed a new router and now the ftp server only works in passive
mode.
> Is there a way to configure the replication agent to transfer the snapshot
> using PASV?
> Replication is merge pull.
> Thanks.
> --
> Carlos Gutirrez
> carlosg@.sca.com.mx
>

Passqord Policy on SQL Server

Hello,
I'm new to SQL Server and I was wondering if I'm using SQL Server
authentication then how I configure the password policies such as password
age and password complexity.
Thanks
Manish
SQL Server 2000 does not support password age / complexity in regards to SQL
Server logins, but future versions probably will.
Keith
"MJ" <MJ@.discussions.microsoft.com> wrote in message
news:9EF4FED3-9C01-47FC-8765-4BFFD7272AE2@.microsoft.com...
> Hello,
> I'm new to SQL Server and I was wondering if I'm using SQL Server
> authentication then how I configure the password policies such as password
> age and password complexity.
> Thanks
> Manish
>