• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1479
  • Last Modified:

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

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
0
dkitz
Asked:
dkitz
  • 2
1 Solution
 
Nathan RileyFounder/CTOCommented:
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?
0
 
Nathan RileyFounder/CTOCommented:
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
0
 
dkitzAuthor Commented:
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.
0

Featured Post

What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now