In SQL Server Management Studio 2014, the New Trigger menu option is disabled -

i want add new trigger table. seen in picture, new trigger button not active. new index, new column, new contraints, new statics active.

i not understand problem.

you don't need use menu item create trigger. open query window , write create trigger statement there.

to syntax can use snippet in editor. right click on surface of query editor , select insert snippet , select trigger , create trigger following code snippet inserted editor.

create trigger triggername     on [dbo].[tablename]     delete, insert, update         begin     set nocount on     end 

the menu item (if work) same thing use template looks this:

-- ================================================ -- template generated template explorer using: -- create trigger (new menu).sql -- -- use specify values template parameters  -- command (ctrl-shift-m) fill in parameter  -- values below. -- -- see additional create trigger templates more -- examples of different trigger statements. -- -- block of comments not included in -- definition of function. -- ================================================ set ansi_nulls on go set quoted_identifier on go -- ============================================= -- author:      <author,,name> -- create date: <create date,,> -- description: <description,,> -- ============================================= create trigger <schema_name, sysname, schema_name>.<trigger_name, sysname, trigger_name>     on  <schema_name, sysname, schema_name>.<table_name, sysname, table_name>     after <data_modification_statements, , insert,delete,update>  begin     -- set nocount on added prevent result sets     -- interfering select statements.     set nocount on;      -- insert statements trigger here  end go