Dear Lowell,

Thanks for your comments.

Actually I use the "SqlCommand.ExecuteNonQuery Method" in my c# applications. Here is the partial codings in program :

-------------

//program body

....

string [] UpDateCmd = new string[1];

UpDateCmd[0] =

"EXEC master.dbo._PRM_bk 'E:\temp\PRM1005' ";

Trans_Data(UpDateCmd);

if (gUFlag) {

msgLbl.Text = "** Backup Completed **";

} else

msgLbl.Text =

"** Error : Backup Failed **

"+UpDateCmd[0];

}

......

// New Proc: Add,Change,Delete functions with Array

public void Trans_Data(string [] Scmd)

{

string conn_str1="Data Source=localhost;Initial Catalog=master;User Id=sa;Password=xxxx;";

SqlConnection conn = new SqlConnection(conn_str1);

conn.Open();

// Start transaction

SqlTransaction myTrans = conn.BeginTransaction();

// Assign command in the current transaction

SqlCommand cmd = new SqlCommand();

cmd.Connection = conn;

cmd.Transaction = myTrans;

// Execute command

try

{

foreach (string SQLcmd in Scmd)

{

cmd.CommandText=SQLcmd;

cmd.ExecuteNonQuery();

}

myTrans.Commit();

gUFlag=true;

} catch {

myTrans.Rollback();

gUFlag=false;

}

cmd.Connection.Close();

conn.Close();

}

------------

The program result is always failed. But it is okay to run in SQL Query Analyzer. I don't have any idea on this issue.

Thanks again for your help.

Regards,

Edward