In SSMS, are you pressing the Green Triangle, or the Red Exclamation Point?
The Green Triangle is to run in Debug mode, the Red Exclamation Point executes the query. You want to do the Red Exclamation Point...;-)
Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes