Re: Help on : Could not find stored procedure 'recurse_oids'
- From: Hugo Kornelis <hugo@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx>
- Date: Mon, 08 May 2006 22:10:36 +0200
On Mon, 8 May 2006 06:11:02 -0700, dondiego wrote:
Hello everyone,
I'm on MS SQL SERVER 2000.
When runing this simple delete statement:
delete from sd50.cdm_locations where loc_oid =146836832983830528
I get the following error:
Server: Msg 2812, Level 16, State 62, Line 15
Could not find stored procedure 'recurse_oids'.
The statement has been terminated.
Can you please tell me what is wrong?
I can't seem to find any information about the sp 'recurse_oids'
Thanks a lot!
Erite
Hi Erite,
Check for triggers on the cdm_locations table. There's probably a DELETE
trigger that calls this stored procedure.
Of course, the real problem will be reconstructing the stored procedure
after yoou find out why it's being called and whhat it's supposed to do.
You might want to check some old backups of the DB to see if they still
have a copy of the recorse_oids stored procedure.
--
Hugo Kornelis, SQL Server MVP
.
- Prev by Date: Re: How to keep a log register after rollback transaction?
- Next by Date: Re: Last order date for each customer
- Previous by thread: Re: How to keep a log register after rollback transaction?
- Next by thread: Re: Last order date for each customer
- Index(es):
Relevant Pages
|
|
