SQL code have problem (USP_RECYCLE_ITEM))
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. :*:
Re: SQL code have problem (USP_RECYCLE_ITEM))
Guess what, Line 545 says:
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
Quote:
ALTER PROC [dbo].[USP_ITEM_RECYCLE] (
to
Quote:
CREATE PROC [dbo].[USP_ITEM_RECYCLE] (
Re: SQL code have problem (USP_RECYCLE_ITEM))