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