Knowledge Base

Incorrect Configuration of TEMPDB Causes Query Execution Error

Article ID: 153107

Article Last Modified on 10/27/2006

APPLIES TO

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


Send feedback to Microsoft

© Microsoft Corporation. All rights reserved.