possible to step into a stored procedure

[neverstill]

Hi-

when debugging, is it possiblt to step into a stored procedure? For
example, if I have a method in my DAL class called AddProduct() and it makes
a call to SqlCommand.ExecuteNonQuery() can I step into that sproc that it
will be calling? I hope so, that would be the coolest!

OK, if this is possible and you know how, please do share.
Thanks,
Steve

 

[Brad Williams]

Project | Properties | Configuration Properties | Debugging | Enable SQL
Debugging = true

Brad Williams

 

[Éric Moreau]

It depends of your edition of VS.Net and the version of SQL Server and your
permissions on the SQL Server.

Read
http://msdn.microsoft.com/library/d...s/vsdebug/html/vxlrfsettingupsqldebugging.asp

--

HTH

Éric Moreau, MCSD
Conseiller Principal / Senior Consultant
Concept S2i inc.(www.s2i.com)

 

[William Ryan]

Depending on what VS (even the old versions will work if you have the right
versions) you use yes, but be warned, don't do it on a production box - it
will probably get ugly!