Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2005-09-21 : 22:43:49
|
| John writes "I HAVE A BIT OF A PROBLEM, NOT SURE WHATS GOING ON.THERE IS A DAILY BUILD PROCESS WE DO FOR SEVERAL PROJECTS.OUR CURRENT PROCESS WILL DROP THE TRIGGER IF IT EXISTS AND THEN CREATE A NEW ONE. I WOULD LIKE TO CHANGE THE PROCESS SO THAT A NEW TRIGGER WILL ONLY BE CREATED IF IT DOES NOT EXIT OTHERWISE THE TRIGGER WILL BE ALTERED.I WANT MAKE THIS CHANGE TO PRESERVE THE SCHEMA_VER NUMBER FOR ALL THE OBJECTS IN OUR DATABASES.THIS IS HOW I WOULD LIKE TO WORK... BUT ITS THROWING AN ERROR...IF NOT EXISTS(SELECT * FROM DBO.SYSOBJECTS WHERE ID = OBJECT_ID(N'DBO.MY_TEST_TRIGGER') AND OBJECTPROPERTY(ID, N'IsTrigger')=1)CREATE TRIGGER TR_MY_TEST_TRIGGER ON TABLE1FOR INSERTAS .... SOME SQL ...ELSEALTER TRIGGER TR_MY_TEST_TRIGGER ON TABLE1FOR INSERTAS .... SOME SQL ...FOR SOME REASON IT IS THROWING AND ERROR.[Incorrect Syntax neat the keyword'TRIGGER']THIS IS AN EXAMPLE OF WHAT WE CURRENTLY DO:IF EXISTS(SELECT * FROM DBO.SYSOBJECTS WHERE ID = OBJECT_ID(N'DBO.MY_TEST_TRIGGER') AND OBJECTPROPERTY(ID, N'IsTrigger')=1)DROP TRIGGER MY_TEST_TRIGGERGO CREATE TRIGGER TR_MY_TEST_TRIGGER ON TABLE1FOR INSERTAS .... SOME SQL ...THANKS FOR ANY HELP YOU CAN GIVE!" |
|
|
|
|
|
CREATING TRIGGERS