Tuesday, April 01, 2008

How to Stack Trace SQL

Just use SQL Profiler - if it's installed! Open the profiler, connect to a database, File->New. Remember to check the boxes for text query and hit run. Let your code do it's bit, then hit stop. But be quick about it, because there's probably a lot of other stuff going on and (like C# debugging) this could all come jumping out you in a very short space of time.....

No comments:

Post a Comment