Microsoft KB Archive/197562

= BUG: Heterogeneous Query Showplan May Not Display Site Name =

Article ID: 197562

Article Last Modified on 10/15/2002

-

APPLIES TO


 * Microsoft SQL Server 7.0 Standard Edition

-



This article was previously published under Q197562



BUG #: 47446 (SQLBUG_70)



SYMPTOMS
When executing a heterogeneous query, the Showplan output does not always display the site name where that portion of the query plan was executed.



WORKAROUND
To work around this problem, refer to the query and determine the site by determining which site contains the objects being scanned.



STATUS
Microsoft has confirmed this to be a problem in SQL Server version 7.0.



MORE INFORMATION
In the example below, the site ([server1]) shows where the clustered index seek is performed. Query: Select * from server2.pubs.dbo.authors A INNER REMOTE JOIN server1.pubs.dbo.authors B on A.au_id = B.au_id

|--Nested Loops(Inner Join) |--Remote Query(SELECT A."au_id" Col1002,A."au_lname"  Col1003,A."au_fname" Col1004,A."phone" Col1005,A."address"   Col1006,A."city"   Col1007,A."state" Col1008,A."zip" Col1009,A."contract" Col1010 FROM   "pubs"."dbo"."authors" A)         |--Clustered Index Seek(OBJECT:([pubs].[dbo].[authors].[UPKCL_auidind] AS [B]),  SEEK:([B].[au_id]=[server1].[pubs].[dbo].[authors].[au_id]) ORDERED) In the next example, the site where the clustered index scan is performed is not displayed. Query: Select * from server1.pubs.dbo.authors A INNER REMOTE JOIN server2.pubs.dbo.authors B on A.au_id = B.au_id |--Nested Loops(Inner Join) |--Clustered Index Scan(OBJECT:([pubs].[dbo].[authors].[UPKCL_auidind] AS [A])) |--Remote Query(SELECT B."au_id" Col1002,B."au_lname"  Col1003,B."au_fname" Col1004,B."phone" Col1005,B."address"   Col1006,B."city"   Col1007,B."state" Col1008,B."zip" Col1009,B."contract" Col1010 FROM   "pubs"."dbo"."authors" B WHERE ?=B."au_id")

Additional query words: prodsql show plan

Keywords: kbbug kbpending KB197562

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.