SQLServerCentral / SQL Server 7,2000 / Service Packs

2000 SQL Update 4

gsk1nner — Thu, 14 Feb 2013 10:24:12 GMT

Please help! I am not exactly computer savy, but I can follow directions. I have the following error: One or more SQL Server instances could not verify your account information. I have read the install directions and have all my settings per Microsoft and it will not install.

Installing Hotfix

lucas_leon88 — Wed, 02 Jan 2013 09:19:03 GMT

Hi. Im with a SQL Server 8.00.2066 (SP4) 32 bits. it run on Windows Server 2003 32 bits (SP2).I have created a trace for monitoring the database accesses. Its the code:[code="sql"]declare @rc intdeclare @TraceID intdeclare @maxfilesize bigintset @maxfilesize = 10000 set @TraceID = 1exec @rc = sp_trace_create @TraceID output, 2, N'f:\TracesSQL', @maxfilesize, NULL if (@rc != 0) goto errordeclare @on bitset @on = 1exec sp_trace_setevent @TraceID, 14, 3, @onexec sp_trace_setevent @TraceID, 14, 11, @onexec sp_trace_setevent @TraceID, 14, 8, @onexec sp_trace_setevent @TraceID, 14, 10, @onexec sp_trace_setevent @TraceID, 14, 12, @onexec sp_trace_setevent @TraceID, 14, 14, @onexec sp_trace_setevent @TraceID, 14, 26, @ondeclare @intfilter intdeclare @bigintfilter bigintexec sp_trace_setstatus @TraceID, 1select TraceID=@TraceIDgoto finisherror: select ErrorCode=@rcfinish: END[/code]When you SELECT the data INTO table, the server retrieve:[color="Red"][font="Courier New"]Msg 568, Level 16, State 13, Line 1Server encountered an error 'f:\TracesSQL.trc'.[/font][/color]The error occurs in random way.I tried to install the KB911678 hotfix but appear the next:SQL Server 2000 -->> MSSQLServer (SP4 2039)This SQL Server instance you are currently running already contains the update you are trying to install. You do not need to install the update. A Hotfix of build equal to or greater than the following should be downloaded: 2303SQL Server 2000 Tools -->> SQLTools(SP4)The product does not have a prerequisite update installed. The installation is dependent on the prerequisite update and cannot be installed. Exit setup and refer to the Knowledge Base article to find the prerequisite patch. Install the prerequisite and rerun the installation.Do you say?

FN_GET_SQL missing from my SQL 2000 SP4 installation

wooddsw — Fri, 23 Mar 2012 03:35:50 GMT

I've just discovered that system function FN_GET_SQL is missing from my SQL200 production server. I have it on my SQL 2000 development servers. I have re-applied SP4 without any errors from the GUI but it didn't restore it. Going to the context menu on one of my development boxes, Generate SQL Scripts is greyed out. Has anyone encountered this and discovered a way to restore it?

Failed to Upgrade SQL 2000 Installation to SP4

Fabian Roman — Tue, 16 Oct 2012 13:34:33 GMT

Hello everyone!I have come here to try and get some help with an issue I am having with an SQL installation. My knowledge is really basic when it comes to DBA, but I will appreciate any help you can give me.I was tasked with installing SQL 2000 Enterprise x64 Edition on both nodes of a fail over clustering setup. This nodes are running on Windows Server 2003 R2The SQL 2000 installation warns me that it is incompatible with the OS and that I will need to apply SP4 afterwards. When I try to install SP4, everything goes fine until I get the following message (at about 2 minutes after the login prompt):(Literal translation from Spanish)The installation software could not complete the necesary operations on every node of the cluster.And then it just crashes to desktop. After that, I can see the SQL Server, SQL Server Agent and SQL Server Fulltext resource on a disconnected status, but I guess that is just a process from the installation.I went around a couple of Microsoft Articles which pointed me to some logs, but I couldn't really make anything out of them, specially when one of the last lines says everything went just fine. Maybe you people can help a newbie?Thank you!

XP_Sendmail Error

Deepak.Sharma507 — Mon, 26 Mar 2012 04:20:08 GMT

Hi All,I installed SP4 on sql2000. Now I am getting following error while I am using xp_sendmail.Server: Msg 18025, Level 16, State 1, Line 0xp_sendmail: failed with mail error 0x8004060cPlease help..Thanks,Deepak

Vulnerability Assessment and MS02-061

strate — Wed, 22 Feb 2012 11:04:34 GMT

Dears,I performed a Vunerability Assessment with a Database Appliance named Fortidb, to lock down one of our important sqlserver2000 with SP4, running on Windows 2000 server, it generated a report with many critical and major warnings related to PUBLIC role and Guest User.the most recommended problems resolutions are to apply the MS patch Q316333 another patch released with MS02-061 !! in addition to remove public from certain Store procedures even in MSDB database!bearing in mind that SQL2000 SP4 is already applied which should contains these 2 very old patches :crazy:Please advice if it's really important and necessary to apply the mentioned old patches ( although I couldn't find them on microsoft website) or to manually remove public in the places the report has recommended in the attach document?!thank you in advance.

Installing Sql server service pack 4 on Cluster

tejinder pal singh — Thu, 07 Apr 2011 09:51:43 GMT

I have never installed sp4 for sql server 2005 on cluster with 2 nodes. Can anyone help me with the steps to install it?

Can you install 2000 SP4 on MSDE?

Wayne West — Mon, 17 Oct 2011 11:25:50 GMT

The MSDE version is SP3, not 3A, it's on a 2003 Standard Edition SP2 server. I try installing base SP4 and it says it can't find SQL Server 2000. We need to get SP4 installed on it so that Data Protection Manager will be happy. It isn't really critical as I have an autoexec SP that backs up the databases whenever someone connects to the database, and I have a scheduled job that runs at 23:00 that backs up the databases and does a DBCC. So not critical, but it would make my network admin happy.Any thoughts?

SP3 upgrade from SP2 failed, PLS HELP

qur7 — Thu, 21 Apr 2011 09:04:31 GMT

Hello guys,we are planing to upgrade SP2 to SP3 for our production. so i first wanted to upgrade our development box but the MS SQL SERVICE upgrade fail . when i going in SSMS and check the version it says SP3 but in the summary.txt it is saying fail.This is a sql server 2005 standard edition running sp2.Below in the copy of the message in the Summary.txtProduct : Database Services (MSSQLSERVER)Product Version (Previous): 4035Product Version (Final) : Status : FailureLog File : C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Hotfix\SQL9_Hotfix_KB955706_sqlrun_sql.msp.logError Number : 29537Error Description : MSP Error: 29537 SQL Server Setup has encountered the following problem: [Microsoft][SQL Native Client][SQL Server]One or more files do not match the primary file of the database. If you are attempting to attach a database, retry the operation with the correct files. If this is an existing database, the file may be corrupted and should be restored from a backup.. To continue, correct the problem, and then run SQL Server Setup again.Any help in this matter in greatly appreciated.---------------------------------------------------------------------------------------------------During my research i saw that some one mentioned to check the default database setting in sql properties. and if those folders and paths are avialable. which they are as i checked it before posting.

sql server 2000 is not installed on this machine. Setup will now exit.

MSQLDBA — Wed, 02 Feb 2011 22:23:05 GMT

Hi friends,I am building a new server of sql server 2000-sp4 on windows 2003-sp2 x86. While i run the setup i am getting a message,"sql server 2000 is not installed on this machine. Setup will now exit."and installation is terminated. Anyone can help me out.Thanks in Advance.

How to install Service Pack on SQL Server 2000 Replication server

xparmanand — Wed, 19 Jan 2011 05:45:10 GMT

Hi Experts,We have a SQL Server 2000 Standard Edition Installed with Replication having Service pack 2 on main server(Publication & distributor) & Service pack 1 on replicated server, below is the output of @@Version commansServer 1Microsoft SQL Server 2000 - 8.00.2055 (Intel X86) Dec 16 2008 19:46:53 Copyright (c) 1988-2003 Microsoft Corporation Standard Edition on Windows NT 5.2 (Build 3790: Service Pack 2) Server 2Microsoft SQL Server 2000 - 8.00.2039 (Intel X86) May 3 2005 23:18:38 Copyright (c) 1988-2003 Microsoft Corporation Standard Edition on Windows NT 5.2 (Build 3790: Service Pack 1) Our requirement is to install latest service packs on both these severs, since I am new to this so I have a question1) Which service pack do we need to install on both servers?2) How to Install service pack? I mean any guidelines!3) If any error comes while installing, How to rollback the installation?any help on this is realy great for me!Thanks,

Bring SQL 2000 SP4 up to compliance

Timothy Patihk — Tue, 24 Aug 2010 05:24:20 GMT

Hi,I have an SQL 2000 SP4 engine, and I am looking to get it up to compliance for an audit item which requires me to have all hotfixes post SP4 installed on the engine.Can anyone tell me how to go about doing this? I see the cummulative hotfix build 2187, however I see there are two other hotfixes attached to that build number as well. So I'm confused. Can I install this cummulative hotfix and it will contain all the other hotfixes post SP4 up to 2187? Then, do I have to download and apply all other hotfixes individually?Is there an easy upgrade tool for sql 200?Thanks,Tim

sql 2000 Enterprise RTM upgrade to 3a

Chan Wai Yin — Thu, 21 Oct 2010 02:40:30 GMT

Hi,We plan to upgrade existing sql server enterprise 2000 RTM to SP3a(Chinese Traditional). Since we want to keep all the data after upgrading, can we use the original database backup(RTM) and restore to new version(Sp3a) without any error?P.S: The RTM database backup have only basic item such as table, storeproc, index, without any replication items.Thanks and regards,Wallace

SQL 2000 Cluster

ramses2nd — Wed, 11 Aug 2010 07:18:59 GMT

I am trying to get a node on a cluster up and running again. Apparently there was a hardware failure and they removed the server from the cluster, rebuilt it, and re-added it. I try to run the SQL 2000 SP4 from one of the other nodes and it seems to go fine but for the node that was just added back it returnsCThreadPool::RunUntilCompleteHlpr WaitForMultipleObjects returned: 3010CThreadPool::RunUntilCompleteHlpr signaled thread [0xa8]Thread [0xa8] exit code: [0xbc2]CRemoteProcess::RunUntilComplete [0xc0] exit code: -12Remote process exit code was '-12'As a side note, there are no active resources or active groups associated to this node that is failing. I'm wondering if that may be an issue.

SP4 Setup Failure

Ronnie Jones — Thu, 13 Jul 2006 15:16:00 GMT

Hello All,

I'm trying to install SP4 on a multiple instance SQL Server 2000 server and I'm getting the following error:

Error running script: replsys.sql(1)

When I check the replsys.out file, here's what I see:

[DBNETLIB]General network error. Check your network documentation.[DBNETLIB]ConnectionRead (recv()).

Has anybody seen this error before?

I successfully install SP4 on another SQL instance running on that same server without any problems. Whatever the problem I'm having with the first instance is isolated to that instance.

Thanks in advance for any help!! It's really appreciated.

Ronnie

Migration from SP2 to SP2 on a Active / Passive Cluster

jason.nodarse — Wed, 09 Jun 2010 11:11:11 GMT

I was wondering if anyone has the exact step by step procedure of what I will need to do when updating the SP2 to SP3? I have two Windows 2003 Enterprise 32 bit servers with SQL 2005 Enterprise SP2 installed on them and clustered as a Active / Passive setup.What I know from researching myself is I should be able to install the SP3 on the live active node and when that is complete I can then just install the tools/components on the Passive node and this should do it. But what I am not sure about is weather I need to install the SP3 on the active node and then fail over to the passive node and install the SP update when the passive node is active or not. Here is where I am confused.

how to integrate sql sp4 into sql 2000 install files

booker2688 — Fri, 28 May 2010 00:20:35 GMT

how to intergrate sql 2000 with sql sp4 onto a cdrom?next time, i have only install sql with it, do not install sp4.

Service packs

Oracle_91 — Mon, 08 Mar 2010 00:21:05 GMT

Hi,Is that necessary/mandatory to install sp4 on sql server 2000 before going Sql 2008 migration with sp1?why am asking this is, we already have sp3 on sql 2000 enterprise edition instance and we now planning for sql 2008 migration. Since latest service pack available for sql 2000 is sp4, do we need to apply it first and then go for sql migration or can we directly migrate the sql 2000 sp3 instance to sql 2008 sp1 instance.Any Technical reasons??Thanks in Advance.

SP3 Installation issue

deepzzzz — Wed, 25 Nov 2009 07:29:22 GMT

I have installed SQL 2005 in my server. I want to install SP3 for the same. But it is giving the below error.Your account information could not be verified. Press Ok to return to Authentication Mode screen to determine the reason for failure." For setup to verify your credentials the services must be startable, connectable and you must be a SQL Server administrator."I am trying to login with SQL Authentication (sa).Thanks In Advance...

SQL 2005 SP3 Upgrade problem

rmcintire — Tue, 06 Oct 2009 13:07:41 GMT

I am fairly new to SQL and I upgrading my servers to SP3 I went to upgrade my SQL 2005 Active/Passive cluster. I did all of my backups and rebooted my servers to do a clean install. I ran the upgrade on the Active node and the install was successful. At the end it told me a few processes were locked and a reboot was required. After the reboot, I failed the node back to the original active server and checked the event logs and all was good. The issue I have is, when I fail over to the passive node I show in SSMS that SP3 is still not installed but on the original server it shows as complete. Not sure where to proceed from here. Any help would be greately appreciated.

help needed: upgrading sql server 2000 rtm(8.00.194) to sql 2000 sp4

naga veeram — Tue, 27 Mar 2007 10:28:00 GMT

Hi guys, I need to upgrade sql2000 rtm to sp4. I need the procedure to upgrade to sp4. I think there are like 4 diff patches that need to installed based on the settings... If you have the 32-bit SQL Server engine or client tools installed, you want Sql2k32sp4.exe. If you have the Desktop Engine (MSDE) installed, you want Sql2kdesksp4.exe. If you have Analysis Services installed, you want Sql2k32asp4.exe. If you are running the 64-bit edition of SQL Server, you want Sql2k64sp4.exe. what does this mean....????????

install sp4 to sqlserver2000 ent. runs error

mmeng — Mon, 17 Aug 2009 12:51:31 GMT

HI , Please help !We have a window 32bit server WIN2003 with sp2, on which there are 2 sqlserver 2005 sandard instances and 1 sqlserver 2000 enterprise. Now we apply service pack 4 to sqlserver2000 but failed with error 'error running script sp3_serv_uni.sql'.Thanks very much in advanceMoni

SQL 2000 MSDE Service Pack 4 Install fails

Keith Edwards — Fri, 26 Jun 2009 12:28:59 GMT

Hello,I am trying to update some older app servers with MSDE to build 2282. I have one server that is failing during the SP4 install with the error "Product: Microsoft SQL Server Desktop Engine -- An error has occurred while installing the SQL Active Directory Helper Service." then it rolls back the entire install. I have done lot's of searching on the web and haven't found a solution. Has anyone else ran into this before?Thanks,Keith

Security Managemen Systems

OJgJ.I — Sat, 20 Jun 2009 16:51:09 GMT

HI,i am not sure if this the right category to place my questions.I am using Security Management Systems for access control, i am not export on SQL wish that one dayby the way it need Assigned IP Address as 192.168.50.20, for control access i have installed VPN Cisco Software & after the SMS program start with following errorin dialog Box , never work againIMAGE [url=http://file13.9q9q.net/preview/83284555/SQL-Error.jpg.html][img]http://file13.9q9q.net/img/83284555/SQL-Error.jpg[/img][/url]ODBC;Driver={SQLServer};DATABASE=MuiltMax;Server=SMS-SERVER;Trusted_Connection=YES;:SQL Server does not Exist or Access Denied.ConnectionOpen (Connect()).State:08001,Native:17,Origin:[Microsoft][ODBC SQL SERVER Dirver][TCP/IP Sockets]State:01000,Native:10061,Origi:[Microsoft][ODBC SQL Server Driver][TCP/IP Sockets] Also RPC service is Not working with following errorC:\Documents and Settings\OJqJI>sfc /scannowWindows File Protection could not initiate a scan of protected systemThe specific error code is 0x000006ba [The RPC server is unavailable.].IMAGE [url=http://file13.9q9q.net/preview/57694573/SMS-Client-services.jpg.html][img]http://file13.9q9q.net/img/57694573/SMS-Client-services.jpg[/img][/url]SMS only work with Dongle it's install the USB but after while it's feel not installed is the follow Photo Attach here[url=http://file13.9q9q.net/preview/51739549/Dongol-Error.jpg.html][img]http://file13.9q9q.net/img/51739549/Dongol-Error.jpg[/img][/url]Also Here's the SQL MonitorIMAGE[url=http://file13.9q9q.net/preview/31553694/SQL-Monitor.jpg.html][img]http://file13.9q9q.net/img/31553694/SQL-Monitor.jpg[/img][/url]:crazy:

how to upgrade Microsoft SQL Server 2000 to sp4

zelehab — Mon, 01 Jun 2009 10:05:05 GMT

Hi colleagues, any help in upgrading from no service pack to sp4. it say you have no appropriate access but I have. any help? thx

Displaying data from 3 tables

jxclark — Tue, 19 May 2009 14:17:35 GMT

Hello,I'm new to .net programming, in which I'm attempting to code a hardware inventory web app. I'm using Linq to SQL Classes.I have three SQL 2005 tables.[b] * tblEmployee * tblDesktop * tblHardware[/b]In each table there's a tblID master key (auto increment). Created master/foreign keys (TblEmployee's tblID is the master key and tblDesktop, tblHardware are foreign keys). I'm utilizing the following code obtained from asp.net site: [b]Partial Class _Default Inherits System.Web.UI.Page Protected Sub btnSubmit_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles btnSubmit.Click System.Threading.Thread.Sleep(1000) Dim db As New AssetsDBDataContext Dim q = From b In db.tblEmployees _ Where b.LastName.Contains(txtSearch.Text.Trim()) _ And b.FirstName.Contains(txtSearch1.Text.Trim()) _ Select b lv.DataSource = q lv.DataBind() End SubEnd Class[/b] How it works: To see all hardware an employee is assigned with - Enter the employee's last and/or first name in the search boxes.I successfully get results, but I would like to optimize the search/database. Problem: I'm using tblID for the primary keys (auto increment) with relationships to the other tables.I dont want to add duplicate hardware in the tables if they already exists. Example: tblDesktop contains three columns - Manufacture, Model, and Serial.Is there away to link the tblEmployee table to the hardware tables - yielding the desired search results?Maybe: join tblEmployee, tblDesktop, tblLaptop to a new table (displaying all three data)?

Issues applying SP2 for Analysis server 2005 on a 2-node cluster

pgaur-782852 — Sun, 17 May 2009 20:04:52 GMT

Hi, We've a 2-node cluster. We're trying to apply SP2 for Analysis server but could not.SQL Server 2005 already has SP2 installed, but Analysis server (a clustered component) has different versions on each of the cluster nodes.Node1 (active node) has Analysis server 9.00.1399.06 (RTM). Node2 (failover node) has Analysis server 9.00.3042.00 (SP2).When we tried to install SP2 from the active node (Node1) but were unable to select Analysis services for the upgrade. Basically get the following message: "The installation must be run from the active node. You are running it from a passive node. To proceed cancel the installation and run it again from the active node."We then tried failing over to Node2 hence making it active. Retried the SP2 install again but ended up with the same message as above.I'm not sure how the versions of Analysis server ended up being different on each node.Has anyone come across this issue or knows a way of making the Analysis server versions same on both cluster nodes?Thanks

For applying batch

ananda.murugesan — Thu, 14 May 2009 05:20:55 GMT

RTM 2000.80.194.0 SQL Server 2000 SP1 2000.80.384.0 SQL Server 2000 SP2 2000.80.534.0 SQL Server 2000 SP3 2000.80.760.0 SQL Server 2000 SP3a 2000.80.760.0 SQL Server 2000 SP4 2000.8.00.2039 At presently SQL server 2000, SP3. so I want install SP4 becuse SQL server performance counter was missing that server.Please can any one tell me, how apply SP4 batches step by step on this server?Supose if SQL server 2000 have patch RTM 2000.80.194.0, how to apply batch upto SP4. is it need to be install patches one by one sp1,sp2,sp3,sp3a and sp4?Thanks in advance

SQL 2000 Security Fix KB948110

maes.john — Wed, 23 Jul 2008 10:08:40 GMT

When I try to install the new security fix (KB948110) I'm getting one or more sql server instances could not verify your account information. I've tried using NT authentication and using my 'SA" account and I get the same from both. I have used the sa account in query analyzer so I know the password is good. Any help would be great. Thanks John

MSP ERROR: 29537 With SP3

LDAUGHER — Sun, 19 Apr 2009 16:26:40 GMT

I get this error while trying to apply SQL Server 2005 SP3 to an instance. Product : Database Services (SQL2005_3)Product Version (Previous): 4035Product Version (Final) : Status : FailureLog File : C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Hotfix\SQL9_Hotfix_KB955706_sqlrun_sql.msp.logError Number : 29537Error Description : MSP Error: 29537 SQL Server Setup has encountered the following problem: [Microsoft][SQL Native Client][SQL Server]The conversation handle "141EEA27-021B-DE11-A973-0014222200AA" is not found.. To continue, correct the problem, and then run SQL Server Setup again.Any one have any suggestions?

XP Reboots when installing SQL 2005 SP3

Rich MCT — Thu, 19 Mar 2009 05:59:39 GMT

Good morning all,When installing SQL 2005 SP3 on a Windows XP SP3 machine, the PC reboots when I try to test the connection OR click Next at the Authentication screen.There is nothing meaningful in the SQL logs.Unfortunately I am connecting via RDP as there is no keyboard or mouse attached in the server room where the PC resides so I am not able to see any possible errors before it reboots.Has anyone else had this problem?Kind regards,Richard

sqlmangr.exe looking for MSVCR71.dll cluster failover !

ALZDBA — Wed, 17 Sep 2008 09:20:40 GMT

- SQL2000 sp4 (cluster ! ) on Windows 2003 32-bit.Automatic updates enabled :sick:With "reboot needed" message pending when logon to the console.[b]symptomes[/b]:SQLAgent jobs tend to be hanging for hours (3-5) for jobs that normally complete in 20 minutes.[b]Action[/b]:stop sqlagent [b]OK[/b][b]Start SQLAgent causes cluster to failover.Failover does not succeed because of thisMessage "sqlmangr.exe looking for MSVCR71.dll ... try to reinstall ..."[/b]We copied MSVCR71.dll and msvcp71.dll from another server and now things seem to be working again.[b][size="4"]Can MS08_040 cause this issue ??[/size][/b]

Enterprise Manager SQL2000 SP4 - table lock

jens-uwe.maass — Thu, 09 Apr 2009 02:19:23 GMT

Hi all,we have a old application in our company, which is using SQL Server 2000 SP4.Sometimes if a developer makes a SELECT on a table, this SELECT locks the table (but the SELECT was completed and only the result is shown) and everybody, who using this table in the app gets an Timeout.What can I do to solve this problem ?Thanks for all response cyaJens

HELP SP3 for SQL05 COMPLETES BUT SOME FAIL

Joseph Donahue — Wed, 01 Apr 2009 23:22:10 GMT

Is it true that for SP3 for SQL 2005 to be uninstalled the entire installation of SQL 2005 has to be uninstalled? I had failures occur in the SP3 install but also had some the went through successfuly and the installation actually said it was completed. I can't make out too much from the log but should I do the full uninstall or do I take a chance that it worked and in fact I was supposed to have gotten those failures. Please help it's a production database and I'm desperate.

How to uninstall/rollback SQL 2000 Sp4

Kumaran Govender — Tue, 13 Mar 2007 09:09:00 GMT

Hi All,

Just been handed a query to rollback a production SQL Server to SP3a. The server is running SQL 2000 Enterprose Edition with Sp4. The upgrade to Sp4 was done over 4 months back and we need to retain changes to users SQL accounts that have been made during this time. Worst of all, I do not have a backup of the Sp3a version of the system databases . Does anyone have any bright ideas?

Thank you in advance...

Microsoft Security Bulletin MS09-004

paksyeet — Mon, 09 Mar 2009 01:43:17 GMT

pls delete this one..sorry for the mess..

SQL 2000 SP3 to SP4 Upgrade on cluster

Ed Mlynar — Thu, 05 Mar 2009 07:43:06 GMT

please delete

big troubles after installing MS security patch 960083

L_avital — Thu, 26 Feb 2009 08:09:44 GMT

We are running Microsoft SQL Server 2000 - 8.00.2282 (Intel IA-64) ,Enterprise Edition (64-bit) on Windows NT 5.2 (Build 3790: Service Pack 1), clustered. Immediately after we installed MS security patch 960083 troubles started to pile up. Red Gate backups started to hang for ever, replication logreader timedout even after we dropped aeverything and created new. Scheduled jobs started to hang periodically with intervalof an hour or two. Complete chaos. Called microsoft, reinstalled the patch together with them but it didn't solve any of SQL problems. Did anybody experience something like this and how did they overcome these problems?Thanks in advance to all who reply.LL

Do we install SP on each instance of sql 2000 ?

naumanikram2008 — Mon, 02 Feb 2009 00:43:06 GMT

I have a machine with 3 instances of sql 2000, one instance is default while other named isntance. I run serverproperty command with diff. parameter that gives me the report that only default sql instance is having sp4 while other 2 named instances shows RTM (Release To Manufacturing). What i am considering that named instances are not upgraded to sp4, what do u suggest me do I install sp4 to each instance of sql ? Explain a bit about RTM ?

Can't Update Build on SQL 2000 SP4

mstoffa — Tue, 02 Dec 2008 08:15:28 GMT

We have a handful of servers running SQL 2000 on Windows 2000 SP4. Just recently we installed SP4 on the SQL Servers and are now running build 8.00.2050. However we ran into an issue with one of the applications that appears to have the issue fixed with build SQL Server 2000 build 8.00.2145 (KB 901212). FIX: You receive an error message if you use the sp_addalias or sp_dropalias procedures when the IMPLICIT_TRANSACTIONS option is set to ON in SQL Server 2000 Service Pack 4 I have downloaded the hotfix from Microsoft that is to address this issue. However it does not appear that I can apply this update because it thinks it has a newer build on it. When I try to install the hotfix I am unable to select any updates and have the following messages:File Name: SQL2000-KB903086-v8.00.2148-x86x64-ENUMessages: This SQL Server instance you are currently running already contains the update you are trying to install. You do not need to install the update. A Hotfix of build equal to or greater than the following should be downloaded: 2273I am not a SQL admin so I am trying to learn this as I go along. Any advice on how to patch the server to at least build 2148 would be greatly appreciated.