irabufan (3/26/2014)
thanks, so this sounds like a soft restriction rather than hard restriction based on your experience. doesn't mean i want to do something not officially supported by MS but at least it gives us an option
It's a soft restriction but not supported by MS due to the integrity issues during the failover.
Check this ..
http://msdn.microsoft.com/en-us/library/ms366279.aspx
--
SQLBuddy