 | |
More questions on triggers
comp.databases.ms-sqlserver comp.databases.ms-sqlserver
 |
| | Thread Tools | Display Modes |
#11
 
| |||
| |||
|
Re: More questions on triggers -
04-27-2011
, 09:36 AM
|
Dom wrote: 1. *Where are triggers shown on the Object Explorer in SSMS? *I thought they would be listed under "Programmability ... Database Triggers" but they aren't there. No, they're not there. They are listed within each table node, along with the columns,keys, constraints and indexes. I guess the thinking is that they are table objects, not database objects, so just as you don't have a node to show all the indexes in the database, neither do you have a node to show all triggers. You have to expand the individual table nodes. 2. *Is there a GUI to create a trigger, like there is to create a table? *I've been using straight SQL for this. No. If you right-click a trigger *in the Triggers node and select New Trigger, it will open a query window with the script from a trigger-creation template. 3. *How do you modify a trigger? *I've been using sp_helptrigger to get the trigger name (since I can't find it anywhere in SSMS), and then sp_helptext to get the SQL of the trigger. Right-click a trigger in the Triggers node and select Modify |
triggers" node is all about?
#12
| |||
| |||
|
|
Dom wrote: 1. Where are triggers shown on the Object Explorer in SSMS? I thought they would be listed under "Programmability ... Database Triggers" but they aren't there. No, they're not there. They are listed within each table node, along with the columns,keys, constraints and indexes. |
1. DML triggers are located under the Table node
2. DDL triggers are located under the Database node
http://www.hvandenberg.net/SSMSTree.jpg shows part of my setup.
Best,
Henk
#13
| |||
| |||
|
|
On 27-04-2011 16:24, Bob Barrows wrote: Dom wrote: 1. *Where are triggers shown on the Object Explorer in SSMS? *I thought they would be listed under "Programmability ... Database Triggers" but they aren't there. No, they're not there. They are listed within each table node, along with the columns,keys, constraints and indexes. There's actually two places where you can find triggers. 1. DML triggers are located under the Table node 2. DDL triggers are located under the Database node http://www.hvandenberg.net/SSMSTree.jpgshows part of my setup. Best, Henk |
#14
| |||
| |||
|
|
And that answers my last question! Thanks to everyone. |
your original post.
Since you mentioned the database-trigger, I thought that you were
working on DDL-triggers.
Duh! If only I had realised that earlier, I'd have answered the question
that was being asked...
#15
| |||
| |||
|
|
1. Where are triggers shown on the Object Explorer in SSMS? I thought they would be listed under "Programmability ... Database Triggers" but they aren't there. |
Programmability is for DDL trggiers.
Quote:
|
2. Is there a GUI to create a trigger, like there is to create a table? I've been using straight SQL for this. |
a piece of crap.
Quote:
|
3. How do you modify a trigger? I've been using sp_helptrigger to get the trigger name (since I can't find it anywhere in SSMS), and then sp_helptext to get the SQL of the trigger. |
control. In that case it's simple. You go to your version-control system
and check it out. Yeah, you can script things from the database, but
that is like disassembling your object files to edit your C# code.
--
Erland Sommarskog, SQL Server MVP, esquel (AT) sommarskog (DOT) se
Links for SQL Server Books Online:
SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx
SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx
|
« Previous Thread
|
Next Thread »
| Thread Tools | |
| Display Modes | |
Linear Mode
| |
Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.