Viewing 9 posts - 1 through 9 (of 9 total)
Hi guys,
the issue is solve and came from the concatenated NULL value ; By testing each of them in my select query, I managed to make it work !
Thx too...
October 14, 2011 at 2:20 am
Got it 😉
It is not an issue as only one test result could be written at the time.
October 12, 2011 at 9:45 am
Thx for your answer !
I will rewrite all my query and keep you posted !
October 12, 2011 at 7:39 am
In the log table, I got this NULL message instead of having 'OUTPUT' + @OUTPUT.
This strange 'NULL' string make me think that maybe the concatenation I've done fails somewhere, then,...
October 12, 2011 at 6:26 am
Here is the trigger snippet code :
My environnement : SQLServer 2005, PV_TEST2 is the database; it contains 2 tables, results and debugTrace
DSN is like : DRIVER={SQL Server};DATABASE=PV_TEST2;SERVER=FQDNofTheServer;UID=PV_sun;PWD=****
USE [PV_TEST2]
GO
SET ANSI_NULLS ON
GO
SET...
October 12, 2011 at 1:46 am
I'm not at the office this afternoon, tomorrow, I will come back with the trigger source.
Thx all for your help 🙂
October 11, 2011 at 8:02 am
humm ...
In case of bulk insert, no trigger are fired, OK ; But, when the software insert data into the table (using the DSN) the trigger IS fired, as some...
October 10, 2011 at 10:01 am
Thx for your answer !
What I dont understand is why when I write the sql insert from the sql management studio, the trigger runs properly, with every data as expected....
October 10, 2011 at 9:47 am
thx for your opinion, but I really need date to be sync almost in real time.
October 10, 2011 at 9:35 am
Viewing 9 posts - 1 through 9 (of 9 total)