DataBase trigger

[Tony Johansson]

Hello!

I log in to SqlServer 2005
I right click on the database and select new Query.
Here I enter the create trigger command shown below and then click on the !
to run the command
The output was Command(s) Completed successfully
When I know look in folder Database Trigger within Programmability I can't
find the created trigger.

If I try to run the create trigger command again I get an error saying
"Msg 2714, Level 16, State 2, Procedure CategoryDelete, Line 4
There is already an object named 'CategoryDelete' in the database."

So my question is where can I find the trigger that I have created ?

create trigger CategoryDelete
on Categories
for delete as
update Products SET Discontinued = 1
FROM Products INNER JOIN Deleted ON
Products.CategoryID = Deleted.CategoryID

//Tony

 

[Tony Johansson]

You would goto the SQL Server Manager, go to the table and expand the
nodes where you will see the 'Trigger' node.

many thanks!!

 

[Arne Vajhøj]

many thanks!!

That solution is probably the easiest.

But you can retrieve the information from C# as well!



Arne