Could not find stored procedure master.dbo.xp_regread error message

Posted on 2009-02-11
Last Modified: 2012-06-27
The extended stored procedure has been deleted. What is the process to recover it?

SQL Server 2000 SP 4

It is now impossible to schedule new jobs or alter old jobs
Question by:dkitz
    LVL 11

    Expert Comment

    by:N R
    You can't restore a backup on a dev machine then copy and paste the code from the backup SP and create a new on in the master DB and paste the code into it?
    LVL 11

    Accepted Solution

    Ok here you go this is the folder that contains the xpstar.dll that is what the master.dbo.xp_regread calls

    C:\Program Files\Microsoft SQL Server\MSSQL$CCSQL2000E1\MSSQL\Binn

    is the .dll still in that folder?

    If so then right click extended stored procedures and click new and point it to that .dll in that path

    Author Closing Comment

    Extended stored procedures point to a .dll file which is different from stored procedures. Stored procedures have t-sql code  that can be recovered.  This is what confused me.

    Featured Post

    Enabling OSINT in Activity Based Intelligence

    Activity based intelligence (ABI) requires access to all available sources of data. Recorded Future allows analysts to observe structured data on the open, deep, and dark web.

    Join & Write a Comment

    Introduction SQL Server Integration Services can read XML files, that’s known by every BI developer.  (If you didn’t, don’t worry, I’m aiming this article at newcomers as well.) But how far can you go?  When does the XML Source component become …
    This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
    This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.
    This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.

    728 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    15 Experts available now in Live!

    Get 1:1 Help Now