One for the geeks out there ...
What's the best way to debug stored procedures in SQL Server 2005? I heard that it can be done in Visual Studio 2005, but I haven't quite been able to get it to work. I'm not sure if that's because I've got it set up the wrong way, but I couldn't insert any breakpoints or access any sort of Step Into function, which made it difficult.
What do other people use?
I couldn't get this work either in Visual Studio and I believe you need a special edition of VS to get this to work..
http://msdn.microsoft.com/en-us/library/s4sszxst%28VS.80%29.aspx
I used to debug SPs with DBArtisan but that's been years ago, but it might be an option.
John