Click to See Complete Forum and Search --> : Where to create SQL Server 2005 Trigger


carsonweb
01-23-2007, 02:04 PM
I am a trigger beginner.
I want to create a trigger, but after right-clicking each table, database... I didnot see "new trigger" on the popup window? Where to create a trigger in SQL Server management studio? Or my version doesnot support trigger? I searched online but didnot find discussion about the trigger support and Sql server version.

Thanks in advance.

russell
01-23-2007, 03:08 PM
in the query editor in SSMS. right-click database, click "new query"

carsonweb
01-23-2007, 04:22 PM
Thank you very much. I successfully created a trigger using your way.

The link
http://www.aspfree.com/c/a/MS-SQL-Server/Trigger-Management/2/
shows "To create a new trigger on the table, right-click the trigger’s subnode of the table and choose New Trigger from the pop-up menu. SQL Server
initially fills the form with a template for creating a new trigger."

I was wondering how to bring up "new trigger" pop-up menu.