How do i attach debugger to Sql 2008 Express edition from Management Studio?
Take a look here:
How to: Debug Transact-SQL Using the SQL Server Management Studio