Results 1 to 2 of 2
  1. #1
    Join Date
    Mar 2004
    Location
    UK
    Posts
    26

    Unanswered: Should hidden stored procedures be used?

    Should stored produres that are "hidden" from us users be used?
    I'm thinking in particular of using sp_MSgetversion to get the SQL Server version number and to be able to run different script if i'm on SQL Server 7.

    Why are they not documented in the first place? Is it because they might change and they don't want us to use them?

  2. #2
    Join Date
    Aug 2002
    Location
    Scotland
    Posts
    1,578
    Any stored procedure which is not documented in books online is an undocumented procedure and MS can change or delete at any time or during service pack releases.

    The ideal option is to disallow normal users to execute those undocumented SPs.
    --Satya SKJ
    Microsoft SQL Server MVP
    [IMG]http://sqlserver-qa.net/google_bart.gif[/IMG]

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •