Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase 12»»

Working with the Registry Expand / Collapse
Author
Message
Posted Sunday, March 21, 2004 6:34 AM


SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Friday, March 14, 2014 2:21 AM
Points: 912, Visits: 205
Comments posted to this topic are about the content posted at http://www.sqlservercentral.com/columnists/dasanka/w






My Blog: http://dineshasanka.spaces.live.com/
Post #107277
Posted Tuesday, March 23, 2004 10:54 AM


SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Friday, March 18, 2005 8:25 AM
Points: 37, Visits: 1

Great article Dinesh!

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.

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...

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.

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...

Thanks!




Post #107786
Posted Tuesday, March 23, 2004 12:00 PM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Tuesday, July 27, 2004 7:00 PM
Points: 99, Visits: 1

awesome article

gr8 way for getting values out of the registry.

Thanks.




Post #107798
Posted Tuesday, March 23, 2004 10:51 PM


SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Friday, March 14, 2014 2:21 AM
Points: 912, Visits: 205
Thankx all .but credit should also goes to Frank Kalis as well.






My Blog: http://dineshasanka.spaces.live.com/
Post #107871
Posted Thursday, March 25, 2004 1:08 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Tuesday, August 13, 2013 1:18 AM
Points: 5,956, Visits: 285
Thanks 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.


--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/
Post #108145
Posted Thursday, March 25, 2004 1:28 AM


SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Friday, March 14, 2014 2:21 AM
Points: 912, Visits: 205

Yes Frank,

I fully agree with you.

Yes I has to be used as the LAST OPTION. Sorry I didn't mention that in my article.

 








My Blog: http://dineshasanka.spaces.live.com/
Post #108151
Posted Thursday, March 25, 2004 1:38 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Tuesday, August 13, 2013 1:18 AM
Points: 5,956, Visits: 285
Please 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.



--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/
Post #108152
Posted Thursday, March 25, 2004 1:41 AM


SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Friday, March 14, 2014 2:21 AM
Points: 912, Visits: 205
No Frank. It is no criticism but it is a fact






My Blog: http://dineshasanka.spaces.live.com/
Post #108153
Posted Sunday, March 28, 2004 11:22 PM


SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Friday, March 14, 2014 2:21 AM
Points: 912, Visits: 205
Thankx all for your comments which help me lot






My Blog: http://dineshasanka.spaces.live.com/
Post #108707
Posted Wednesday, March 23, 2005 8:44 AM


Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Monday, November 12, 2007 6:32 AM
Points: 62, Visits: 3

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.

 

Post #169567
« Prev Topic | Next Topic »

Add to briefcase 12»»

Permissions Expand / Collapse