MTS Threads

I am wondering how to determine the the number of threads an MTS object can handle, and where you can view this information in the mts explorer.

Thanks

Mike

You should be posting the MTS group not SQL.

http://support.microsoft.com/kb/282490/

MTS Query

Hi,
This is a silly question
1. What the precausions we need to take care while coding a procedure, if we
have an MTS. Do we need to explicitly mention the Transactions in the sps ?
And what about setting the Value of 'XACT_ABORT' .
2. Another situation in the same.
Normally all our master tables will have a curresponding Audit table. and
what we do usually in case we dont have a transaction server is given below
SET XACT_ABORT ON
step 1. Insert into master table
step 2. Insert into Audit table
step 3. Begin Trans
.........
.........
.........
If @.@.ERROR<> 0
rollback trans
step 4. Commit Trans
Now how can i do the same in case we have a transaction server.
thanks and regards
LaraAFAIK, the behaviour might be the same. forget about new lines or any stuff
"lara169" wrote:

> Hi,
> This is a silly question
> 1. What the precausions we need to take care while coding a procedure, if
we
> have an MTS. Do we need to explicitly mention the Transactions in the sps
?
> And what about setting the Value of 'XACT_ABORT' .
> 2. Another situation in the same.
> Normally all our master tables will have a curresponding Audit table. a
nd
> what we do usually in case we dont have a transaction server is given belo
w
> SET XACT_ABORT ON
> step 1. Insert into master table
> step 2. Insert into Audit table
> step 3. Begin Trans
> .........
> ..........
> ..........
> If @.@.ERROR<> 0
> rollback trans
> step 4. Commit Trans
>
> Now how can i do the same in case we have a transaction server.
> thanks and regards
> Lara
>
>

MTS

What is microsoft transaction server and for what it is used?

Hello,

MTS is now known as (included within actually) COM+.

Amonst other things, it is able to coordinate distributed transactions within com+/MTS aware components. In the old days of MTS, you needed to code specifically for MTS, and manually enlist components into a distributed transaction, then register and host these components within an MTS server instance.

Not sure what is required for COM+ nowadays, however a good Googling will soon solve that :)

Cheers,

Rob

sql