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 |
|
cajina
Starting Member
15 Posts |
 Posted - 2008-02-25 : 14:14:56
|
| Why I can't see my Triggers in SQLServer 2005 but I can delete them and they can be executed?I need to know how many triggers I have? or Which triggers exist in the server just by clicking the folder?.Somebody knows why? |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2008-02-25 : 14:32:34
|
Aren't triggers in the TRIGGERS folder beneath the "TableName" folder?
E 12°55'05.25"N 56°04'39.16" |
 |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-02-25 : 14:39:50
|
| Try this:masterselect name from sysobjectswhere type='TR' |
|
|
|
cajina
Starting Member
15 Posts |
Posted - 2008-02-25 : 15:00:58
|
| I can see my trigger using a select, But every time I need to see them I have to use a query?Why is it happening?And yes I can see the triggers beneath the table name.Is there not a list of Total Triggers? |
|
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2008-02-26 : 01:29:20
|
quote:
Originally posted by cajina
I can see my trigger using a select, But every time I need to see them I have to use a query?Why is it happening?And yes I can see the triggers beneath the table name.Is there not a list of Total Triggers?
To find total triggers, you need to use queryMadhivananFailing to plan is Planning to fail |
|
|
|
|
|
|
I can't see my triggers