Is there any native tools for simple step mode through a purely TSQL
procedure? I'm rather new to stored procedures. I've managed to figure this
out with query analyzer 2000 but haven't figured out what to use with SQL
Server 2005

You need to use Visual Studio 2005 for T-SQL debugging.
There isn't a tool built in on the SQL Server end of things
for debugging.
In Visual Studio 2005, this should get you started:
http://msdn2.microsoft.com/en-us/library/zefbf0t6(VS.80).aspx

-Sue

On Mon, 12 Feb 2007 16:26:10 -0700, "Dave Patrick"
<DSPatrick@nospam.gmail.com> wrote:

Show quoteHide quote

Ok. thanks Sue. I was afraid of that. That's quite a price to pay for
debugging when it was free in the last version.

Show quoteHide quote

Yup...leaving it out wasn't good. A lot of others agree and
it's planned for the next release:
http://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=124550

-Sue

On Mon, 12 Feb 2007 20:57:19 -0700, "Dave Patrick"
<DSPatrick@nospam.gmail.com> wrote:

Show quoteHide quote

http://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=124550

If only they published the debugging interface, third party tool developers
could jump in :(


Show quoteHide quote

Thanks for the link, just now voted!

Show quoteHide quote

Dave Patrick (DSPatrick@nospam.gmail.com) writes:
Yeah, had you only been able to get it to work!

OK, for the local server there were usually any problems. But with firewalls
everywhere and admin locking down accounts, it was about impossible to get
it to work anyway. These days, I'm using SELECT and PRINT these days to see
what is going on. You can't peek inside temp tables in the debugger. (At
least you couldn't in SQL 2000.)

Profiler: SQL:StmtRecompile - EvenSubClass definitions?
SQL Server Management Studio - long names in tabs
Help with SQL 2005 and Sourcesafe 6
SSIS and polling
xml viewer