Results 1 to 3 of 3
  1. #1
    Join Date
    Apr 2003
    Posts
    5

    Question Unanswered: Update dbs with trigger??

    Hallo,

    I am not very keen in triggers, but I know how to apply a Trigger to tables on the same database
    Is it possible to apply a Trigger on tables on different databases?

    Thx for helping

  2. #2
    Join Date
    Feb 2002
    Location
    Houston, TX
    Posts
    809
    If you are in database A and want to apply a trigger to table B in database C then either switch to databse C and apply the trigger to table B. OR use a three part name <Database>.<Owner>.<Table Name> for the "ON" part of the create trigger.
    Paul Young
    (Knowledge is power! Get some!)

  3. #3
    Join Date
    Apr 2003
    Posts
    5

    Talking

    THX, it works.

    I was wrong at the 3 part name. I thought <Server>.<Database>.<Table>.
    Thx for your help.

    Have a nice day

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •