Trouble creating triggers in SQL Server 2005

[satchi]

Ok this should be a simple question but it's seemingly difficult (or something's wrong w/ my SQL Server Managmenet Sudio). I have created new triggers in SQL Server 2000 by clicking on Managing Triggers and saving them.

I have found the node for Triggers in SQL Server 2005's Management Studio and tried to create a 'New Trigger...' but when I save, it saves it to an .sql file but do not attach it to the table.

What am I doing wrong here? I can't seem to attach it. And where is this Assisted Editor ...i can't seem to find it anywhere.

Thanks in advance.

[satchi]

Ok this is just stupid of me. Aparently I was figuring out how to find the 'attach to table' button and didn't 'refresh'. It seems I need to Execute the create trigger code as well.

[NJ5]

Ok this is just stupid of me. Aparently I was figuring out how to find the 'attach to table' button and didn't 'refresh'. It seems I need to Execute the create trigger code as well.

I have the same problem, why I can't find "attach to table " button
I spend several hours, still can't find. can someone can help me how to save trigger into table?

[Advanced Sql Tools]

I have the same problem, why I can't find "attach to table " button
I spend several hours, still can't find. can someone can help me how to save trigger into table?

Hi - I have written an add-in for Sql Server Management Studio to create and edit triggers - you can get a trial from www.advancedsql tools.co.uk/Download.aspx - email me if you would want to use it and i'll arrange for a license for you.


Ed

ed @ Advanced Sql Tools dot Co dot Uk