Browse by Tags

SQL Server Replication - resolving too many snapshots issues?

Published 15 April 8 6:15 AM | SSQA.net

In case you have many snapshots generated within your Replication setup and having troubles in finding what kind of scheduled job is running during the time of snapshot publication. By default you coudl take help of system catalog MSsnapshot_agents and...

Filed under: sql server, replication, snapshot, sqlagent, script, publisher, tsql, schedule

Replication FAQ series - Which columns are published in snapshot or transactional or merge publications in this database?

Published 11 December 7 6:48 PM | SSQA.net

Here is script you can find which columns are published in the replication that is using either snapshot or transactional or merge publications. --For snapshot or transactional publications select object_name(object_id) as tran_published_table, name as...

Filed under: sql server, replication, snapshot, merge, transactional, tsql, tables, columns, FAQ