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,

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 Removed)

"Jason Huang" <(E-Mail Removed)> wrote in message
news:%23XWOa%(E-Mail 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[i].Transaction,
> TestCommand[i].ExecuteNonQuery().
> Will this cause problems in our SQL Server 2000? What should I pay
> attention to?
> Thanks for help.
>
>
> Jason
>
>

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]" <(E-Mail Removed)> ¼¶¼g©ó¶l¥ó·s»D:(E-Mail Removed)...
> 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 Removed)
>
> "Jason Huang" <(E-Mail Removed)> wrote in message
> news:%23XWOa%(E-Mail 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[i].Transaction,
>> TestCommand[i].ExecuteNonQuery().
>> Will this cause problems in our SQL Server 2000? What should I pay
>> attention to?
>> Thanks for help.
>>
>>
>> Jason
>>
>>
>
>