Wednesday, May 28, 2014

Disable AutoRecover in Microsoft SQL Server Management Studio

Found here, disabling AutoRecover in SSMS: Just geeks: Disable AutoRecover in Microsoft SQL Server Management Studio. This is the path for SQL Server 2005 Management Studio. I confirmed just a slight tweak is necessary for 2k8 and also show how to do it in Powershell:
PS C:\> cd hkcu:
PS HKCU:\> cd '.\Software\Microsoft\Microsoft SQL Server\100\Tools\Shell\General\AutoRecover'
PS HKCU:\Software\Microsoft\Microsoft SQL Server\100\Tools\Shell\General\AutoRecover> Set-ItemProperty . -name 'AutoRecover Enabled' -Value 0
PS HKCU:\Software\Microsoft\Microsoft SQL Server\100\Tools\Shell\General\AutoRecover> Set-ItemProperty . -name 'AutoRecover Always Enabled' -Value 0
PS HKCU:\Software\Microsoft\Microsoft SQL Server\100\Tools\Shell\General\AutoRecover> Get-ItemProperty .

No comments:

Post a Comment