Post reply

Unknown Error

  • June 15, 2005 at 2:52 am

    #167170

    I am getting the following error: Server: Msg 3721, Level 16, State 1, Line 14 with no other information with the following T-SQL.

    alter table MyTable disable trigger MyTableTrigger

    This error message is not in the sysmessages table and googling it returns no results!

    Has anyone come across this before?

  • June 15, 2005 at 3:35 am

    #565595

    Well it seemed that it was a naming problem...

    alter table dbo.MyTable enable trigger MyTableTrigger

    works

  • June 15, 2005 at 4:57 am

    #565615

    How bizarre. I too tried Googling on it (specifically on "Server: Msg 3721" including the quotes) and got one result. Seems like this guy had the same problem, but it's of little use unless you know and speak whatever language that is!

  • July 19, 2006 at 1:18 pm

    #650209

    I got the same error message this morning.  In desperation I finally examined the table on which the trigger exists (which I disabled and enabled using the alter table statement). 

    Sad to say, someone deleted the trigger from the table without telling me.  Could that be one of the sources of the error?

    Thanks.

  • July 19, 2006 at 1:35 pm

    #650222

    I just found this on the MSDN forums:

    http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=249401&SiteID=1

    It's 2005 but there may be something useful for you

  • July 19, 2006 at 2:05 pm

    #650236

    Absolutely, if the trigger is not there you will get the error

     


    * Noel

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply