Believe It When Microsoft Tells You Not to Use Undocumented Functions and Behaviors

SQL Server has always had nifty undocumented functions that are tempting to use. However, Microsoft has always urged users not to use those functions because they can change in future releases. For the most part, Microsoft hasn't changed undocumented behavior in a way that would cause problems if you had been sneaky and used some of the hidden features. SQL Server 2000 Service Pack 4 (SP4), however, will add limitations on what you can do with the undocumented extended stored procedures xp_regread and xp_regwrite. Perform an Internet search for xp_regread or xp_regwrite and you'll find dozens of sites that will teach you how to use those procedures to read from and write to the registry. Starting in SP4, these procedures will work with only SQL Server's registry keys. I'm sure there are many people using these extended procedures who won't be pleased with the change, but we were warned. Historically, SQL Server users could get away with ignoring the don't-use-an-undocumented-feature rule. Using the features rarely burned us. Now, we'll have to change our way of thinking and stop using undocumented and unsupported features in our production code.

Hide comments


  • Allowed HTML tags: <em> <strong> <blockquote> <br> <p>

Plain text

  • No HTML tags allowed.
  • Web page addresses and e-mail addresses turn into links automatically.
  • Lines and paragraphs break automatically.