SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in


A blog about SQL Server Replication.

Archives: February 2012

Executing scripts with sp_addscriptexec

Looking for ways to do things more quickly and efficiently, I thought I would talk a little bit about sp_addscriptexec and how it can be leveraged to expedite the process of executing SQL scripts in a replication topology.  By creating and saving a SQL script on a publisher, it can… Read more

9 comments, 2,105 reads

Posted in SQLREPL on 10 February 2012

Arithmetic Overflow in sp_MSarticle_validation

This is probably a rare occurrence — but I've noticed that data validation for an article with 10 billion or more rows will fail due to an arithmetic overflow error in sp_MSarticle_validation.

Data validation for a specific article in a transactional publication is done using sp_article_validation which in turn… Read more

0 comments, 914 reads

Posted in SQLREPL on 7 February 2012