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

[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

 

[Guest]

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!
***************************

 

[jens Jensen]

Many thanks
JJ