Is transaction name has to be unique?

Hi

I remember that once I had a problem when using a cursor in a sp and when several instances of the sp were running I had a problem when the first sp in the sequence deallocated the cursor and all the other who run in parallel had errors...
Well, this is not the problem now, but my question is, if I have a sp that has begin tran t1, and several instances of the sp are running in parallel, and each of course has begin tran t1, should I expect the same collision effect like with the cursor? Is every tran has to be with unique name? Or maybe the server knows how to manage this and when one tran has started and another sp tried to start another with the same name it makes it wait until the first one committed or rolled back?

Thanks,
Inon.I would think that this would be a particularly bad idea, though I have no specific experience in this area (transaction numbers). As I always understood it, the idea behind an explicitly identified transaction was to be able to roll back that specific transaction, particularly in an asynchronous environment. You have to ask yourself, what is the value in re-using the same transaction identifier? If you are just going to re-use the same identifier, then why bother with an identifier at all?

Regards,

hmscott

Is this the right place for a question about creating a report in VB.net?

I am working in a new environment and I only have a fraction of the BI Project
Templates when I create a new Project. I remember loading these the first time
I worked in here, but don't remember where I loaded them from. Can someone tell
me, or guide me to something that will refresh my memory about creating reports
in VS.NET 2005, for SQL 2005. Thanks...when you click File, New Project, you should have a Business Intelligence
Project grouping that contains Report Server Project Wizard, Report Server
Project, Report Model Project, and possible Analysis Service Project,
Integration Service Project and Import Analysis Service 9.0 Database.
"WANNABE" <SameAsB4> wrote in message
news:OsOdrS0wHHA.3944@.TK2MSFTNGP06.phx.gbl...
>I am working in a new environment and I only have a fraction of the BI
>Project
> Templates when I create a new Project. I remember loading these the first
> time
> I worked in here, but don't remember where I loaded them from. Can
> someone tell
> me, or guide me to something that will refresh my memory about creating
> reports
> in VS.NET 2005, for SQL 2005. Thanks...
>|||Try reinstalling the BI studio. If you installed VS (or VB.Net 2005) after
BI Studio then you lost the integration with VS.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Dean" <deanl144@.hotmail.com.nospam> wrote in message
news:Ook4sJJxHHA.4668@.TK2MSFTNGP06.phx.gbl...
> when you click File, New Project, you should have a Business Intelligence
> Project grouping that contains Report Server Project Wizard, Report Server
> Project, Report Model Project, and possible Analysis Service Project,
> Integration Service Project and Import Analysis Service 9.0 Database.
>
> "WANNABE" <SameAsB4> wrote in message
> news:OsOdrS0wHHA.3944@.TK2MSFTNGP06.phx.gbl...
>>I am working in a new environment and I only have a fraction of the BI
>>Project
>> Templates when I create a new Project. I remember loading these the
>> first time
>> I worked in here, but don't remember where I loaded them from. Can
>> someone tell
>> me, or guide me to something that will refresh my memory about creating
>> reports
>> in VS.NET 2005, for SQL 2005. Thanks...
>>
>sql

Is there an OWC forum here or anywhere?

“It is helpful to remember that this forum is mainly for issues that directly pertain to the Visual Studio Tools for Office tools per se. So you will be best served by posing this question to a forum or newsgroup wholly dedicated to application-specific issues such as yours. Here is a link to resources that will help you: http://msdn.microsoft.com/office”

Thanks,

George

Hi,friends, please help me. I can't find out an OWC forumn here. Many people have interest in OWC and asked some questions. But the answer is always that here is not an OWC forum.

MMM....

Is there an OWC forum here or anywhere?

Anyone could give me a tip? thanks!