Home Forums SQL Server 2005 Development Invalid object name 'DDLTriggerTest..EventTableData'. RE: Invalid object name 'DDLTriggerTest..EventTableData'.

  • November 2, 2009 at 8:37 am

    #1073830

    Feebie (11/2/2009)

    hi,

    when u tried to modify the procedure then it gives me error like this...

    Procedure tr_ProcedureEvents, Line 6

    Invalid object name 'DDLTriggerTest..EventTableData'.

    please let me know what causes this error and how to resolve that.

    someone has put a DDL trigger on your database, and it's trying to update a table 'EventTableData' in the database 'DDLTriggerTest'

    I'd guess that both the database and thus the table are missing, so the trigger errors out.

    in SSMS go to your Server and browse to ServerObjects>>Triggers.

    you'll need to disable or drop the trigger in question.

    If it's not there, it might be at the database level...Specific Database>>Programmability>>Database Triggers

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!