SQL Server
2011-10-29
Error updating table with rowguidcol
2011-10-21
How to know which tables are replicated?
2011-10-18
Fran Lens
2012-02-08
Fran Lens
Yesterday we did an massive update of 1 million of registers in a table of the replication DB, after the update , we started the replication of one computer, and we saw a failure in the first publication after 2000 seconds, showing the next error: Read More
Fran Lens
2011-11-28
Fran Lens
Take a practical case in which have to migrate a production SQL Server instance from Windows Server 2003 Cluster to Windows Server 2008 Cluster. One of the first steps for a migration is shut down the SQL Cluster service and delete the name of the Read More
Fran Lens
2011-11-17
Fran Lens
With the Slipstream funcionality we can integrate Service Pack or Cumulative Updates to the SQL Server installer, this save much time, specially when you need to do multiple installations. This guide is a modification of How to slipstream SQL Server 2008 R2 and a SQL Server 2008 Read More
Fran Lens
2011-11-17
Fran Lens
In one of our environments, we have a cluster with two active-active nodes with one SQL Server instance in each one.During this week, a fail of the service occurred in one of the nodes, which caused a failover to the node that was available.The problem Read More
Fran Lens
2011-10-29
Fran Lens
In one of our environments, we have two SQL Server 2008 R2 DB aligned together by Peer to Peer replication, and each of the databases have a Merge replication with multiple subscribers. When we try to make an update on a article/table that is published in Read More
Fran Lens
2011-10-21
Fran Lens
Sometimes you need to know all the tables that are replicated in a DB, for that use this scripts, run it in the replicated DB: Fran LensConsultor Senior SQL Server & BI con 9 años de experiencia, MCSE Data Platform con conocimientos de toda la Read More
Fran Lens
2011-10-18
Fran Lens
We found an error in Merge replication that im going to describe: When a Subscriber SQL Server 2005 Express replicates against a Publisher SQL Server 2008 R2 with a publication that has filtered articles, the option use_partition_groups set to true and contains an article with Read More