Post reply

Undocumented stored procedures

  • August 23, 2007 at 8:01 am

    #120179

    Can anyone explain me what is undocumented stored procedures/undocumented extended stored procedures .

    Thanks in Advance

     

  • August 23, 2007 at 8:06 am

    #728938

    There are stored procedures and extended stored procedures in SQL Server that are not part of the documentation and are not supported by Microsoft. They may disappear in future versions too. However if you figure out what their parameters are you can use them. Some undocumented extended stored procedures include xp_dirtree and xp_fileexist for example.

    You can discover some of these by looking at the system tables/views like sys.sql_modules in the master database. An easier way to find them is google

    Andras

    Andras Belokosztolszki, MCPD, PhD
    GoldenGate Software

  • August 23, 2007 at 9:07 am

    #728996

    Generally speaking, it is not recommended to use undocumented procedures in your production environment. They are not supported by Microsoft and can be dropped or changed at any version.

    So why do they exists at all ? Microsoft has developed them for their internal troubleshooting by their support team. This also applies to undocumented DBCC commands which are actually stored procedures too.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply