Welcome to MSDN Blogs Sign in | Join | Help

Browse by Tags

All Tags » SQL Server 2000   (RSS)

A delete statement in SQL Server 2000 takes around 1.5 GB of Transaction Log Space, Where as in SQL 2008 it can take around 3.2 GB!

There are a lot of Changes in the Transaction Log Architecture of SQL 2000 and SQL 2008. There is a huge difference in the way the log records are maintained in SQL 2000 vs SQL 2005/2008. We keep more information in the Transaction Log in SQL 2005/2008. Read More...
Posted Saturday, August 29, 2009 12:38 AM by sanjayap | 0 Comments

DTS PACKAGE FAILS TO OPEN WITH ERROR [Dbnetlib][ConnectionRead (WrapperRead()).] General network error

We have observed a number of cases where in the dts package fails to open from the enterprise manager in sql 2000 or management studio in sql 2005. We are able to create a new DTS package and save them but when we try to open them, it fails with below Read More...
Posted Thursday, August 20, 2009 11:48 AM by sanjayap | 0 Comments

How to reapply SQL 2000 SP4 to update all the 13 scripts

Due to any issue, you may want to rerun SQL 2000 SP4 upgrade. SQL 2000 Service Packs are cumulative. But when you re-run SP4 it only updates 7 Scripts those are new with SP4. This could be useful when SQL Server is already on SP3 and due to some reason Read More...
Posted Saturday, January 31, 2009 3:09 AM by sanjayap | 1 Comments

Why Do I see more threads per SPID in sysprocesses than MAXDOP?

Most of the Customers using sql server 2000,2005 and 2008 have this doubt in their mind when using parallelism in sql server. Why Do I see more threads per SPID in sysprocesses than MAXDOP? The above question is being addressed in the following blog by Read More...
Posted Monday, January 05, 2009 11:49 AM by sanjayap | 3 Comments

Did you know… You will receive “Cannot open the PST because it is in use.” error when you configure SQLMail to use an internet mail server by using Outlook 2003

It is not recommended that you use Outlook 2002 or Outlook 2003 together with SQL Mail and with Internet mail servers that use SMTP or POP3. More info on this is available at http://support.microsoft.com/?id=897349 . Below is a practical workaround if Read More...
Posted Friday, October 31, 2008 2:31 PM by sanjayap | 0 Comments

How to setup a SQL Server Replication between three servers in a typical scenario..

Three Servers (Top, middle and Bottom) Data will flow from Top to the Bottom Server. Top to Middle Server (one way Replication) and Middle to Last Server (two ways Replication). ================================================= ----> Top Server----> Read More...
Posted Friday, October 31, 2008 2:14 PM by sanjayap | 1 Comments

Did you know... Because of Collation settings for the database in SQL Server, you may not be able to navigate through the Database objects in Enterprise Manager

At times, when you try to open the tables within a Database in SQL Server 2000 Enterprise Manager, you may see below error(s): 1. Error while trying to explore table from Enterprise Manager: ----------------------------------------------------------------------------------------------------- Read More...
Posted Friday, October 31, 2008 1:35 PM by sanjayap | 1 Comments

Did you know... The stats can degrade the performance if outdated but how to check when stats gets updated

Sometimes the query performance degrades due to the out of sync stats on the tables in the database. But how do we know it and how we do reach at the conclusion that the stats are the cause of the performance degradation. This is pretty well known but Read More...
Posted Sunday, October 26, 2008 10:50 PM by sanjayap | 0 Comments

Did you know... SQL Server 2000 cluster Resource Fails to come online with error SuperSocket Info: Bind failed on TCP port 5184 reported in errorlog!

In order to change the Virtual IP of the sql server 2000 clustered instance we need to follow the following KB article http://support.microsoft.com/kb/244980 However If we try to change the Virtual IP by mapping the Virtual Server Name of the sql server Read More...
Posted Friday, October 17, 2008 1:18 AM by sanjayap | 0 Comments

Did you know… The applications like Infopath may fail to submit data into table in SQL Server if the table is included in Merge replication

You are able to submit the data in the table using the application like InfoPath 2007 but when you go ahead and add the table in the Merge Replication Publication, the insert into the table using the InfoPath form starts to fail. This issue occurs when Read More...
Posted Sunday, October 05, 2008 3:54 PM by sanjayap | 1 Comments

The subscription fails to Sync with the Publisher and marked inactive even though the settings have been configured to “never expire”

We get the below error message when distribution agent tries to sync, Error: 14151, Severity: 18, State: 1. The subscription(s) have been marked inactive and must be reinitialized. NoSync subscriptions will need to be dropped and recreated. CAUSE: ====== Read More...
Posted Saturday, October 04, 2008 10:02 PM by sanjayap | 1 Comments

Upgrade of SQL Server 2000 instance to SQL Server 2005 fails with error similar to "Enforce password policy"

During the upgrade for the SQL Server 2000 to SQL Server 2005, the upgrade completes but with an error message related to the "Enforce Password Policy". The error message can be found in the setup log files but the server upgrade completes and you cans Read More...
Posted Thursday, July 31, 2008 8:06 AM by sanjayap | 1 Comments

Regeneration of the Master Key fails when we try to take the backup of the Original Database and Restore on other instance of SQL server on other Machine

We have a production database in which the data is encrypted. The encryption follows the following hierarchy 1) The data is encrypted using Symmetric key 2) The symmetric key was encrypted using asymmetric key 3) The asymmetric key was encrypted using Read More...
Posted Wednesday, July 16, 2008 1:32 PM by sanjayap | 3 Comments

Which Vulnerability security patches needs to be installed for SQL Server 2000 and SQL Server 2005

There are new vulnerability security patches which have been released for sql server 2000,sql server 2005. We can refer the following KB article which provides the overview of the new patches which are released http://support.microsoft.com/?id=941203 Read More...
Posted Friday, July 11, 2008 3:47 PM by sanjayap | 1 Comments

How to convert a standalone Instance of SQL Server into an Clustered Instance

For SQL Server 2000: Case 1: If the default instance of sql server is to be upgraded to default clustered instance of sql server 2000 Note: 1) Only Default instance can be upgraded by this method 2) This Functionality is not vailable in sql server 2005 Read More...
Posted Sunday, April 27, 2008 9:20 PM by sanjayap | 1 Comments
 
Page view tracker