POSTED AGAIN- DISTRIBUTED TRANSACTION

Hi,
I have two sql servers with SQL2000 service pack 3 which are linked by the
"Link Server". When i use the "begin tran" (distributed transaction) in
stored procedure, i am getting the following error.
"Server: Msg 8525, Level 16, State 1, Line 1
Distributed transaction completed. Either enlist this session in a new
transaction or the NULL transaction. "
The following article talks about this problem.
http://support.microsoft.com/?kbid=834849
But, both servers are SQL 2000 in my case. Any help?
Thanks,
VijayVijay,
Try rerun the same Instcat.sql described in the kb again on each node. This
will ensure that they have the correct catalog sprocs.
-oj
"Vijay" <vijay@.infosysusa.com> wrote in message
news:%23yRbv$LBFHA.1200@.tk2msftngp13.phx.gbl...
> Hi,
>
> I have two sql servers with SQL2000 service pack 3 which are linked by the
> "Link Server". When i use the "begin tran" (distributed transaction) in
> stored procedure, i am getting the following error.
>
> "Server: Msg 8525, Level 16, State 1, Line 1
> Distributed transaction completed. Either enlist this session in a new
> transaction or the NULL transaction. "
>
> The following article talks about this problem.
> http://support.microsoft.com/?kbid=834849
> But, both servers are SQL 2000 in my case. Any help?
>
> Thanks,
> Vijay
>
>|||I don't think so. It is working for other distributed queries. Any other
solutions please?
Thanks,
Vijay
"oj" <nospam_ojngo@.home.com> wrote in message
news:%23bSADGMBFHA.1076@.TK2MSFTNGP10.phx.gbl...
> Vijay,
> Try rerun the same Instcat.sql described in the kb again on each node.
This
> will ensure that they have the correct catalog sprocs.
> --
> -oj
>
> "Vijay" <vijay@.infosysusa.com> wrote in message
> news:%23yRbv$LBFHA.1200@.tk2msftngp13.phx.gbl...
the
>|||Vijay,
What do you mean "It is working for other distributed queries". If you only
encounter the error on enlisting a distributed transaction, I suggest you
take a look at your linkedserver logins. Also, check to make sure DTC
services are using proper accounts. If they're started under LocalSystem, it
will not have access to network resources. If you are going to make any
changes to your DTC services, you will have to restart SQL server for it to
takes effect.
-oj
"Vijay" <vijay@.infosysusa.com> wrote in message
news:eKKqhVMBFHA.1992@.TK2MSFTNGP10.phx.gbl...
>I don't think so. It is working for other distributed queries. Any other
> solutions please?
> Thanks,
> Vijay
> "oj" <nospam_ojngo@.home.com> wrote in message
> news:%23bSADGMBFHA.1076@.TK2MSFTNGP10.phx.gbl...
> This
> the
>

Possible BUG: SP2 Printing Linked Reports in Report Manager

Hello,
I may have discovered a possible bug with the new SP2 Client Printing
capabilities.
To reproduce:
1) Create a report with margins of 0.3in top, left, bottom and right, and
page size of 8.5 x 11 (standard US letter size)
2) Deploy the report to Report Manager
3) Confirm that client printing respects margins set in report. Click on
the print button, click on Print Preview, click on Margins, you should now
see 0.3in margins all around
4) Create a linked report by going to Properties and clicking Create Link
Report button.
5) Click on the print button, click on Print Preview, click on Margins, you
should now see 0.5in margins all around, instead of 0.3in. This does not
occur while exporting linked report to PDF format.
I confirmed this behaviour numerous times, and it's not only with margin but
also with page-layout. Is there a work-around?
Many thanks,
EdgarThe work around is to call SetProperties for the linked report, setting the
PageHeight, PageWidth, TopMargin, BottomMargin, LeftMargin and RightMargin
to the values you wish. All values should be expressed in mm.
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"Edgar Allik" <Edgar Allik@.discussions.microsoft.com> wrote in message
news:0F3C537B-ECBF-4B69-BCE3-BFF8143B7BED@.microsoft.com...
> Hello,
> I may have discovered a possible bug with the new SP2 Client Printing
> capabilities.
> To reproduce:
> 1) Create a report with margins of 0.3in top, left, bottom and right, and
> page size of 8.5 x 11 (standard US letter size)
> 2) Deploy the report to Report Manager
> 3) Confirm that client printing respects margins set in report. Click on
> the print button, click on Print Preview, click on Margins, you should now
> see 0.3in margins all around
> 4) Create a linked report by going to Properties and clicking Create Link
> Report button.
> 5) Click on the print button, click on Print Preview, click on Margins,
> you
> should now see 0.5in margins all around, instead of 0.3in. This does not
> occur while exporting linked report to PDF format.
> I confirmed this behaviour numerous times, and it's not only with margin
> but
> also with page-layout. Is there a work-around?
> Many thanks,
> Edgar
>|||Hi, I am also experiencing the same error in SP2 where the page layout
properties don't seem to be set as they should be in a linked report.
I'm presuming "call SetProperties" is done via code - is there a work
around or way of doing this via Report Manager to fix this problem?
I'm not using any code with my reports, just URL access.
Thanks
Jeanine
Daniel Reib (MSFT) wrote:
> The work around is to call SetProperties for the linked report,
setting the
> PageHeight, PageWidth, TopMargin, BottomMargin, LeftMargin and
RightMargin
> to the values you wish. All values should be expressed in mm.
> -Daniel
> This posting is provided "AS IS" with no warranties, and confers no
rights.
> "Edgar Allik" <Edgar Allik@.discussions.microsoft.com> wrote in
message
> news:0F3C537B-ECBF-4B69-BCE3-BFF8143B7BED@.microsoft.com...
> > Hello,
> >
> > I may have discovered a possible bug with the new SP2 Client
Printing
> > capabilities.
> >
> > To reproduce:
> > 1) Create a report with margins of 0.3in top, left, bottom and
right, and
> > page size of 8.5 x 11 (standard US letter size)
> > 2) Deploy the report to Report Manager
> > 3) Confirm that client printing respects margins set in report.
Click on
> > the print button, click on Print Preview, click on Margins, you
should now
> > see 0.3in margins all around
> > 4) Create a linked report by going to Properties and clicking
Create Link
> > Report button.
> > 5) Click on the print button, click on Print Preview, click on
Margins,
> > you
> > should now see 0.5in margins all around, instead of 0.3in. This
does not
> > occur while exporting linked report to PDF format.
> >
> > I confirmed this behaviour numerous times, and it's not only with
margin
> > but
> > also with page-layout. Is there a work-around?
> >
> > Many thanks,
> >
> > Edgar
> >