SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
Search:  
 
 

Merge Wizard

By Additional Articles, 2006/11/15

Total article views: 473 | Views in the last 30 days: 9

In our environment, we needed to create and drop replication over and over in our test environment and I got realy tired of having to manualy go to each table with an identity column to set its ranges. This sproc will create or drop the publications and/or subscriptions for all or some of the objects in your database. Its nothing fancy, and could use alot of tweaking for your needs, but it works well for us.

By Additional Articles, 2006/11/15

Total article views: 473 | Views in the last 30 days: 9
Your response
 
 
Related tags

Replication    
 
Related content

You are a database architect of a SQL...

By Steve Jones | Category: Replication
(not yet rated) | 1,879 reads

Which of the following is not an option...

By Andy Warren | Category: Replication
(not yet rated) | 1,867 reads

Which of the following actions can be done...

By Andy Warren | Category: Replication
(not yet rated) | 1,656 reads
 
Contribute

Free registration required...

To read the rest of this article, and access thousands of other articles, we ask you to register on the site and subscribe to our newsletters.

Login (existing users)

Login

Email:   Password:   Remember me: Forgotten your password?

Register (new users)

Register

Email:   Password:
Confirm:

Subscribing to our newsletters gets you:

  • ALL of our content (thousands of articles, scripts, and forum postings)
  • A daily newsletter (example)
  • A weekly news round up (example)
  • The opportunity to ask and answer questions in our forums
  • A daily Question of the Day to test and help you increase your knowledge of SQL Server.

Steve Jones
Editor, SQLServerCentral.com