C# SqlConnection question in SQL Server 2000

[Jason Huang]

Hi,

In our C# windows application, if we build up a SqlCommand array, saying
TestCommand [20].
And in the SqlCommand array, later on we try each TestCommand[0], ...,
TestCommand[19],
by testing the TestCommand[i].Transaction, TestCommand[i].ExecuteNonQuery().
Will this cause problems in our SQL Server 2000? What should I pay
attention to?
Thanks for help.
Jason

[Nicholas Paldino [.NET/C# MVP]]

Jason,

It shouldn't be a problem on SQL Server 2000. Why do you think there
would be a problem? Is there a specific concern you have?
--
- Nicholas Paldino [.NET/C# MVP]
- mv*@spam.guard.caspershouse.com

"Jason Huang" <Ja************@hotmail.com> wrote in message
news:%2******************@TK2MSFTNGP04.phx.gbl...

Hi,

In our C# windows application, if we build up a SqlCommand array, saying
TestCommand [20].
And in the SqlCommand array, later on we try each TestCommand[0], ...,
TestCommand[19],
by testing the TestCommand[i].Transaction,
TestCommand[i].ExecuteNonQuery().
Will this cause problems in our SQL Server 2000? What should I pay
attention to?
Thanks for help.
Jason

[Jason Huang]

Thanks Nicholas.
We have a SqlTransaction MyTrans, it is myConn.BeginTransaction().
All SqlCommand's ExecuteNonQuery on this MyTrans, if it doesn't work, the
MyTrans has to be Rollback.
Sayiny the TestCommand[0], ..., TestCommand[5].

But now the situation is if one of the TestCommand[i]'s ExecuteNonQuery
fails, the Rollback in the SQL Server has some problems and the whole SQL
Server 2000 just hanged.
"Nicholas Paldino [.NET/C# MVP]" <mv*@spam.guard.caspershouse.com> ¼¶¼g©ó¶l¥ó·s»D:O6**************@TK2MSFTNGP05.phx.g bl...

Jason,

It shouldn't be a problem on SQL Server 2000. Why do you think there
would be a problem? Is there a specific concern you have?
--
- Nicholas Paldino [.NET/C# MVP]
- mv*@spam.guard.caspershouse.com

"Jason Huang" <Ja************@hotmail.com> wrote in message
news:%2******************@TK2MSFTNGP04.phx.gbl...

Hi,

In our C# windows application, if we build up a SqlCommand array, saying
TestCommand [20].
And in the SqlCommand array, later on we try each TestCommand[0], ...,
TestCommand[19],
by testing the TestCommand[i].Transaction,
TestCommand[i].ExecuteNonQuery().
Will this cause problems in our SQL Server 2000? What should I pay
attention to?
Thanks for help.
Jason