I am trying to find a way, either through VS or using SMSS, to debug a stored procedure. I can use print statements, etc. but I am trying to use real debugging methods. Breakpoints, Step into, etc. Notes: I have all versions of SMSS and VS and the DB is on a 2005 SQL server, no linked servers.
I have followed a number of google articles and am getting more frustrated. Any help would be appreciated.