Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
Author |
Topic |
kaus
Posting Yak Master
179 Posts |
Posted - 2001-05-30 : 12:30:53
|
I have sp that inserts data from asp page and a trigger that fires email to inform us of the insert. I'm getting an 'invalid object name' for the inserted table when I try to reference it in the trigger. Am I not correctly using 'inserted' ?? Below is trigger and spTriggerCREATE TRIGGER mail_data_request ON RequestsFOR INSERT ASexec master.dbo.xp_sendmail 'pvitt@sawpa.org', @query = 'DataRequests.dbo.sp_data_request_query',@subject = 'new data request'Query Stored ProcCREATE PROCEDURE [sp_data_request_query] ASselect ins.FirstName + ' ' + ins.LastName + ', ' + ins.title + ' of ' + ins.Organization as Requestor, ins.request_info as Requests, ins.email as email,ins.ph_area_code + '-' + ins.ph_prefix + '-' + ins.ph_suffix as phonefrom inserted insThanks a lot |
|
|
|
|