Home Forums Article Discussions Article Discussions by Author Discuss Content Posted by Vince Iacoboni Get And Set SQL Server 2005 Instance Registry Values RE: Get And Set SQL Server 2005 Instance Registry Values

  • July 31, 2007 at 11:45 am

    #723676

    Your list doesn't include the DefaultData and DefaultLog entries in it.

    These are the only values I read or set on a regular basis:

    Exec

    xp_instance_regread N'HKEY_LOCAL_MACHINE', N'Software\Microsoft\MSSQLServer\MSSQLServer', N'BackupDirectory'

     

    Exec xp_instance_regread N'HKEY_LOCAL_MACHINE', N'Software\Microsoft\MSSQLServer\MSSQLServer', N'DefaultLog'

     

    Exec xp_instance_regread N'HKEY_LOCAL_MACHINE', N'Software\Microsoft\MSSQLServer\MSSQLServer', N'DefaultData'

    My blog: SQL Soldier[/url]
    SQL Server Best Practices:     SQL Server Best Practices
    Twitter: @SQLSoldier
    My book: Pro SQL Server 2008 Mirroring[/url]
    Microsoft Certified Master: SQL Server, Data Platform MVP
    Database Engineer at BlueMountain Capital Management[/url]