Incorrect Configuration of TEMPDB Causes Query Execution Error (153107)


The information in this article applies to:

  • Microsoft Systems Management Server 1.0
  • Microsoft Systems Management Server 1.1
  • Microsoft Systems Management Server 1.2
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.
Modification Type:MinorLast Reviewed:6/14/2005
Keywords:kbDatabase kbnetwork kbsmsAdmin KB153107
©2004 Microsoft Corporation. All rights reserved.