You can query both databases but DML on the former principal would fail. I have not noted any CU8 SQL2K5 SP3. So if you are above that build and DML...

It could be a perceived split brain scenario. If you are above the builds mentioned in the KB below, then enable trace flag 1439 and 3605 to get the synchronization...

Yes. @SQLChicken already replied to this on the #sqlhelp hashtag on Twitter. Create condition for facet TABLE and use property of @HasClusteredIndex = True.

Reference: http://msdn.microsoft.com/en-us/library/ms135681

Capture a Process Monitor trace on the destination server and check if the account requesting access on the share is showing up as anonymous. It could be an impersonation issue.

The error message is being raised because of the SKU limitation of Express. SQL Server 2005 Express has a SKU limitation of 4GB for the database size. If you want...