On the publishing databases, there is a table called MSReplication_subscriptions.

If you drop this table, it will remove the subscribers from the publisher.

If I remember correctly.

This assumes you have dropped replication.

HTH..Graeme

Hi,

I have never had any problems with this. What error are you getting?

The replication script assumes you have all your servers in place and communicating with one another. All the...

Hi,

What do you mean by 'poor internet connection' ?

So the idea is to take the transaction logs from each remote office and load them into the Head Office DB...Hmmmm...that sounds...

That's a lot of data to push out to sunscribers

All things being equal that is quite a difference between the two subscribers. Do...

Thanks very much for all your input.

I thought it might be quite straightforward..it's just good to get the nod from those who know

Thanks...

Totally agree.

Adding new columns to the publisher changes the schema. The safest way to get the schema to the subscribers would be to reinitialize.

Regards..Graeme

Hello,

This is quite a broad question and I think this directly related to your environment.

Obviously backups should be run but this is dependant on your recovery strategy as far as...

Hi,

Do you have quite a few jobs that are running every few minutes (like replication agents). These may be filling up your history log.

You could try increasing the number of...

Hey..thanks

I've been looking at those procedures.

Seems straightforward..but you never know.

Thanks again

Graeme

I am assuming you have set your developers to have the role of db_Datareader. All this means is that they cannot make any modifications to data or structure. When they...

Hi,

When you install SQL Server there should be an option to install Client Tools. This will install the Enterprise Manager

Regards..Graeme

Hi,

Your developers may only have readonly rights but if they run a standard select you will get shared locks on the tables.

Perhaps they should try and set the transaction isolation...

Hi,

You could start with this

SELECT * FROM dbo.MSdistribution_history

WHERE agent_id = (AGENT Number)

ORDER BY Start_time

Regards..Graeme

Hi Jeff,

Aren't you letting Merge manage the identities ??

Graeme

Hello,

We are using tablocks.

Our system is SQL2000 SP3a.

Interesting point from Mel although I don't think that applies to us...a reboot might be worth a try.

Still looking at the TSQL now....and...