vb.net + SQL 's store procedure

[Agnes]

I run a simple SP in through my vb.net program.
Does any way I can read the "execution Plan" ???

Or. I need to read it by using SQL anaylzer ?, thanks

 

[Cor Ligthert]

Agnes,

A SP has only a very small effect on your VBNet application

While it is almost not important.

The only thing you tell in that application that the SQL strings are not
provided by the program however by the stored procedures.

For the rest everything is the same.

I would forever go for first (in the develloping process) use the SQL
strings in my program and than at production time change them (place them
in) for stored procedures. That gives me the most flexibility.

I hope this helps?

Cor