Incorrect Configuration of TEMPDB Causes Query Execution Error

ID: Q153107

The information in this article applies to:
  • Microsoft Systems Management Server versions 1.0, 1.1, 1.2

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 : kbnetwork smsadmin smsdatabase
Version : winnt:1.0,1.1,1.2
Platform : winnt
Issue type :


Last Reviewed: January 13, 2000
© 2000 Microsoft Corporation. All rights reserved. Terms of Use.