SQL Upgrade Advisor: Need rule to check for COMPUTE clause - by Arvind Shyamsundar

Status : 

  Won't Fix<br /><br />
		Due to several factors the product team decided to focus its efforts on other items.<br /><br />
		A more detailed explanation for the resolution of this particular item may have been provided in the comments section.

Sign in
to vote
ID 767345 Comments
Status Closed Workarounds
Type Suggestion Repros 0
Opened 10/13/2012 9:17:35 PM
Access Restriction Public


COMPUTE clause is not allowed in database compatibility 110. References:  http://technet.microsoft.com/en-us/library/ms144262.aspx and http://msdn.microsoft.com/en-gb/library/ms181708(v=SQL.100).aspx.

However, SQL Upgrade Advisor does not detect this issue.
Sign in to post a comment.
Posted by SAinCA on 2/4/2013 at 5:48 PM
Anyone know of a "real" Upgrade Advisor that WILL inform of issues like this before we suffer "unforeseen consequences"? I have 3 instances whose databases are entirely new to me to upgrade and don't need surprises!

Posted by Sanjay [MSFT] on 1/31/2013 at 11:43 PM
Hi!, thanks for writing in to Microsoft.

We took a look at this feature request and triaged it against several others and unfortunately, it did not meet the bar to be fixed. While we are closing this issue as 'won't fix', we have taken note of this internally and we will try & incorporate this request when we revisit this functionality in a future release of SSUA.

Sanjay Nagamangalam, SQL Server Manageability