SQL Server 2008 Debugging

To debug T-SQL scripts in SQL Server 2008 R2 Management Studio, you need to be in the sysadmin role and logged in as a sysadmin.  The other requirement is that when you connect to SQL Server you must use the format ‘FULL_COMPUTER_NAME\INSTANCE_NAME’.  Using the format ‘.\INSTANCE_NAME’ will prevent you from being able to debug.