Replication was stopped for one subscriber database due to memory issue with following error, [CODE] Error messages: There is insufficient system memory to run this query. (Source: MSSQL_REPL, Error number: MSSQL_REPL27453) [/CODE] It got resol...

Following is the script to add stored procedures in publication using tsql script for transactional replication. It is just same as adding views in publication , You just need to change relevant objects and type in script. [CODE] USE PublisherDB G...

Same as stored procedures & views adding in publication, we can add functions in publication for transactional replication with following script where you need to change type and add function name as a article. [CODE] USE PublisherDB GO exec sp_...

I have shared a script to enable replication database http://beyondrelational.com/justlearned/posts/724/enabling-the-replication-database-in-sql-server.aspx, here you can find a script to create publication after enabling the replication database. You c...

I have shared queries to find out objects which are published in replication 1. Objects having data and schema replicated (Tables), http://beyondrelational.com/justlearned/posts/639/sql-server-how-to-know-the-objects-published-in-replication.aspx ...

You may read earlier post to add transactional publication in replication here http://beyondrelational.com/justlearned/posts/730/adding-the-transactional-publication-in-replication-sql-server.aspx, here how can we add a transactional pull subscriptions ...

As last time i submitted script to add table in existing publication here http://beyondrelational.com/justlearned/posts/692/script-to-add-table-in-existing-publication-in-replication-sql-server.aspx, you can find the script to add views in existing pub...

I just learned some new improvements/enhancements to replication as it supports 15,000 partitions in SQL Server Denali CTP3 now.......

While i was working on the issue of replication and encountered issue with following error, [CODE] Command attempted: if @@trancount > 0 rollback tran (Transaction sequence number: 0x000CAB2A00038CB6003B00000000, Command ID: 2) Error message...

As we have seen here http://beyondrelational.com/justlearned/posts/639/sql-server-finding-tables-published-in-replication.aspx, which will you give the list all the tables which are published by replication. But it will not return stored procedures, vi...