We help IT Professionals succeed at work.

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

dkitz
dkitz asked
on
Medium Priority
1,837 Views
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
Comment
Watch Question

Nathan RileyFounder

Commented:
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?
Founder
Commented:
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

Not the solution you were looking for? Getting a personalized solution is easy.

Ask the Experts

Author

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.
Access more of Experts Exchange with a free account
Thanks for using Experts Exchange.

Create a free account to continue.

Limited access with a free account allows you to:

  • View three pieces of content (articles, solutions, posts, and videos)
  • Ask the experts questions (counted toward content limit)
  • Customize your dashboard and profile

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.