June 2008

The Archives

• Microsoft, SQL

  Alter a table that is published under SQL 2005 replication

  06.17.08 | Permalink | Comment?

  Having recently implemented Microsoft SQL 2005 replication for a client, we had a few issues with developers trying to alter schema on the database if the table is under replication. The issue is caused because the Microsoft Visual GUI tools for SQL 2005, tries to drop and recreate the table, which is obviously not acceptable [...]

• Microsoft, SQL

  Microsoft SQL 2005 find tables missing primary keys

  06.04.08 | Permalink | Comment?

  I recently setup replication for Microsoft SQL 2005 server for a client and needed to provide a list of tables to the client without primary keys, as these are not transferred in the replication. This script came in very handy so thought I would share.

  SELECT c.name, b.name
  FROM sys.tables b
  INNER JOIN sys.schemas c ON b.schema_id = [...]

Fusion Team Blog