Can Execute trigger in SQL Server 2008 R2 I'm trying to create a simple trigger to update a table's column after it was inserted. 

But when I execute the trigger it produces an error:


  Cannot execute script. Additional information: Unable to start
  Transct-SQL debugger. The Transact-SQL debugger does not support SQL
  Server 2005 or earlier versions of SQL Server. (SQLEditors)


I'm using SQL Server 2008 R2.

Here's my simple trigger just to check if it execute.

CREATE TRIGGER tgrCheckFile 
ON CheckFile
FOR INSERT
AS  
        PRINT 'New Check has been issued'
I'd put this in a comment but I want to give pictures.

My guess is that you are hitting the little green arrow, or DEBUG button



Instead of the red exclamation point, or RUN button.



It's a fairly common mistake.  FYI you can also hit Ctrl-E to "execute" the script or Alt-F5 to "debug" it.  The TSQL debugger requires elevated rights (sysadmin if I remember correctly) and as you saw doesn't work in versions prior to 2008.