#10594: Alter Trigger option is missing in script object drop down list

ashwini.chavan reported 2013-10-25T09:44:40Z · last modified 2014-06-24T20:27:09Z

Alter Trigger option is missing in script object drop down list

Dev	tariqrahiman
QA	tariqrahiman

Priority	Low
Complexity	Unknown

Component	Script Object
Version	Future - 0.1

Aqua Data Studio 14.0.3

Database- MS SQL Server 2012

1.I have created database trigger as follows:

CREATE TRIGGER "Trigger_on_table"

ON DATABASE

FOR DROP_TABLE,ALTER_TABLE

PRINT 'You must disable Trigger "safety" to drop or alter tables!'

ROLLBACK

Trigger is created successfully.

2.Right click on trigger & select Script Object to Window As->Only Create & Drop options are display in drop down list->Alter Trigger option is missing.

We can Alter database trigger through Query analyzer please refer screenshot(Alter_trigger_QA.jpg)

2 attachments

Alter_tigger.jpg

2013-10-25T09:44:40Z

251 KB
Alter_trigger_QA.jpg

2013-10-25T09:44:40Z

299 KB

All Comments (2) Change History

tariqrahiman 2013-10-28T21:46:09Z

Is this only for SQL Server 2012 ? What versions support Alter Trigger ? Can you attach version-wise breakdown of the DDL . For e.g sample ddl to replicate in SQL Server 2012, 2008, 2005, 2000 etc...

ashwini.chavan 2013-10-30T06:51:28Z · (edited)

1.Trigger on a CREATE, ALTER, DROP, GRANT, DENY, REVOKE, or UPDATE statement(DDL Trigger) in MS SQL Server 2012

Syntax:

ALTER TRIGGER trigger_name

ON { DATABASE | ALL SERVER }

[ WITH <ddl_trigger_option> [ ,...n ] ]

{ FOR | AFTER } { event_type [ ,...n ] | event_group }

AS { sql_statement [ ; ] | EXTERNAL NAME <method specifier>

[ ; ] }

} <ddl_trigger_option> ::=

[ ENCRYPTION ]

[ <EXECUTE AS Clause> ]

<method_specifier> ::=

assembly_name.class_name.method_name

Please refer link: http://technet.microsoft.com/en-us/library/ms176072.aspx

2.Trigger on a CREATE, ALTER, DROP, GRANT, DENY, REVOKE, or UPDATE statement(DDL Trigger) in MS SQL Server 2008

Please refer link: http://technet.microsoft.com/en-us/library/ms176072(v=sql.100).aspx

3.Trigger on a CREATE, ALTER, DROP, GRANT, DENY, REVOKE, or UPDATE statement(DDL Trigger) in MS SQL Server 2005

Please refer link: http://technet.microsoft.com/en-us/library/ms176072(v=sql.90).aspx

4.We can not create Database Trigger in MS SQL Server 2000

Search Tips

Aqua Data Studio / nhilam

Alter Trigger option is missing in script object drop down list

2 attachments

Issue #10594

Completion

Search Tips

Aqua Data Studio / nhilam

Title

Alter Trigger option is missing in script object drop down list

2 attachments

Issue #10594

Completion