KyaPoocha.com

Huge Collection of Interview Questions

Search our list of 6557 Interview Questions


Can I work with registry from within T-SQL ? 

Posted in SQL Interview Questions

Yes, you can. There are many extended stored procedures shipped with SQL Server and not all of them have been described in the SQL Server manuals. There are four very useful extended stored procedures to work with registry. There are: xp_regread, xp_regwrite, xp_regdeletevalue and xp_regdeletekey.

Post Your Answer!
Send This to a Friend

← How can I compare two database ?
How can I check from the SQL Server whether the file exists or not ? →

If you liked this question/asnwer, make sure you
Subscribe to KyaPoocha.com RSS feed!


BOOKMARK THIS : BlinkList | del.icio.us | Digg it | Furl | reddit | StumbleUpon | Yahoo MyWeb |

Related Interview Questions

  • How do you register a portal?  17.11.08

    portal registry is a tree-like structure in which content references are organized, classified, and registered. It is stored in a set of tables within a PeopleS...

  • Describe your work ethic.  15.11.08

    Emphasize benefits to the organization. Things like, determination to get the job done and work hard but enjoy your work are good....

  • Describe your work ethic.  05.11.08

    Emphasize benefits to the organization. Things like, determination to get the job done and work hard but enjoy your work are good....

  • What Browsers does HTML_AJAX work with?  25.08.08

    As of 0.3.0, all the examples that ship with HTML_AJAX have been verified to work with * Firefox 1.0+ * Internet Explorer 5.5+ (5.0 should work but it hasn't...

  • How do I read from the registry via Transact-SQL ?  21.07.08

    You can use the xp_regread undocumented extended stored procedure to read from the registry via Transact-SQL. This is the syntax of the xp_regread: EXECUT...

  • How do I delete a particular value for a key in the registry via Transact-SQL ?  21.07.08

    You can use the xp_regdeletevalue undocumented extended stored procedure to delete a particular value for a key in the registry via Transact-SQL. This is the...

  • How can I edit the system tables manually ?  19.07.08

    ...

  • What is ERD(Emergency Repair Disk)?  20.02.07

    To create an ERD: 1. Click Start, point to Programs, point to Accessories, point to System Tools, and then click Backup. 2. On the Tools menu, click Create an...

  • What is registry  11.03.06

    An infrastructure that enables the building, deployment, and discovery of Web services. It is a neutral third party that facilitates dynamic and loosely coupled...

  • What is XML registry  11.03.06

    An infrastructure that enables the building, deployment, and discovery of Web services. It is a neutral third party that facilitates dynamic and loosely coupled...