tags:

views:

19

answers:

2
Q: 

about triggers in sql server 2008 and 2007

Hi I need triggers window how can i find it in the sql server 2008 and 2007? thanks

A: 

In SQL Server Management Studio, connect to your database and expand the node [YourDatabase]->Programmability->Triggers. If you right-click that folder, Management Studio will give you options to generate script templates for both create, modify and remove triggers.

Tomas Lycken  2010-07-26 06:56:55
I have right clicked that folder but nothing will happen! [mydatabase]-->Programmability-->database triggers and when I right click on this folder it will show "refresh"
 2010-07-26 07:02:14
+1  A: 

Shortcut for the Template Explorer is : Ctrl + Alt + t in that you can get template for trigger of sql

Pranay Rana  2010-07-26 06:57:24
thanks a lot for your answer
 2010-07-26 07:07:39

related questions

In WPF Style, How can Trigger access a son Element of the Element it is attatched
How to constrain a database table so only one row can have a particular value in a column?
Can you use routed events with a MultiTrigger?
T-SQL - Is there a way to disable a trigger in the scope of a transaction?
Perforce trigger to deny submission of unchanged files?
Triggers vs Constraints
Using WPF, what is the best method to update the background for a custom button control?
Javascript: Trigger action on function exit
Database Duplicate Value Issue ( Filtering Based on Previous Value)
Best Method to Spawn Process from SQL Server Trigger
How to check if a trigger is invalid?
SQL - How do you compare a CLOB
SQL Server 2005 multiple database deployment/upgrading software suggestions
MySQL triggers + replication with multiple databases.
T-SQL triggers firing a "Column name or number of supplied values does not match table definition" error
How do you priortize multiple triggers of a table?
MySQL Trigger & Stored Procedure Replication
Setting Up MySQL Triggers
How can I get the definition (body) of a trigger in SQL Server?
PLS-00306 error on call to cursor
Trigger without a transaction?
Database triggers
Building an auditing system; MS Access frontend on SQL Server backend.
Timer-based event triggers
Throw Error In MySQL Trigger