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.Transaction, TestCommand.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?

 

[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's ExecuteNonQuery
fails, the Rollback in the SQL Server has some problems and the whole SQL
Server 2000 just hanged.

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]
- (e-mail address removed)

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.Transaction,
TestCommand.ExecuteNonQuery().
Will this cause problems in our SQL Server 2000? What should I pay
attention to?
Thanks for help.


Jason