Post reply

Why is a system stored procedure missing?

  • March 19, 2007 at 10:13 am

    #117912

    I installed an SQL Server 2000 cluster with SP3a on the Windows Server 2003. After completing, I found the stored procedure, sp_dboption, is missing. Do you have such experiences before? If so, what is the best way to fix it?

    Many thanks in advance.

  • March 19, 2007 at 10:35 am

    #695766

    check your sqlsp.log to see if there was an error along the way. This should be in C:\Windows. You'll find the sp_dboption stored procedure in the sp3_serv_uni.sql sql script, which should be in the install directory (typically C:\Program Files\Microsoft SQL Server\MSSQL\Install).

    There should also be a .out file there which tells you the results of that script being run. You should find in it a statement that read, "Creating 'sp_dboption'."

     

    K. Brian Kelley
    @kbriankelley

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

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