SET SHOWPLAN_ALL - Dynimic Subtree Cost

im try to get the subtree cost (sql server 2000) back from a dynimic sql query that i build on the fly.. the sql query is:

 

SET SHOWPLAN_ALL ON
GO
select * from mp_Contacts Where FirstName = 'Jason' --my query
GO
SET SHOWPLAN_ALL OFF
GO
GO

 

the c# code is:

<code>

Decimal HoldSubTree;

// Make Connection

SqlConnection FindSubTree = new SqlConnection(Utilities.GetCRMEnvironment());

//Sql Connection

System.Text.StringBuilder SHOWPLANALLON = new System.Text.StringBuilder("SET SHOWPLAN_ALL ON");

System.Text.StringBuilder SHOWPLANALLOFF = new System.Text.StringBuilder("SET SHOWPLAN_ALL OFF");

System.Text.StringBuilder SubTreeSql = new System.Text.StringBuilder(MySqlString.ToString() + " ");

// Grab the data and fill the dataset

SqlCommand SubTreemyCommand = new SqlCommand(SHOWPLANALLON.ToString(), FindSubTree);

SubTreemyCommand.CommandTimeout = 90;

SubTreemyCommand = new SqlCommand(SubTreeSql.ToString(), FindSubTree);

SubTreemyCommand.CommandTimeout = 90;

SqlDataAdapter SubTreemyDA = new SqlDataAdapter();

SubTreemyDA.SelectCommand = SubTreemyCommand;

DataSet SubTreemyDS = new DataSet();

SubTreemyCommand = new SqlCommand(SHOWPLANALLOFF.ToString(), FindSubTree);

SubTreemyCommand.CommandTimeout = 90;

try

{

SubTreemyDA.Fill(SubTreemyDS);

</code>

and the result: it bring back the rows of data from the dynimic query instead of the subtree cost..

how could i send 3 statements to the sql database but all in the same transaction.. for example:

first the server would switch modes:

"SET SHOWPLAN_ALL ON"

then i would send it my query:

"select * from mp_Contacts Where FirstName = 'Jason' "

and then switch the server back over:

"SET SHOWPLAN_ALL OFF"

Is this possible??  ideas??