Hey,

I use the following:

SELECT o.[Name] AS [Table],c.[Name] AS [Column],t.[Name] AS [Type]

 ,c.[Length] as [Length]

FROM sysObjects o

 INNER JOIN syscolumns c On c.ID = o.ID

 INNER JOIN systypes t ON t.xUsertype = c.xtype

WHERE...

Thanks Jason.

Hi,

You can get, I believe, software that will document your structure..not sure about replication.

What I would do (and have done) is do your own. you can script the publications and...

Hi,

So are the Triggers on DB B triggering data to a Table on DB b or DB A

Graeme

HI,

With transactional replication, the initial snapshot is always the safer bet as you are following the standard practice. And it does ensure all objects and data are properly syncd. You...

Hi,

That really depends on how uptodate you want the local database. Also how big the tables are and what sort of connection you have to the remote database.

So a few of...

Hi,

Was a snapshot initially pushed out so that you had a synchronised start point.

Have you check identites on the tables?

Are your identites set for not for replication?

Are your logreader and...

There is nothing wrong with using different types of replication within the same database. I use all forms in my environment and we even have a database that is a...

Hi,

So it sounds like your archive table has a primary key on it and I assume this is the same as the primary key in the production table.

Are you having...

Hi Brian,

No it will not make it a Primary Key. This is up to you to create. Either by script or in the table designer. You will, of course, see...

Hi Shelly,

I don't think this is a viable solution.

You have a Subscriber to a publisher via merge and you have another publisher to which you want to subscribe.

You would need...

Hi Shelly,

The biggest problem I can see is that your P1 is used in merge replication, and this uses the uniqueidentifiers (RowGuid) to replicate.

If you want to 'join' this...

Hello Shelly,

If I understand you correctly, you have a server that is a subscriber to merge replication and you want to set this subscriber up as a publisher...seems pretty straightforward...

Replication is typically used to keep sites synchronised. It does appear to suit what you are trying to achieve.

Perhaps you might look at some custom DTS job

Just a thought

Graeme

Correction...see the subscribing databases for the MSReplication_Subscriptions