Tuesday, November 25, 2014

Microsoft SQL Server 2000 Supporting Operating System

Windows Operating System for SQL 2000

SQL Server 2000 Supports only the following Operating System

  • Windows 2000 Advanced Server 
  • Windows 2000 Professional Edition 
  • Windows 2000 Server
  • Windows Server 2003
  • Datacenter x64 Edition 
  • Windows Server 2003
  • Enterprise x64 Edition
  • Windows Server 2003 
  • Standard x64 Edition
  • Windows Small Business Server 2003 
  • Windows XP Home Edition 
  • Windows XP Media Center Edition
  • Windows XP Professional Edition


Hardware Requirement

  1. PC with Intel or compatible Pentium 166 MHz or higher processor
  2. Minimum of 64 MB of RAM (128 MB or more recommended)

Point of Sale Day End : Statistical data Not Updated SQL Error

Point of Sale Day End Statistical data not updated

while do day end of point of Sale it may show error message as " Could not create an instance of OLE DB provider 'SQLOLEDB' error trace [Non-interface error: CoCreate of DSO for SQLOLEDB returned 0x80004002]. " 

Type : Type of Error SQL Error.
The above error getting when create Linked server in SQL 2000.

Solution

Kindly check whether the following pre-requisite installed in your machine.

  • MDAC Components.
  • SQL Service Pack 3 and 3a.
If Both were already installed in your machine, just uninstall MDAC Components from your machine re install once again.

Note: If problem still persist kindly comment using below button

Point of Sale Shift End Error : Statistical data not updated

Point of Sale Shift End Error and Solution

While do the Point of Sale Shift End it may show the error message like below.

Cause

These errors are typically caused by some sort of database corruption, either in-memory or on-disk. Essentially, the server is requesting a page from the buffer pool, and the page number/object ID on the page differs from the one that was requested.

Solution

  • Copy below Script from PoTools.
  • Execute at Once using SQL Query Analyzer to Repair Tables.

Use POSPCC
dbcc checktable('articlessent') WITH ALL_ERRORMSGS, NO_INFOMSGS​