Results 1 to 3 of 3
  1. #1
    Join Date
    Feb 2004
    Posts
    7

    Unanswered: Views and triggers

    Hi All,

    I have a strange problem, when I define an after update trigger on a view I have a message saying:
    "Server: Msg 208, Level 16, State 4, Procedure after_update_tblpcl_AnalogValue_Minutely, Line 1"
    although I am the owner of the view and its in my DB, but when I make the trigger as "Instead of Update" it works fine.

    thanx for help.

    PEACE!

  2. #2
    Join Date
    Sep 2003
    Posts
    364
    After triggers can't be used on views right? Only instead of triggers could be created on views.

  3. #3
    Join Date
    Feb 2004
    Posts
    7

    Triggers and views

    Hi all,

    yes peterlemonjello u r right, things got mixed in my mind.

    PEACE!

Posting Permissions

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