Results 1 to 3 of 3
  1. #1
    Join Date
    Nov 2003
    Posts
    7

    Unanswered: New Basic Trigger "Invalid Object Name"??

    Tables cargotrailers, picthumbs
    I get Invalid object name "picthumbs" when I try to insert a record in cargotrailers.


    Alter Trigger dbo.cargotrailers_Trigger1
    On dbo.cargotrailers
    For Insert As

    BEGIN


    INSERT INTO picthumbs (th_key, th_time)
    SELECT ct_id, getdate() FROM INSERTED
    END


    Thanks

  2. #2
    Join Date
    Jun 2003
    Location
    Ohio
    Posts
    12,592
    Provided Answers: 1
    Is picthumbs dbo-owned, and who has permission to write to it?

    blindman

  3. #3
    Join Date
    Nov 2003
    Posts
    7

    Re: New Basic Trigger - Didn't like imported table structure

    Fixed
    I deleted the picthumb table and built it again from scratch. Originally I had imported the structure of this from another database.

Posting Permissions

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