Prep

[sauve mark]

exec sp_prepare

[sauve mark]

Sorry guys,

It seems that Prepare command does not work for me, I'm using the following
code:

SqlCommand Cmd = new SqlCommand("SprocName", DBConnection);
Cmd.CommandType = CommandType.StoredProcedure;

Cmd.Parameters.Clear();
Cmd.Parameters.Add("@Param1", SqlDbType.BigInt, 0).Value = x
Cmd.Parameters.Add("@Param2", SqlDbType.VarChar, 128).Value = x
....

CmdMessage.Prepare();
Cmd.ExecuteNonQuery();

In SQL Profiler I'm excepting to see
exec sp_prepare ... command but this is not the case, I cann see only the
exec sproc statement

Is this is a normal behaviour and Prepare() method works only for Queries
not for sprocs or am I missing something ?

Thank you a lot for your help

[Dave Sexton]

Hi,

"If CommandType is set to StoredProcedure, the call to Prepare should
succeed, although it may cause a no-op."

"SqlCommand.Prepare Method"
http://msdn2.microsoft.com/en-gb/lib...d.prepare.aspx

--
Dave Sexton

"sauve mark" <sa*******@yahoo.comwrote in message
news:uQ**************@TK2MSFTNGP02.phx.gbl...

Sorry guys,

It seems that Prepare command does not work for me, I'm using the
following code:

SqlCommand Cmd = new SqlCommand("SprocName", DBConnection);
Cmd.CommandType = CommandType.StoredProcedure;

Cmd.Parameters.Clear();
Cmd.Parameters.Add("@Param1", SqlDbType.BigInt, 0).Value = x
Cmd.Parameters.Add("@Param2", SqlDbType.VarChar, 128).Value = x
...

CmdMessage.Prepare();
Cmd.ExecuteNonQuery();

In SQL Profiler I'm excepting to see
exec sp_prepare ... command but this is not the case, I cann see only the
exec sproc statement

Is this is a normal behaviour and Prepare() method works only for Queries
not for sprocs or am I missing something ?

Thank you a lot for your help