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.
This a known issue (bug) with SSMS 2014.
Alternately, you can use something like :
CREATE TRIGGER TriggerName
ON [dbo].[TableName]
FOR DELETE, INSERT, UPDATE
AS
BEGIN
SET NOCOUNT ON
END