Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Need to Rename or Delete a System Stored Proc

Status
Not open for further replies.

JohnBates

MIS
Feb 27, 2000
1,995
US
hi experts,

I have a situation that is preventing me from creating a subscription for snapshot replication. The error says it cannot load the DLL sp_replincrementlsn.

For whatever reason, sp_replincrementlsn is in Master as an extended sp. It should be a regular sp based on what I found on 2 other SQL Servers.

I'm now trying to rename the extended sp but get "The object cannot be renamed"

If I could rename it, I could create it as a regular sp.

Have considered re-installing SP3a but I'm not certain that
would correct this problem.

The old phrase 'DLL hell' seems to apply here :)

Anyone have any advice?

Thanks, John



 
.. i got it...
In master db,

used exec sp_dropextendedproc 'sp_replincrementlsn'

Then recreated it as a regular sp in master.

John
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top