M
MarkusJNZ
Hi, I have a problem with a stored procedure which is executed via an
SqlCommand object using command parameters to pass in the info.
e.g.
SqlCommand cmd = new SqlCommand();
// Add in attributes, connect to database here
// ....etc
cmd.ExecuteNonQuery();
There is a problem when the above call is made and I need to track it
down, I think there is a trigger on one of the tables but I need to
make sure.
Is it possible to step into the Stored Procedure call via VS2005 (We
are using MSSQL2005) and see what's happening? Failing that can I get a
dump of the stored procedure and all the cmd parameter values which are
getting passed in so I can manually run it?
I can set a debug point and inspect the cmd parameter variables via the
debugger but the SP takes in over 30 parameters and manually copying
them from the debug info would take a long time.
TIA
MArk
SqlCommand object using command parameters to pass in the info.
e.g.
SqlCommand cmd = new SqlCommand();
// Add in attributes, connect to database here
// ....etc
cmd.ExecuteNonQuery();
There is a problem when the above call is made and I need to track it
down, I think there is a trigger on one of the tables but I need to
make sure.
Is it possible to step into the Stored Procedure call via VS2005 (We
are using MSSQL2005) and see what's happening? Failing that can I get a
dump of the stored procedure and all the cmd parameter values which are
getting passed in so I can manually run it?
I can set a debug point and inspect the cmd parameter variables via the
debugger but the SP takes in over 30 parameters and manually copying
them from the debug info would take a long time.
TIA
MArk