Browse by Tags

SQL Server 2005 - specific roles for replication agents

Published 22 February 8 2:10 PM | SSQA.net

Whenever the replication is configured, a set of agent profiles is installed on the Distributor, thsi profile will have a set of parameters that are used each time an agent runs. In addition to this the replication provides a default profile for each...

Filed under: sql server, replication, permissions, best practices, roles, agent, publisher, beginners, distributor, subscriptions

Replication FAQ - how to know Distributor and Publisher with scripts

Published 19 February 8 4:45 PM | SSQA.net

A newbie set of question that how to know the whether the current server is distributor or publisher? Any pre-defined script to know any other publishers that are using as Distributor? Well, there are such pre-defined scripts and stored procedures are...

Filed under: sql server, replication, snapshot, script, merge, publisher, transactional, distributor, schedule

Replication FAQ series - Which objects in the database are published?

Published 11 December 7 5:47 AM | SSQA.net

select name as published_object, schema_id, is_published as is_tran_published, is_merge_published, is_schema_published from sys.tables where is_published = 1 or is_merge_published = 1 or is_schema_published = 1 union select name as published_object, schema_id...

Filed under: sql server, replication, publisher, transactional, tsql, distributor