Sql Server 2000
The following table compares the maximum sizes and numbers of various objects defined in SQL Server 7.0, SQL Server 2000 and SQL Server 2005 databases or referenced in Transact-SQL statements. The table does not include Microsoft SQL Server 2000 Windows CE Edition and Microsoft SQL Server 2005 Windows CE Edition. The table has the technical [...]
Continue reading about SQL Server – Maximum Capacity Specifications Comparison
Overview of Consistency Errors
A DBCC CHECKDB statement may report consistency errors in your database when all the following conditions are true:
SQL Server loads data into a column that is a sql_variant data type.
The data originates in another column that is a sql_variant data type and at some point the data is sent on-the-wire [...]
Continue reading about Consistency Errors in MS SQL Server 2000
Problem : You may receive the error 8645 when there is a high server workload or when the servers are experiencing high memory pressure.
You may see the following 8645 error sporadically:
Error 8645: A time out occurred while waiting for memory resources to execute the query. Re-run the query.
Resolution
You can use one [...]
Continue reading about Error 8645: A time out occurred while waiting for memory resources
Problem : "Error 14114: (NULL) is not configured as a distributor" error message when you try to set up a SQL Server server as a distributor for replication
When you try to set up a SQL Server server as a distributor for replication, the following error message may occur:
Error 14114:(NULL) is not configured as a [...]
Continue reading about Error 14114: (NULL) is not configured as a distributor
Problem : Maintenance job fails on named instances of SQL Server 2000 with Error 22029
Problem Description :
A database job created with the Database Maintenance Plan Wizard fails for a named SQL Server 2000 instance. If you view the job history in SQL Server Agent and you enable the Show step details check box, you will [...]
Continue reading about SQL Server 2000 Maintenance Jobs Failed with Error 22029
Problem : SQL Server 2000 stops responding when you query lots of data with a large packet size connected over a VIA protocol
Resolution : To resolve this problem, set the network packet size to 8,192 bytes or less if your application requires it.
Continue reading about SQL Server 2000 Not Responding for large size packets over VIA
Problem : A SQL Server cluster resource goes to a “failed” state when you try to bring the resource online in SQL Server 2005 or in SQL Server 2000
Resolution : Change the registry entry values HKEY_LOCAL_MACHINE\Cluster\Resources\
Continue reading about SQL Server Cluster Resource Failed When Bringing Online
When you try to install an instance of Microsoft SQL Server 2000 virtual server on the failover cluster nodes that are running Microsoft Windows Server 2003, you may notice that the SQL Server 2000 virtual server installation is not completed successfully. Additionally, you may receive the following error message:
“An error occurred while creating virtual [...]
Continue reading about Error while installing the SQL Server 2000 Virtual Instance
We might have seen the error “Cannot install SQL Server cluster on a computer that runs Microsoft Windows Server 2003 “ during the process of SQL Server Installation in Windows Server 2003. Let us discus why we get the error and how to recover from the error
Problem Description
You cannot install SQL Server cluster on a [...]
