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

Posted on July 31, 2011 by Alex Feng

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 xxx.xxx.xxx.xxx: Destination host unreachable

Posted on July 27, 2011 by Alex Feng

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

Posted on July 27, 2011 by Alex Feng

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