Unable to connect to Enterprise Manager in SQL Server 2000

Problem Description =============== Encountered the following error message when tried to connect to Enterprise manager in SQL Server 2000             A connection could not be established to (LOCAL).             Reason: Client unable to establish connection             Unable to load communication module.  Driver has not been correctly installed.. Please verify SQL Server is running and check…


Unable to connect to SQL Server 2005 from Backupexec application

Problem Description: =============== While connecting to SQL Server 2005 Express instance through BackupExec application, we might encounter a connection failure. And the following error message would be logged in the Application event viewer logs The Backup Exec Device and Media Service could not start because the database recovery has failed.  Refer to the database recovery…


Installation of SQL Server 2000 Service Pack 4 on cluster environment may appear hung while installing MDAC Component on the remote machine

Installation of SQL Server 2000 Service Pack 4 on cluster environment may appear hung while installing MDAC Component on the remote machine   Consider a scenario wherein the Service Pack 4 on SQL Server 2000 Enterprise Edition is failing or get hung forever on an n-node cluster on Windows Server 2000 SP4 or Windows Server…


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. For example, we do not keep the LOCK…

1

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 the SP3 installation had not…

1

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 Bob Dorr from SQL Server Escalation Services, http://blogs.msdn.com/psssql/archive/2008/02/13/how-it-works-sql-server-per-query-degree-of-parallelism-worker-count-s.aspx  …

8

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 you really need this to work. Plan here is to make sure SQL Agent…

0

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—-> Middle Server         Last Server                                                  <—- ==================================================   In order to get this replication topology done, we can use…

1

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: —————————————————————————————————– “Error: 2775: Code page 850 is not supported by the operating system.”   2. Error while trying to open tables…

1