Hello, I have a table in my SQLServer1 (SQL2000) this table has a Trigger
For Delete

The content of the trigger is:

insert into SQL2.myDb.dbo.myTable select * from deleted


The SQL2 is a linked SQL2000 Server

But, when I delete one row from myTable the query never end and hang the EM
or QA

When I execute a manua insert into from the SQL Query Analyzer, the command
is executed OK.:
like this:

insert into SQL2.myDb.dbo.myTable select * from myActualTable


So, I think that the problem is with the Trigger and the Linked Server

Help me please

Thanks a lot

AA