What do you mean by ODBC calling?

In my case everything has to happen on the server...

Func1 works just fine.

I've simulated the trigger from Query Analyzer (removed the first line "create trigger etc." and replaced the "from deleted" and "from inserted" part with a select statement)...

Try this and you'll get an answer for start:

select text

from sysobjects t1

left join syscomments t2 on t1.id = t2.id

where t1.name = 'sp_MS_marksystemobject'

PS: I don't know more about this...

I don't know if it will help, but try to modify the "T5.ProdType IN ('Release', 'Update', 'Upgrade')

" part to a JOIN. With other words: put the 'Release' and 'Upgrade' values...

Here is the trigger:

-- trigger start

CREATE TRIGGER Trig1 ON dbo.Tabel1

FOR INSERT, UPDATE, DELETE

AS

--return

-- comment1

declare @date smalldatetime, @first smalldatetime

set @date = dbo.func1('param') -- comment

-- comment...

Hi everybody!

First of all, my apologies, especially for Antares686, who wrote (and I did not pay enough atention):

"May be that something about the datatypes is causing the issue. For example...

The whole story is the following:

I am using MS Access XP .adp and MS SQL Server 2000 to realise my project. This means that if I modify an SQL object's...

What is DDL?

"For example if one is CHAR(2) and the other is CHAR(4) then in the other every items has 2 spaces after it so 'X1 ' would not be...

Dear Antares686!

Your advice did not fix the problem. The symptom is the same with the new syntax, too.

But, I'll keep in mind your advice.