Monthly Archives: April 2007

SQL Server 2005 SP2 re-release and upgrade path

Bob Ward (Microsoft PSS) explained details about the SQL server 2005 SP2 re-release and hotfixes. http://blogs.msdn.com/psssql/archive/2007/04/06/post-sql-server-2005-service-pack-2-sp2-fixes-explained.aspx   Advertisements

Posted in SQL server 2005 | Leave a comment

Replicate production data for reporting (3)–Change Sps

/*Use the same script as (2) to create the publication and subscription databases and populate data.Set up the pull subscription on the subscriber. The replication must be comnfigured to use stored procedures. SQL server generates three procedures:sp_MSdel_PubTablesp_MSins_PubTablesp_MSupd_PubTableAfter snapshot is applied … Continue reading

Posted in SQL server | Leave a comment

Replicate production data for reporting (2)–By instead of triggers

–First we need to configure the publisher,distribution database, and allowed subscriber etc. Then create the database to publish on publisher:CREATE DATABASE PubTest ON PRIMARY ( NAME = TestData, FILENAME = ‘D:\ReplData.mdf’, SIZE = 10MB, MAXSIZE = 100, FILEGROWTH = 5) LOG ON … Continue reading

Posted in SQL server | Leave a comment

Replicate production data for reporting (1)

  Separating OLTP and reporting database on different server is a common requirement. If it’s to keep the same data on both databases, the solution is simple. You can either use transactional replication or log shipping based on your tolerance … Continue reading

Posted in SQL server | Leave a comment