SQLServerCentral.com / Discuss Content Posted by Dinesh Asanka / Article Discussions by Author / Article Discussions / Working with the Registry / Latest PostsInstantForum.NET v99.99.99SQLServerCentral.comhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comFri, 09 Dec 2016 06:51:20 GMT20RE: Working with the Registryhttp://www.sqlservercentral.com/Forums/Topic107277-144-1.aspxIts a great article and thanks for sharing it...I wonder, is there's any way of knowing the existence of a key before reading it?Wed, 17 Oct 2007 03:20:16 GMTRamesh SaiveRE: Working with the Registryhttp://www.sqlservercentral.com/Forums/Topic107277-144-1.aspx<P>Great article, thanks for sharing it! It's probably important to point out that it is the server's registry that is being used, rather than the client's.</P><P> </P>Wed, 23 Mar 2005 08:44:00 GMTJT LovellRE: Working with the Registryhttp://www.sqlservercentral.com/Forums/Topic107277-144-1.aspxThankx all for your comments which help me lotSun, 28 Mar 2004 23:22:00 GMTDinesh AsankaRE: Working with the Registryhttp://www.sqlservercentral.com/Forums/Topic107277-144-1.aspxNo Frank. It is no criticism but it is a fact<img src='images/emotions/cool.gif' height='20' width='20' border='0' title='Cool' align='absmiddle'>Thu, 25 Mar 2004 01:41:00 GMTDinesh AsankaRE: Working with the Registryhttp://www.sqlservercentral.com/Forums/Topic107277-144-1.aspxPlease don't get me wrong. My reply wasn't meant to be criticism, but rather calling attention on this nasty side-effect of using something undocumented.<img src='images/emotions/smile.gif' height='20' width='20' border='0' title='Smile' align='absmiddle'>Thu, 25 Mar 2004 01:38:00 GMTFrank KalisRE: Working with the Registryhttp://www.sqlservercentral.com/Forums/Topic107277-144-1.aspx<P>Yes Frank,</P><P>I fully agree with you. </P><P>Yes I has to be used as the LAST OPTION. Sorry I didn't mention that in my article.</P><P> </P>Thu, 25 Mar 2004 01:28:00 GMTDinesh AsankaRE: Working with the Registryhttp://www.sqlservercentral.com/Forums/Topic107277-144-1.aspxThanks Dinesh!There is just one thing I like to add. All of these procedures are undocumented and subject to change anytime at Microsoft's will. I would really carefully think about this BEFORE writing production code with these procedures. Nonetheless I agree it's good to know that there is a way, but then again there are also many other ways. I would prefer doing this in the application layer.Thu, 25 Mar 2004 01:08:00 GMTFrank KalisRE: Working with the Registryhttp://www.sqlservercentral.com/Forums/Topic107277-144-1.aspxThankx all .but credit should also goes to Frank Kalis as well.Tue, 23 Mar 2004 22:51:00 GMTDinesh AsankaRE: Working with the Registryhttp://www.sqlservercentral.com/Forums/Topic107277-144-1.aspx<P>awesome article</P><P>gr8 way for getting values out of the registry.</P><P>Thanks.</P>Tue, 23 Mar 2004 12:00:00 GMTsamm2425RE: Working with the Registryhttp://www.sqlservercentral.com/Forums/Topic107277-144-1.aspx<P>Great article Dinesh!</P><P>I agree with you that accessing registry keys from SQL Server scripts/stored procedures is not something that you will do often, but is great to know that you actually "can" do it if you want. </P><P>I think that maybe this extended stored procedures can be useful as a good alternative to logged operations (compared to logging in the event log or somewhere else) or to keep configuration information in the registry (buffer size for cursors, type of locking, or whatever you can think of) by pointing your sp's to read to a particular registry. Then, if you want to try your sp's with different configurations you don't have to modify all of them, simply change that registry key...</P><P>Other ideas would be to keep on the registry the name of files where your stored procedures will write debugging information. Then, if you decide to move your debugging files somewhere else, just change the registry.</P><P>The Isn't weird?... you can even change the desktop background from a stored procedure!.. the limits of the registry key are endless if you know how to use it...</P><P>Thanks!</P>Tue, 23 Mar 2004 10:54:00 GMTmsuraskyWorking with the Registryhttp://www.sqlservercentral.com/Forums/Topic107277-144-1.aspxComments posted to this topic are about the content posted at <A HREF=http://www.sqlservercentral.com/columnists/dasanka/workingwiththeregistry.asp>http://www.sqlservercentral.com/columnists/dasanka/wSun, 21 Mar 2004 06:34:00 GMTDinesh Asanka