Microsoft KB Archive/216320

= FIX: SELECT INTO Does Not Return Statistics IO Information =

Article ID: 216320

Article Last Modified on 3/14/2006

-

APPLIES TO


 * Microsoft SQL Server 6.5 Standard Edition

-



This article was previously published under Q216320



BUG #: 16740 (SQLBUG_65)



SYMPTOMS
With Microsoft SQL Server 6.5 Service Packs 3 or 4 installed, SELECT INTO will not return statistics IO information.



WORKAROUND
To work around this problem, start SQL Server with trace flag -T5302.

To add trace flag 5302 as a SQL Server startup parameter: For more information about using trace flags, refer to the SQL Server Books Online.



STATUS
Microsoft has confirmed this to be a problem in SQL Server 6.5. This problem has been corrected in Service Pack 5a for Microsoft SQL Server 6.5.For more information, click the following article number to view the article in the Microsoft Knowledge Base:

197177 INF: How to Obtain SQL Server 6.5 Service Pack 5a

For more information, contact your primary support provider.



MORE INFORMATION
To reproduce this problem, execute the following query on a SQL Server with Service Pack 3 or 4 installed:

use pubs go set statistics io on go select * into #tt from authors go set statistics io off go drop table #tt go

Additional query words: sp sp3 sp4 sp5

Keywords: kbbug kbfix KB216320

-

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

© Microsoft Corporation. All rights reserved.