Microsoft KB Archive/153107

= Incorrect Configuration of TEMPDB Causes Query Execution Error =

Article ID: 153107

Article Last Modified on 10/27/2006

-

APPLIES TO


 * Microsoft Systems Management Server 1.0 Standard Edition
 * Microsoft Systems Management Server 1.1 Standard Edition
 * Microsoft Systems Management Server 1.2 Standard Edition

-



This article was previously published under Q153107



SYMPTOMS
The following error may occur when you query the Systems Management Server database:

ERROR: Could Not Execute Specified Query

Execution Error 0.

If you enable SQL tracing, you will also see the following error logged in the Datalodr.log file:

SQL>>>>> You cannot run SELECT INTO in this database. The DBO would have to run sp_dboption to enable this option.



CAUSE
This problem may occur because the TEMPDB database option "Select Into/Bulk Copy" is not enabled.



RESOLUTION
Verify or enable this option on the TEMPDB database using SQL Enterprise Manager, using the following steps:


 * 1) Using SQL Enterprise Manager, drill down to the TEMPDB database.
 * 2) Right-click on the TEMPDB database and click Edit.
 * 3) Click the Options tab.
 * 4) Click the Select Into/Bulk Copy checkbox.
 * 5) Click OK.

Additional query words: prodsms

Keywords: kbdatabase kbnetwork kbsmsadmin KB153107

-

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

© Microsoft Corporation. All rights reserved.