January 28, 2004 at 12:50 am
I wrote some stored procedures in SQL Server 2000 and they seem to work allright when running in query analyser. The procedures all receive several arguments and use a linked server (ODBC).
When I call the procedure from a trigger I always seem to get the same error : error converting data type nvarchar to int .
Anyone has any idea of how to solve this. I avoided using nvarchar but the error keeps popping up !!
Any help would be appriciated.
January 28, 2004 at 4:43 am
COuld you please post the code for the SP so we have a bit of an idea what you are doing.
January 28, 2004 at 9:12 am
If the proc works when called from query analizer but not from your trigger I would suspect that there is a problem with the trigger. Specifically, I would suspect that there is a problem with the way the trigger is passing parameters to the stored procedure.
January 29, 2004 at 2:55 pm
Bart,
you most likely have an implicit casting issue in your proc.
Using a linked server in a trigger, huh? That seems like a bad idea performance-wise.
cl
Signature is NULL
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply