FIX: SELECT INTO Does Not Return Statistics IO Information (216320)

The information in this article applies to:

Microsoft SQL Server 6.5

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

Modification Type:	Major	Last Reviewed:	3/14/2006
Keywords:	kbBug kbfix KB216320