Monthly Archives: July 2011

The sequence to install service packs or hotfixes on an instance of SQL Server that is part of Log Shipping/Database Mirroring/Replication/Failover Clustering environment

When an instance of SQL Server is configured as part of Log Shipping, Database Mirroring, Replication, or Failover Clustering environment, it is important to install service packs or hotfixes in a correct sequence otherwise we may get unexpected issues. This … Continue reading

Posted in Setup & Upgrade | Tagged , | 2 Comments

Fix: Reply from Destination host unreachable

In my test Hyper-V environment, I created several virtual machines (VMs). One of them is a domain controller, ADSrv which is also a DSN server. I have two other VMs, which are successfully added to the domain. However, I encountered … Continue reading

Posted in Hyper-V | Tagged , , | 1 Comment

How to detect the owner of the database objects

Prior to SQL Server 2005, if you create objects in a schema, the owner of the object is the user who created it. However, this behavior was change in SQL Server 2005 and later versions, by default, if you create … Continue reading

Posted in Uncategorized | Leave a comment