Trigger Security/permissions

Hi,

I'm not sure if this is the right forum, but I believe it's the closest to my question (if not, please let me know).

I am wondering if it's possible to perform an INSERT to another table in another database from within a trigger. For example:

CREATE TRIGGER inserted_mytable ON mytable
FOR INSERT
AS

DECLARE @rc INT
SELECT @rc = @@ROWCOUNT
IF @rc = 0 RETURN

INSERT INTO [OtherDB].[dbo].mytable2
SELECT *
FROM inserted

Both mytable and mytable2 have the exact same structure. What appears to be happening is that the INSERT statement locks up the mytable database. Is there a permissions problem here, or is this just not possible?

Thanks,

Jeff Tolman
E&M Electric