Post reply

Dropped sp_spaceused

  • December 22, 2005 at 5:58 am

    #111582

    Hi Friends,

    I am Pradeep. Today while testing something I have dropped the sp_spaceused stored procedure from the Master database. Please suggest me how to re-create it other than by rebuilding the master database. Please help me out..

    Regards,

    Pradeep

  • December 22, 2005 at 6:56 am

    #611104

    Look for a file procsyst.sql in the Install directory of your SQL Server installation (default of C:\Program Files\Microsoft SQL Server\MSSQL\Install). If you do a search for sp_spaceused, you'll eventually find the stored procedure code which you can copy and execute. Once you do, you'll need to regrant EXECUTE on it to public.

    K. Brian Kelley
    @kbriankelley

  • December 22, 2005 at 8:55 pm

    #611246

    Thanks Mr. Brian Kelley. Now I have the sp_spaceused back.

  • December 23, 2005 at 1:04 am

    #611256

    Somehow, the SQL Server configuration has been modified to allow system administrators to drop or change system components.

    To view the configuration, run stored procedure sp_configure and look at the value for "allow updates".

    The value of 1 indicates changes to system components are allowed and a 0 indicates that changes are not allowed.

    To disable changes, run

    sp_configure 'allow updates' , 0

    go

    reconfigure with override

    go

    SQL = Scarcely Qualifies as a Language

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

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