in
Innovasys Logo

Missing Stored Procedures & User Defined Functions

Last post 09-15-2009 4:10 AM by Richard Sloggett (Innovasys). 1 replies.
Page 1 of 1 (2 items)
Sort Posts: Previous Next
  • 09-02-2009 9:44 AM

    • BMeyer
    • Top 100 Contributor
    • Joined on 05-27-2009
    • Posts 4

    Missing Stored Procedures & User Defined Functions

    I've noticed a couple of inquiries about missing Stored Procedures when compiling a database reference. I am having the same issue and my concern is it appears that the other quiries about this topic are unaswered.

    Filed under: ,
  • 09-15-2009 4:10 AM In reply to

    Re: Missing Stored Procedures & User Defined Functions

    We followed up on this one directly as it was logged via our support channel too, but I thought I would post the reply here for the benefit of anyone having the same problem:

    Do your missing stored procedure names begin with fn_, sp_, xp_, dt_ or dm_? If so, this is due to a Document! X feature that prevents the Stored Procedures list getting clogged up with system stored procedures.

    You can alter a registry entry to alter this behavior. Set the following registry value to cause Document! X to load all procedures:

    HKEY_LOCAL_MACHINE\SOFTWARE\Innovasys\DocumentX5\LoadPrivateDBProcedures=”True”

    Richard Sloggett
    Innovasys
    http://www.innovasys.com
Page 1 of 1 (2 items)