SQL Server Express 'NEW TRIGGER' BUTTON IS DISABLED

user3541569 picture user3541569 · May 14, 2014 · Viewed 26.6k times · Source

I am new to SQL Server Express and I want to create a new trigger on my table.

But I found that the 'New trigger' button in my table's trigger folder shows Disabled. When I right click on trigger folder it shows 'New trigger' button disabled and in gray color.

I am using SQL Server 2014 Express and Management Studio 2014.

Does anybody have any idea why it is happening?

Please suggest me some way out.

Answer

NG. picture NG. · Nov 12, 2014

This a known issue (bug) with SSMS 2014.

Reference : https://connect.microsoft.com/SQLServer/feedback/details/873249/ssms-2014-new-trigger-is-disabled-for-older-2012-2008r2-versions-of-sql-server

Alternately, you can use something like :

CREATE TRIGGER TriggerName
    ON [dbo].[TableName]
    FOR DELETE, INSERT, UPDATE
    AS
    BEGIN
    SET NOCOUNT ON
    END