Home  |  Articles  |  Scripts  |  Consultancy  |  FAQs  |  Links  |  SSIS

 

Scripts

Replication Scripts

Script to disable all snapshot jobs
Set of Scalar Functions to help deal with Schema Options  (Muhmud Ahmad)
This is a really useful set of scripts I received from Muhmud to help deal with all those awkward binary logic tasks we require when working with schema options:
getSchemaOptions - give it a binary value and it'll return a list of the options which have been set
isSchemaOptionSet - will determine if a particular option has been set
addSchemaOption and removeSchemaOption will do what they say and return the correct new schema option.
Script to get the schema options in readable format for any published article on SQL Server 2005 (Bert Corderman and Paul Ibison)
Find a list of pending merge changes (modified for SQL 2005 by Patrick Molijn)
Get a list of publisher permissions for use in a post-snapshot script
Get a list of tables without primary keys (useful for Transactional Replication)
Get a list of tables which have Identity columns without the 'Not for Replication' attribute and update them
Get a list of tables which have foreign keys lacking the 'Not For Replication' attribute and update them
Get a list of triggers lacking the 'Not for Replication Attribute'
Remove 'duplicate' merge triggers (Jane Zhu)
Fully examine merge conflicts (Jason Bohanon)
How to program the SQL Snapshot and SQL Distribution control by using Visual Basic .NET (C#)
How to program the SQL Merge Control by Using Visual Basic .NET (C#)
Script to get the schema options in readable format for any published article on SQL Server 2005 (Bert Corderman)
Setting Up Peer to Peer Transactional Replication in SQL Server 2005