November 30, 2010 at 11:15 pm
Hi All,
I am trying to execute a stored procedure after Insert trigger on a table. The table is getting the data from Data Stage, the trigger is not executing and i am getting the following error
"Cannot add rows to sys.sql_dependencies for the stored procedure because it depends on the missing table 'USP_STG_CA_FORMAT_SALES_LOAD'. The stored procedure will still be created; however, it cannot be successfully executed until the table exists"
USP_STG_CA_FORMAT_SALES_LOAD is my Stored Procedure name.
Sujjest me how to work on this issue.
December 1, 2010 at 10:52 am
We'd need to see the code for the trigger and the stored proc to help you with this.
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply