2012 SP1, SMO: Database.SetOffline() doesn't allow termination options - by Brandon.Tucker

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 779824 Comments
Status Closed Workarounds
Type Suggestion Repros 0
Opened 2/22/2013 10:48:02 AM
Access Restriction Public


When calling the Database.SetOffline() method, no termination options are included, nor is there the ability to specify one.  For methods such as this with termination options in T-SQL, being able to specify a ROLLBACK IMMEDIATE or a NO_WAIT would be incredibly helpful.
Sign in to post a comment.
Posted by Microsoft on 3/20/2013 at 7:33 PM

We took a look at this DCR along with several others. Unfortunately triaging it against other critical DCRs I do not think we would get to investigate and implement this in the near future, so we decided not to proceed with this DCR in the next SQL Server release.
However, we have taken note of this internally, and when we revisit this functionality in the future, we will try and get this implemented.

Thanks for writing to Microsoft.
Alex Grach (MSFT)