SQL code have problem (USP_RECYCLE_ITEM))

[tazaru123]

i am sorry to ask but I try to put the above form

http://forum.ragezone.com/f513/sql-p...ecycle-733236/

I try to follow the slope, but it's wrong.

Msg 208, Level 16, State 6, Procedure USP_ITEM_RECYCLE, Line 545
Invalid object name 'dbo.USP_ITEM_RECYCLE'.

Please help me.

[MentaL]

[hvdaedalus]

Guess what, Line 545 says:

, ENDDATE = 0*/

which means, that this is a commented line. The Msg 208, Level 16, State 6 means, that this is an error message caused by an invalid object. (Comment = Invalid Object? No!)
If you don't have the USP_ITEM_RECYCLE Proc, then change the line which says

ALTER PROC [dbo].[USP_ITEM_RECYCLE] (

to

CREATE PROC [dbo].[USP_ITEM_RECYCLE] (

[tazaru123]

Oh!!! Thank you