Submit My Question - Recent Questions - Recent Answer
Msdn Tech >> SQL Server >> SQL Server Tools General

Can't see trigger in Management Studio

Hello.

I've just created a database trigger, It's in sys.triggers and it works but it's not showing under programmability > Database Triggers of the database that I created it in. Anyone know why this is?

Thanks

[253 byte] By [bobbins] at [2008-1-10]
«« How To pass a resultset to a function
»» Please Help me to read the value from all column in grid view
# 1
The trigger is there and in effect, it's just a GUI problem. Try right clicking on the Database Triggers folder in Management Studio and selecting Refresh. If that doesn't work, do the same for the Programmability folder.

HTH...

Joe

JoeWebb at 2007-10-3 > top of Msdn Tech,SQL Server,SQL Server Tools General...
# 2
Tried that already and it's still not showing, not overly concerned but it would be nice if it showed up! Thanks
bobbins at 2007-10-3 > top of Msdn Tech,SQL Server,SQL Server Tools General...
# 3

Which version and service pack are you on? I can't recreate your problem....

Buck Woody

BuckWoody-MSFT at 2007-10-3 > top of Msdn Tech,SQL Server,SQL Server Tools General...
# 4
standard edition SP1, odd isn't it?
bobbins at 2007-10-3 > top of Msdn Tech,SQL Server,SQL Server Tools General...
# 5
I recommend you to updated to last service pack.
EmanuelPeixoto at 2007-10-3 > top of Msdn Tech,SQL Server,SQL Server Tools General...
# 6

see the link below:

http://www.microsoft.com/downloads/details.aspx?FamilyID=d07219b2-1e23-49c8-8f0c-63fa18f26d3a&DisplayLang=en

EmanuelPeixoto at 2007-10-3 > top of Msdn Tech,SQL Server,SQL Server Tools General...
SQL Server
SQL Server Tools General

SQL Server Hot Topic

SQL Server New Topic

SQL Server

Java / MSDN / Linux Tech / PHP Tech / MSDN DotNet / MSDN TECH / Health Library / Programmers Tech / visual basic Tech / Developer Tech / Ipod faqs / Msdn China Tech

Site Classified