it's solved.

I copyed the object again and put it in the @var1 and it works...

Maybe it was something like ' or other think...

Thank you

CREATE TRIGGER TRG_INS_CARTOES ON dbo.CARTOES

INSTEAD OF INSERT

AS

begin

declare @NUMCARTAO integer

declare @NIF_ANTIGO varchar(20)

declare @IS_CENTRAL_LX as char(2)

select @IS_CENTRAL_LX = TP_CENTRAL from parametros

--Não actualiza no Central sincronizador

if ISNULL(@IS_CENTRAL_LX, '-1') <> 'LX'

...

if fails at creating

Yes, i cliked and it redirect me to the END ELSE BEGIN...

The error was lack of ()

now, when i execute it i receive another error:

Msg 156, Level 15, State 1, Procedure TRG_INS_CARTOES, Line 32

Incorrect syntax near the keyword 'else'.

Msg 156, Level...

thank you very much once more

Ninja i am sorry but my english is not very good.

What did you mean with your last post?

did you mean that i am doind right if i create the job...

It's decided! i am going to create the job that updates the stats to work every day.

Thank you very much gail and ninja for the great help.

I did it to a database that is not on production.

In this case what do you think?

It's better to update statistics every day manualy on the production database or...

sorry did,t undestood your question.

What i did was:

I created some new indexs on some tables includind the liquidacao table.

This are new indexs created on tables.

I have tried create the indexes...

With the indexs created and the update statistics the query is now very fast..

Thank you gail.

I have created indexes on all the tables that make joins in the query (some did not had).

Now the query is permorming much better.

and in 2000? the behavior was the same? or it was neded less chages to fire the trigger?

Thanks for the tip but in this case i don't know if it is necessary, because when you update the statistics the query becames very performante.

By the way, i have one table (that is on the join) which as a column (the primary key) with an DESC index.

A DESC index is what you call on...