yes.

the user has comlete access the whole database.

TNT

Hi SQLBill,

the query works in query analyer and in the program (A.exe) here..

But the A.exe program does not work for clients...

thanx alot for your help guys...

i've decided to go with the easy option

coool, thanx for the tip 

if i remove the 'ISNULL(@var + ',','')' the query returns one...

i will change the trigger structure so that i 'treat the data as a set', as u said..

am still curious why...

Hi Antares686,

Table1,2,3 are something like this...

******************************************************

CREATE TABLE [table1]

(

[id]  INTEGER (FK)

[fd1] NVARCHAR

[fd2] NVARCHAR

[fd3] NVARCHAR

)

CREATE TABLE [table2]

(

[id] INTEGER (FK)

[f1] NVARCHAR

[f2] NVARCHAR

[f3] NVARCHAR

)

CREATE TABLE...

Hi Antares686,

i use the following code:

DECLARE @val INT

SELECT @val = valid FROM tblx

What i mean by 'batch'...

hi SQLBill,

the SELECT statement returns 5 records.

In the trigger: @@ROWCOUNT returns 5 aswell, but only one (last) record inserted in the...