Good news :
http://blogs.msdn.com/buckwoody/archive/2008/04/25/sql-server-2008-management-improvements-t-sql-debugger.aspxPicked up a copy at the Heros Happen Here thing - may actually install it now. (Of course I'm sure the developers edition is available for $50 or so)
>>>>Note, this only works in certain editions of VS. In the edition I have (standard edition, thanks to you ), I don't see an option to debug SP.
>>>>
>>>>And apparently there is no such option in SQL Server itself if I'm not mistaken (I'd love to be).
>>>
>>>It may only be in VS Pro editions (I've never used standard).
>>>
>>>The VS debugger is the only way I found to do it for SQL2005 - nice marketing ploy for MS eh?
>>>
>>>FWIW it works well (actually I haven't had to use the debugger in a while - must be my perfect code .. ahem..).
>>
>>I believe SQL Server should have this ablity in itself, not using extra tool. Hopefully new version of SQL Server will address this lack.
>
>I agree completely. I haven't tried SQL 2008 to see if that has been addressed, but I hope it is.
Charles Hankey
Though a good deal is too strange to be believed, nothing is too strange to have happened.
- Thomas Hardy
Half the harm that is done in this world is due to people who want to feel important. They don't mean to do harm-- but the harm does not interest them. Or they do not see it, or they justify it because they are absorbed in the endless struggle to think well of themselves.
-- T. S. Eliot
Democracy is two wolves and a sheep voting on what to have for lunch.
Liberty is a well-armed sheep contesting the vote.
- Ben Franklin
Pardon him, Theodotus. He is a barbarian, and thinks that the customs of his tribe and island are the laws of nature.