• SSMS (SQL Server Management Studio) do not provide any feature to turn off Auto Recovery/Auto Save option, but this will include in the future versions. Also, Microsoft will not encorporate this feature in upcoming Service Packs. Please go through

    http://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=125840

    Regards

    Muhammad Sharjeel Ahsan