named transaction

Hi,
I need to make sure i do not open second transaction if one is already
opened,
i wanted to name a transaction, but how can i cjeck if a transaction with
that name is already open?
mndreu
On Mon, 7 Feb 2005 09:20:43 +0100, Malgorzata Ndreu wrote:

>Hi,
>I need to make sure i do not open second transaction if one is already
>opened,
Hi mndreu,
Check @.@.TRANCOUNT.

>i wanted to name a transaction, but how can i cjeck if a transaction with
>that name is already open?
If @.@.TRANCOUNT is 0, no transaction at all is open.
If @.@.TRANCOUNT is > 0, I know of no way to check if the open transactions
are named and what their names are.
Best, Hugo
(Remove _NO_ and _SPAM_ to get my e-mail address)

My store procedure returns 2 grids HELP

How do I access the 2nd grid/table in my report?
Basically I have a SP that has a SUM in one grid. The second grid
cotains the data I want to display in RS. Is there a way to get to the
2nd grid without altering the store procedure(Its being used on another
report)?
regards,
Stas K.I just found a similar topic where it says I cannot do this.
Any ideas?|||No, RS can only take a single resultset.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Sorcerdon" <sorcerdon@.gmail.com> wrote in message
news:1136923749.664965.81380@.z14g2000cwz.googlegroups.com...
> How do I access the 2nd grid/table in my report?
> Basically I have a SP that has a SUM in one grid. The second grid
> cotains the data I want to display in RS. Is there a way to get to the
> 2nd grid without altering the store procedure(Its being used on another
> report)?
> regards,
> Stas K.
>