Writing to the Registry from TSQL Using XP_Instance_RegWrite

Reading from the registry to figure out a configuration issue or two is common, but writing to the registry isn't something you'll need to do very often. Still, it's a useful trick to know and we've put it to work showing you how to alter the default folder used for database backups.

Andy Warren is a software trainer focusing on SQL Server, a member of the PASS Board of Directors, and a principal in this site - SQLShare.com.

Alankar Chakravorty on 3/18/2010

Cool

ricardoacaraujo@hotmail.com on 3/18/2010

Razoavel

Eric Willesmtein on 3/18/2010

Very good

E72B0A9423 on 3/18/2010

fantastic information

Kevin on 3/18/2010

Excellent, as always. Thanks.

Joegar Ochoa on 3/19/2010

this is a great help, i have no idea about reading and writing to the registry using sql command, but now i do have... thanks!

Robert Kryzak on 3/21/2010

Very clear and to the point

Clayton Smith on 3/22/2010

Very handy indeed!

malleswarareddy on 3/22/2010

very helpfull

Mario Piccin on 4/13/2010

good explanation! Tks a lot!!!

Jason Sunde on 7/11/2011

A nice, informative session.

Leonard Peoples on 5/7/2012

This is perfect. It explains why our server is getting these phantom registry entries. I hope you guys haven't folded. These training videos are awesome.