Is there a way i can debug through the Sql script in my SqlDataSource ....

  • Thread starter Thread starter jens Jensen
  • Start date Start date
J

jens Jensen

Hello,
I'm very excited about the new SqlDataSource in asp.net 2.0.

I have written a wuite long sql script on my SqlDatasource UpdateCommand.

I want to see wheater it actually does what it was meant to do.

Is there any way i can do this?

Many thanks
JJ
 
This is a wonderful "it depends" answer type of question.

If you are using VS 2005 with SQL 2005 (Express can work), you can
automagically step through a stored procedure directly from code. It is
easiest if you have code projects.

If not, you can step through any supported database's sprocs by opening the
sproc and choosing intervening at the point of calling (supplying values to
the sproc and running in the GUI). This is not automagic.

--
Gregory A. Beamer
MVP; MCP: +I, SE, SD, DBA

***************************
Think Outside the Box!
***************************
 
Back
Top