Article ID: 312979
Article Last Modified on 9/23/2005
APPLIES TO
- Microsoft Commerce Server 2000 Service Pack 2
This article was previously published under Q312979
SYMPTOMS
The Data Warehouse Catalog Import Data Transformation Services (DTS) task creates and then drops a table in the catalog database during execution. This process uses the connection string with which users on the Web site access the catalog. Because of this, the connection string must be able to drop and add tables on the production database, which poses a possible security risk.
CAUSE
The table is not created as a Microsoft SQL Server temporary table.
RESOLUTION
To resolve this problem, obtain the latest service pack for Commerce Server 2000. For additional information, click the following article number to view the article in the Microsoft Knowledge Base:
297216 INFO: How to Obtain the Latest Commerce Server 2000 Service Pack
The English version of this fix should have the following file attributes or later:
Date Time Version Size File name
--------------------------------------------------------------
28-Nov-2001 18:37 4.0.3017.0 536,848 Cdtstasks.dll
30-Nov-2001 20:09 1,804 Hotfix.txt
13-Jun-2001 14:08 1.0.0.1 28,944 Hotfixsetup.exe
28-Nov-2001 19:29 453 Qfehotfix.ini
28-Nov-2001 19:27 261,120 Qfepatch.msp
28-Nov-2001 19:29 7,168 Qfeunpatch.msp
STATUS
Microsoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article. This problem was first corrected in Commerce Server 2000 Service Pack 3 (SP3).
Keywords: kbbug kbfix kbcommserv2000sp3fix kbqfe kbcommserv2000presp3fix kbhotfixserver KB312979
