Do you mean create a trigger on a table which is not in the current database?

Actually, this is possible, but you can't use three-part naming. You have to do something like this:

EXEC [targetdb].[sys].[sp_ExecuteSQL] 
N'
   CREATE TRIGGER trg_Testing 
   ON [dbo].[foobar]
   FOR INSERT, UPDATE, DELETE
   AS
      BEGIN
         PRINT ''Ta Da!''
      END
'

I never thought this could be a serious question. But I am seeing 3 testimonials already :-) and it looks interesting.

Hi Marc,

Question was different. trigger should be based on of table in different database..

@Ramireddy, the question wasn't very clear on that point. The question appeared to ask if a trigger could be created from a different database, not can a trigger in one database be applied to table in another.

To clarify, a trigger on a table must exist within the same database. The trigger must also exist within the same schema as the table.

I also misunderstood the original question.

I thought the question was asking if it was possible to be logged into a database and execute code to create a trigger on a table in a different database.

Yes that can be accomplished.

If the question is if you can create a trigger that will exist inside the current database that will be applied against a table that exists in a different database, the answer is no.

And hey look, I'm a 1%er.