A virtual network setup in Azure. A Microsoft Azure domain controller. One or more Microsoft Azure Virtual Machines with SQL Server 2014 installed and configured for AlwaysOn Availability Group.

No transaction is active message when accessing Linked Server. Last week I had worked on an issue related to Linked Server. The customer had migrated the SQL Server Instances to Virtual Servers. They had quite a few Linked Servers setup. After migration any Distributed Transaction like the one below across the linked servers would fail immediately. Msg 7391, Level 16, State 2, Line 2. This problem typically occurs if one of the syst.

Project Hosting for Open Source Software. By clicking Delete, all history, comments and attachments for this page will be deleted and cannot be restored. Web based administrator for SQL Server 2005. Opera does not support ClickOnce X. To install this application, save it and then open it. Opening it directly from Opera will not work correctly. SQL DB Administrator Release 1.

Tuesday, October 23, 2012. Two Thousand Five Hundred Sixty. Seems like such a random and unassuming number, however, I can say this was the most disturbing number on the spectrum of disturbing numbers over the past few weeks.

I would like to share my knowledge with those who wants to Learn SQL. Monday, February 10, 2014. Powershell script to rename all files in a directory. Wednesday, November 13, 2013. Attach a database in the sql server. Is auto update stats on.