26 December 2012

Could not load file or assembly 'Version=0.0.0.0, Culture=neutral, PublicKeyToken=null' or one of its dependencies. An error relating to security occurred. (Exception from HRESULT: 0x8013150A)



Error:
[Execute SQL Task] Error: Executing the query "Exec sp_NNNNNNNNN" failed with the following error: "An error occurred in the Microsoft .NET Framework while trying to load assembly id 65547. The server may be running out of resources, or the assembly may not be trusted with PERMISSION_SET = EXTERNAL_ACCESS or UNSAFE. Run the query again, or check documentation to see how to solve the assembly trust issues. For more information about this error:
System.IO.FileLoadException: Could not load file or assembly 'XXXXXXXX, Version=0.0.0.0, Culture=neutral, PublicKeyToken=null' or one of its dependencies. An error relating to security occurred. (Exception from HRESULT: 0x8013150A)
System.IO.FileLoadException:
   at System.Reflection.RuntimeAssembly._nLoad(AssemblyName fileName, String codeBase, Evidence assemblySecurity, RuntimeAssembly locationHint, StackCrawlMark& stackMark, Boolean throwOnFileNotFound, Boolean forIntrospection, Boolean suppressSecurityChecks)
   at System.Reflection.RuntimeAssembly.InternalLoadAssemblyName(AssemblyName assemblyRef, Evidence assemblySecurity, StackCrawlMark& stackMark, Boolean forIntrospection, Boolean suppressSecurityChecks)
   at System.Reflection.RuntimeAssembly.InternalLoad(String assemblyString, Evidence assemblySecurity, StackCrawlMark& stackMark, Boolean forIntrospection)
   at System.Reflection.Assembly.Load(String assemblyString)
". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly.


Solution :-


1. Go to Database
2. Expand Programmability
3. Expand Assemblies
4. Choose your assembly XXXXX
5. Right Click and go to properties
6. Change the Permission Set option to External

Note :- Make sure DB is in trustworthy, check options from properties. If its false 


ALTER DATABASE DBNAME SET TRUSTWORTHY ON


This will resolve.

Some times it will throw eerror with DB owner SIS issue for alter authorization, due to mismatch in SID of DB and Master db entry.

Change your DB owner to SA. then repeat step same as stated above. Will help to resolve issue.

EXEC sp_changedbowner ‘sa’

 

19 December 2012

The 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine. (System.Data)

The operation could not be completed.

------------------------------
ADDITIONAL INFORMATION:

The 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine. (System.Data)

------------------------------

Solution :- http://www.microsoft.com/en-us/download/confirmation.aspx?id=23734

18 December 2012

Kill Windows Seesions Remotly

To kill the sessions follow below sequence.

Step 1:  qwinsta /server: [ServerNAME]
Step 2: rwinsta [Session ID] /server: [ServerNAME]

The second step will take small amount of time, as it needs to close the open sessions.


30 November 2012

The SELECT permission was denied on the object 'extended_properties', database 'mssqlsystemresource', schema 'sys'. (Microsoft SQL Server, Error: 229)

Step1 :- Go to the properties account
Step2:- Choose User Mapping
Step 3:- Choose Respective DB
Step 4:- Remove db_denydatareader (uncheck)
Step 5:- Click Ok and Refresh


Another Issue :- http://blog.sqlauthority.com/2012/06/19/sql-server-solution-user-not-able-to-see-any-user-created-object-in-tables-security-and-permissions-issue/



28 November 2012

A snapshot was not generated because no subscriptions needed initialization

Thanks To :- http://social.msdn.microsoft.com/Forums/lv/sqlreplication/thread/12c21ca8-7031-4a9e-b813-0122f59a7b9d

Adding new article without generating a complete snapshot :




1) Make sure that your publication has IMMEDIATE_SYNC and ALLOW_ANONYMOUS properties set to FALSE or 0.



Use yourDB

select immediate_sync , allow_anonymous from syspublications



If either of them is TRUE then modify that to FALSE by using the following

command



EXEC sp_changepublication @publication = 'yourpublication', @property =

N'allow_anonymous', @value='False'

Go

EXEC sp_changepublication @publication = 'yourpublication', @property =

N'immediate_sync', @value='false'

Go



2) Now add the article to the publication



Use yourDB

EXEC sp_addarticle @publication = 'yourpublication', @article ='test',

@source_object='dbo.test', @force_invalidate_snapshot=1



If you do not use the @force_invalidate_snapshot option then you will receive the

following error

Msg 20607, Level 16, State 1, Procedure sp_MSreinit_article, Line 99

Cannot make the change because a snapshot is already generated. Set

@force_invalidate_snapshot to 1 to force the change and invalidate the existing snapshot.



3) Verify if you are using CONCURRENT or NATIVE method for synchronization by running the following command.



Use yourdb

select sync_method from syspublications



If the value is 3 or 4 then it is CONCURRENT and if it is 0 then it is NATIVE.

For more information check

http://msdn.microsoft.com/en-us/library/ms189805.aspx



4) Then add the subscription for this new article using the following command



EXEC sp_addsubscription @publication = 'yourpublication', @article = 'test',

@subscriber =‘subs_servername', @destination_db = 'subs_DBNAME',

@reserved='Internal'



If you are using the NATIVE method for synchronization then the parameter

@reserved=’Internal’ is optional but there is no harm in using it anyways. But if it is CONCURRENT then you have to use that parameter. Else the next time you run the snapshot agent it is going to generate a snapshot for all the articles.



Lastly start the SNAPSHOT AGENT job from the job activity monitor. To find

the job name follow these steps.



· select * from msdb..sysjobs where name like '%yourpublication%'

· Right click on each of those jobs and find which one contains the step

‘Snapshot Agent startup message’. This is the job that you want to

start from the first step.



Verify that the snapshot was generated for only one article.





27 November 2012

Adding Artical To T-Repl

Step 1  :- Add Artical


USE [Publication DB NAME]
GO

EXEC sp_addarticle
    @publication = '[Publication Name]',
    @article = N'[ARTICAL NAME]',
    @source_object = N'[ARTICALNAME]',
    @force_invalidate_snapshot=1
GO


Step 2:-


EXEC sp_changepublication
@publication = '[publication  name]',
@property = N'allow_anonymous',
@value = 'false'
GO


EXEC sp_changepublication
@publication = '[publication name]',
@property = N'immediate_sync',
@value = 'false'
GO

Step 3:- Run the snapshot agent either from replication monitor or from agent.

Step 4: Make Flags true used in Step 2

More Help on :- http://support.microsoft.com/kb/830210

http://dba.stackexchange.com/questions/12725/add-article-to-transactional-publication-without-generating-new-snapshot





 

21 November 2012

MSSQL Data Types and Ranges


Exact numerics

Type From To
bigint -9,223,372,036,854,775,808 9,223,372,036,854,775,807
int -2,147,483,648 2,147,483,647
smallint -32,768 32,767
tinyint 0 255
bit 0 1
decimal -10^38 +1 10^38 –1
numeric -10^38 +1 10^38 –1
money -922,337,203,685,477.5808 +922,337,203,685,477.5807
smallmoney -214,748.3648 +214,748.3647
numeric and decimal are Fixed precision and scale data types and are functionally equivalent.

Approximate numerics

Type From To
float -1.79E + 308 1.79E + 308
real -3.40E + 38 3.40E + 38

datetime and smalldatetime

Type From To
datetime (3.33 milliseconds accuracy) Jan 1, 1753 Dec 31, 9999
smalldatetime (1 minute accuracy) Jan 1, 1900 Jun 6, 2079
date (1 day accuracy. Introduced in SQL Server 2008) Jan 1, 0001 Dec 31, 9999
datetimeoffset (100 nanoseconds accuracy. Introduced in SQL Server 2008) Jan 1, 0001 Dec 31, 9999
datetime2 (100 nanoseconds accuracy. Introduced in SQL Server 2008) Jan 1, 0001 Dec 31, 9999
time (100 nanoseconds accuracy. Introduced in SQL Server 2008) 00:00:00.0000000 23:59:59.9999999

Character Strings

Type Description
char Fixed-length non-Unicode character data with a maximum length of 8,000 characters.
varchar Variable-length non-Unicode data with a maximum of 8,000 characters.
varchar(max) Variable-length non-Unicode data with a maximum length of 231 characters (Introduced in SQL Server 2005).
text Variable-length non-Unicode data with a maximum length of 2,147,483,647 characters.

Unicode Character Strings

Type Description
nchar Fixed-length Unicode data with a maximum length of 4,000 characters.
nvarchar Variable-length Unicode data with a maximum length of 4,000 characters.
nvarchar(max) Variable-length Unicode data with a maximum length of 230 characters (Introduced in SQL Server 2005).
ntext Variable-length Unicode data with a maximum length of 1,073,741,823 characters.

Binary Strings

Type Description
binary Fixed-length binary data with a maximum length of 8,000 bytes.
varbinary Variable-length binary data with a maximum length of 8,000 bytes.
varbinary(max) Variable-length binary data with a maximum length of 231 bytes (Introduced in SQL Server 2005).
image Variable-length binary data with a maximum length of 2,147,483,647 bytes.




Thanks ;- http://www.teratrax.com/sql-server-data-types-ranges/

16 November 2012

Need to run SSIS Package under specific user account using SQL Server Agent JOB

The issue is we need to run the SSIS package where the source path has permission to a perticular user. But the JOB owner is failed to access the path while executing the package as its using SQL Server Agent Account to run SSIS package.

Solution :-

Step1:- Go to Security expand choose Credential from there right click choose New Credential.
Step 2 :-  Use identity as your wish either sql account\windows account. click Ok.
Step 3:- Go to SQL Server Agent  choose proxy create new proxy.
Step 4:- In principals grant the required roles. click ok.
Step 5:- Go to the Job choose the step edit, now drop down RUN AS.
Step 6:- Select click ok. Now it will succeed.

More Help :- http://stackoverflow.com/questions/812428/how-to-schedule-ssis-package-to-run-as-something-other-than-sql-agent-service-ac

or

http://www.mssqltips.com/sqlservertip/2163/running-a-ssis-package-from-sql-server-agent-using-a-proxy-account/

17 October 2012

Script to get the details of SQL Server Installed Location , SQL Server Error Log location and Product Level for the Instance




                declare @RegPathParams sysname
                declare @Arg sysname
                declare @Param sysname
                declare @MasterPath nvarchar(512)
                declare @LogPath nvarchar(512)
                declare @ErrorLogPath nvarchar(512)
                declare @n int

                select @n=0
                select @RegPathParams=N'Software\Microsoft\MSSQLServer\MSSQLServer'+'\Parameters'
                select @Param='dummy'
                while(not @Param is null)
                begin
                    select @Param=null
                    select @Arg='SqlArg'+convert(nvarchar,@n)

                    exec master.dbo.xp_instance_regread N'HKEY_LOCAL_MACHINE', @RegPathParams, @Arg, @Param OUTPUT
                    if(@Param like '-d%')
                    begin
                        select @Param=substring(@Param, 3, 255)
                        select @MasterPath=substring(@Param, 1, len(@Param) - charindex('\', reverse(@Param)))
                    end
                    else if(@Param like '-l%')
                    begin
                        select @Param=substring(@Param, 3, 255)
                        select @LogPath=substring(@Param, 1, len(@Param) - charindex('\', reverse(@Param)))
                    end
                    else if(@Param like '-e%')
                    begin
                        select @Param=substring(@Param, 3, 255)
                        select @ErrorLogPath=substring(@Param, 1, len(@Param) - charindex('\', reverse(@Param)))
                    end

                    select @n=@n+1
                end

                declare @SmoRoot nvarchar(512)
                exec master.dbo.xp_instance_regread N'HKEY_LOCAL_MACHINE', N'SOFTWARE\Microsoft\MSSQLServer\Setup', N'SQLPath', @SmoRoot OUTPUT

SELECT
CAST(FULLTEXTSERVICEPROPERTY('IsFullTextInstalled') AS bit) AS [IsFullTextInstalled],
@LogPath AS [MasterDBLogPath],
@MasterPath AS [MasterDBPath],
@ErrorLogPath AS [ErrorLogPath],
@SmoRoot AS [RootDirectory],
CAST(case when 'a' <> 'A' then 1 else 0 end AS bit) AS [IsCaseSensitive],
@@MAX_PRECISION AS [MaxPrecision],
SERVERPROPERTY(N'ProductVersion') AS [VersionString],
CAST(SERVERPROPERTY(N'Edition') AS sysname) AS [Edition],
CAST(SERVERPROPERTY(N'ProductLevel') AS sysname) AS [ProductLevel],
CAST(SERVERPROPERTY('IsSingleUser') AS bit) AS [IsSingleUser],
CAST(SERVERPROPERTY('EngineEdition') AS int) AS [EngineEdition],
convert(sysname, serverproperty(N'collation')) AS [Collation],
CAST(SERVERPROPERTY('IsClustered') AS bit) AS [IsClustered],
CAST(SERVERPROPERTY(N'MachineName') AS sysname) AS [NetName],
SERVERPROPERTY(N'BuildClrVersion') AS [BuildClrVersionString],
SERVERPROPERTY(N'ComputerNamePhysicalNetBIOS') AS [ComputerNamePhysicalNetBIOS],
SERVERPROPERTY(N'ResourceVersion') AS [ResourceVersionString],
SERVERPROPERTY(N'ResourceLastUpdateDateTime') AS [ResourceLastUpdateDateTime],
SERVERPROPERTY(N'CollationID') AS [CollationID],
SERVERPROPERTY(N'ComparisonStyle') AS [ComparisonStyle],
SERVERPROPERTY(N'SqlCharSet') AS [SqlCharSet],
SERVERPROPERTY(N'SqlCharSetName') AS [SqlCharSetName],
SERVERPROPERTY(N'SqlSortOrder') AS [SqlSortOrder],
SERVERPROPERTY(N'SqlSortOrderName') AS [SqlSortOrderName]

11 October 2012

ALL Constraints of a given Database


SELECT KCU.table_name,

KCU.column_name field_name,

TC.constraint_type,

CASE TC.is_deferrable WHEN 'NO' THEN 0 ELSE 1 END 'is_deferrable',

CASE TC.initially_deferred WHEN 'NO' THEN 0 ELSE 1 END 'is_deferred',

rc.match_option 'match_type',

rc.update_rule 'on_update',

rc.delete_rule 'on_delete',

ccu.table_name 'references_table',

ccu.column_name 'references_field',

KCU.ordinal_position 'field_position'

FROM INFORMATION_SCHEMA.KEY_COLUMN_USAGE KCU

LEFT JOIN INFORMATION_SCHEMA.TABLE_CONSTRAINTS TC

ON KCU.table_name =TC.table_name

AND KCU.table_schema =TC.table_schema

AND KCU.table_catalog =TC.table_catalog

AND KCU.constraint_catalog =TC.constraint_catalog

AND KCU.constraint_name =TC.constraint_name

LEFT JOIN INFORMATION_SCHEMA.REFERENTIAL_CONSTRAINTS rc

ON rc.constraint_schema =TC.constraint_schema

AND rc.constraint_catalog =TC.constraint_catalog

AND rc.constraint_name =TC.constraint_name

LEFT JOIN INFORMATION_SCHEMA.CONSTRAINT_COLUMN_USAGE ccu

ON rc.unique_constraint_schema = ccu.constraint_schema

AND rc.unique_constraint_catalog = ccu.constraint_catalog

AND rc.unique_constraint_name = ccu.constraint_name

WHERE KCU.constraint_catalog = DB_NAME()

ORDER BY KCU.constraint_name,

KCU.ordinal_position;


Source :- http://www.extradrm.com/blog/?p=376

09 October 2012

Rebuild Resource Database

Resolution  1:

Try to detach and attach the DB files from some other SQL Server with same version and patch level.
Bring SQL Server ONline.


Resolution 2:


The following procedure rebuilds the resource system database. When you rebuild the resource database, all service packs and hot fixes are lost, and therefore must be reapplied.

To rebuild the resource system database:

  1. Launch the SQL Server 2012 Setup program (setup.exe) from the distribution media.
  2. In the left navigation area, click Maintenance, and then click Repair.
  3. Setup support rule and file routines run to ensure that your system has prerequisites installed and that the computer passes Setup validation rules. ClickOK or Install to continue.
  4. On the Select Instance page, select the instance to repair, and then click Next.
  5. The repair rules will run to validate the operation. To continue, click Next.
  6. From the Ready to Repair page, click Repair. The Complete page indicates that the operation is finished.



    More on http://msdn.microsoft.com/en-us/library/dd207003.aspx#RebuildProcedure

06 October 2012

Contained Databases - SQL Serve 2012


What are the Benefits of using Contained Database ?
Contained databases can be easily moved to another server and start working instantly without the need of any additional configuration like adding user, mapping SID’s again. As Contained database have no external dependencies.
What type of Authentication Modes are supported by Contained Database?
Contained Databases supports
  • SQL Server Authentication
  • Windows Based Authentication
A contained user is a user without a login in the master database which resides in a Contained Database and can connect to this database specifying its credentials in the connection string. This user doesn't exists in master’s syslogins tables and will not even show up when you list all SQL Users.


29 September 2012

Microsoft SQL Server 2000 Builds


BuildSQLSERVR.EXE BuildFile versionQKBKB / DescriptionDate UpdatedAvailability
8.00.23058.0.23052000.80.2305.0Q983811KB983811983811 MS12-060: Description of the security update for SQL Server 2000 Service Pack 4 QFE: August 14, 2012August 14, 2012Downloadable
8.00.23018.0.23012000.80.2301.0Q983809KB983809983809 MS12-027: Description of the security update for Microsoft SQL Server 2000 Service Pack 4 QFE: April 10, 2012April 10, 2012Downloadable
8.00.22838.0.22832000.80.2283.0Q971524KB971524971524 FIX: An access violation occurs when you run a DELETE statement or an UPDATE statement in the Itanium-based versions of SQL Server 2000 after you install security update MS09-004June 15, 2009Downloadable
8.00.22828.0.22822000.80.2282.0Q960083KB960083960083 MS09-004: Description of the security update for SQL Server 2000 QFE and for MSDE 2000: February 10, 2009February 10, 2009
8.00.22798.0.22792000.80.2279.0Q959678KB959678959678 FIX: When you run the SPSBackup.exe utility to back up a SQL Server 2000 database that is configured as a back-end database for a Windows SharePoint Services server, the backup operation failsApril 8, 2009Downloadable
8.00.22738.0.22732000.80.2273.0Q948111KB948111948111 MS08-040: Description of the security update for SQL Server 2000 QFE and MSDE 2000 July 8, 2008August 5, 2008
8.00.22718.0.22712000.80.2271.0Q946584KB946584946584 FIX: The SPACE function always returns one space in SQL Server 2000 if the SPACE function uses a collation that differs from the collation of the current databaseMarch 12, 2008
8.00.22658.0.22652000.80.2265.0Q944985KB944985944985 FIX: The data on the publisher does not match the data on the subscriber when you synchronize a SQL Server 2005 Mobile Edition subscriber with a SQL Server 2000 "merge replication" publisherDecember 19, 2007
8.00.22538.0.22532000.80.2253.0Q939317KB939317939317 FIX: The CPU utilization may suddenly increase to 100 percent when there are many connections to an instance of SQL Server 2000 on a computer that has  multiple processorsOctober 9, 2007
8.00.22498.0.22492000.80.2249.0Q936232KB936232936232 FIX: An access violation may occur when you try to log in to an instance of SQL Server 2000May 25, 2007
8.00.22488.0.22482000.80.2248.0Q935950KB935950935950 FIX: The foreign key that you created between two tables does not work after you run the CREATE INDEX statement in SQL Server 2000June 14, 2007
8.00.22468.0.22462000.80.2246.0Q935465KB935465935465 An updated version of Sqlvdi.dll is now available for SQL Server 2000June 18, 2007
8.00.22458.0.22452000.80.2245.0Q933573KB933573933573 FIX: You may receive an assertion or database corruption may occur when you use the bcp utility or the "Bulk Insert" Transact-SQL command to import data in SQL Server 2000April 24, 2007
8.00.22448.0.22442000.80.2244.0Q934203KB934203934203 FIX: A hotfix for Microsoft SQL Server 2000 Service Pack 4 may not update all the necessary files on an x64-based computerMay 10, 2007
8.00.22428.0.22422000.80.2242.0Q929131KB929131929131 FIX: In SQL Server 2000, the synchronization process is slow, and the CPU usage is high on the computer that is configured as the DistributorMarch 28, 2007
8.00.22388.0.22382000.80.2238.0Q931932KB931932931932 FIX: The merge agent fails intermittently when you use merge replication that uses a custom resolver after you install SQL Server 2000 Service Pack 4February 21, 2007
8.00.22368.0.22362000.80.2236.0Q930484KB930484930484 FIX: CPU utilization may approach 100 percent on a computer that is running SQL Server 2000 after you run the BACKUP DATABASE statement or the BACKUP LOG statementFebruary 2, 2007
8.00.22348.0.22342000.80.2234.0Q929440KB929440929440 FIX: Error messages when you try to update table rows or insert table rows into a table in SQL Server 2000: "644" or "2511"February 22, 2007
8.00.22328.0.22322000.80.2232.0Q928568KB928568928568 FIX: SQL Server 2000 stops responding when you cancel a query or when a query time-out occurs, and error messages are logged in the SQL Server error log fileJanuary 15, 2007
8.00.22318.0.22312000.80.2231.0Q928079KB928079928079 FIX: The Sqldumper.exe utility cannot generate a filtered SQL Server dump file when you use the Remote Desktop Connection service or Terminal Services to connect to a Windows 2000 Server-based computer in SQL Server 2000June 19, 2007
8.00.22298.0.22292000.80.2229.0Q927186KB927186927186 FIX: Error message when you create a merge replication for tables that have computed columns in SQL Server 2000 Service Pack 4: "The process could not log conflict information"July 24, 2007
8.00.22268.0.22262000.80.2226.0Q925684KB925684925684 FIX: You may experience one or more symptoms when you run a "CREATE INDEX" statement on an instance of SQL Server 2000November 20, 2006
8.00.22268.0.22262000.80.2226.0Q925732KB925732925732 FIX: You may receive inconsistent comparison results when you compare strings by using a width sensitive collation in SQL Server 2000November 13, 2006
8.00.22238.0.22232000.80.2223.0Q925419KB925419925419 FIX: The server stops responding, the performance is slow, and a time-out occurs in SQL Server 2000July 20, 2007
8.00.22238.0.22232000.80.2223.0Q925678KB925678925678 FIX: Error message when you schedule a Replication Merge Agent job to run after you install SQL Server 2000 Service Pack 4: "The process could not enumerate changes at the 'Subscriber'"October 31, 2006
8.00.22188.0.22182000.80.2218.0Q925297KB925297925297 FIX: The result may be sorted in the wrong order when you run a query that uses the ORDER BY clause to sort a column in a table in SQL Server 2000June 19, 2007
8.00.22178.0.22172000.80.2217.0Q924664KB924664924664 FIX: You cannot stop the SQL Server service, or many minidump files and many log files are generated in SQL Server 2000October 25, 2007
8.00.22158.0.22152000.80.2215.0Q923796KB923796923796 FIX: Data in a subscriber of a merge publication in SQL Server 2000 differs from the data in the publisherJanuary 12, 2007
8.00.22158.0.22152000.80.2215.0Q924662KB924662924662 FIX: The query performance may be slow when you query data from a view in SQL Server 2000October 5, 2006
8.00.22158.0.22152000.80.2215.0Q923563KB923563923563 FIX: Error message when you configure an immediate updating transactional replication in SQL Server 2000: "Implicit conversion from datatype 'text' to 'nvarchar' is not allowed"October 30, 2006
8.00.22158.0.22152000.80.2215.0Q923327KB923327923327 FIX: You may receive an access violation error message when you import data by using the "Bulk Insert" command in SQL Server 2000December 28, 2006
8.00.22098.0.22092000.80.2209.0Q923797KB923797923797 The Knowledge Base (KB) Article You Requested Is Currently Not Available
8.00.22078.0.22072000.80.2207.0Q923344KB923344923344 FIX: A SQL Server 2000 session may be blocked for the whole time that a Snapshot Agent job runsAugust 28, 2006
8.00.22018.0.22012000.80.2201.0Q920930KB920930920930 FIX: Error message when you try to run a query on a linked server in SQL Server 2000August 21, 2006
8.00.21998.0.21992000.80.2199.0Q919221KB919221919221 FIX: SQL Server 2000 may take a long time to complete the synchronization phase when you create a merge publicationJuly 26, 2006
8.00.21978.0.21972000.80.2197.0Q919133KB919133919133 FIX: Each query takes a long time to compile when you execute a single query or when you execute multiple concurrent queries in SQL Server 2000August 2, 2006
8.00.21978.0.21972000.80.2197.0Q919068KB919068919068 FIX: The query may return incorrect results, and the execution plan for the query may contain a "Table Spool" operator in SQL Server 2000August 8, 2006
8.00.21978.0.21972000.80.2197.0Q919399KB919399919399 FIX: A profiler trace in SQL Server 2000 may stop logging events unexpectedly, and you may receive the following error message: "Failed to read trace data"October 18, 2006
8.00.21968.0.21962000.80.2196.0Q919165KB919165919165 FIX: A memory leak occurs when you run a remote query by using a linked server in SQL Server 2000August 14, 2006
8.00.21948.0.21942000.80.2194.0Q917565KB917565917565 FIX: Error 17883 is logged in the SQL Server error log, and the instance of SQL Server 2000 temporarily stops respondingFebruary 21, 2007
8.00.21948.0.21942000.80.2194.0Q917972KB917972917972 FIX: You receive an access violation error message when you try to perform a read of a large binary large object column in SQL Server 2000September 22, 2006
8.00.21928.0.21922000.80.2192.0Q917606KB917606917606 FIX: You may notice a decrease in performance when you run a query that uses the UNION ALL operator in SQL Server 2000 Service Pack 4August 4, 2006
8.00.21918.0.21912000.80.2191.0Q916698KB916698916698 FIX: Error message when you run SQL Server 2000: "Failed assertion = 'lockFound == TRUE'"July 26, 2006
8.00.21918.0.21912000.80.2191.0Q916950KB916950916950 FIX: You may experience heap corruption, and SQL Server 2000 may shut down with fatal access violations when you try to browse files in SQL Server 2000 Enterprise Manager on a Windows Server 2003 x64-based computerOctober 3, 2006
8.00.21898.0.21892000.80.2189.0Q916652KB916652916652 FIX: An access violation may occur when you run a query on a table that has a multicolumn index in SQL Server 2000July 26, 2006
8.00.21898.0.21892000.80.2189.0Q913438KB913438913438 FIX: The SQL Server process may end unexpectedly when you turn on trace flag -T1204 and a profiler trace is capturing the Lock:DeadLock Chain event in SQL Server 2000 SP4July 19, 2006
8.00.21878.0.21872000.80.2187.0Q915340KB915340915340 FIX: A deadlock occurs when the scheduled SQL Server Agent job that you add or that you update is running in SQL Server 2000June 18, 2007
8.00.21878.0.21872000.80.2187.0Q916287KB916287916287 A cumulative hotfix package is available for SQL Server 2000 Service Pack 4 build 2187October 16, 2006Downloadable
8.00.21878.0.21872000.80.2187.0Q914384KB914384914384 FIX: The database status changes to Suspect when you perform a bulk copy in a transaction and then roll back the transaction in SQL Server 2000July 26, 2006
8.00.21878.0.21872000.80.2187.0Q915065KB915065915065 FIX: Error message when you try to apply a hotfix on a SQL Server 2000-based computer that is configured as a MSCS node: "An error in updating your system has occurred"December 11, 2006
8.00.21808.0.21802000.80.2180.0Q913789KB913789913789 FIX: The password that you specify in a BACKUP statement appears in the SQL Server Errorlog file or in the Application event log if the BACKUP statement does not run in SQL Server 2000February 19, 2007
8.00.21808.0.21802000.80.2180.0Q913684KB913684913684 FIX: You may receive error messages when you use linked servers in SQL Server 2000 on a 64-bit Itanium processorJuly 26, 2006
8.00.21758.0.21752000.80.2175.0Q911678KB911678911678 FIX: No rows may be returned, and you may receive an error message when you try to import SQL Profiler trace files into tables by using the fn_trace_gettable  function in SQL Server 2000July 26, 2006
8.00.21728.0.21722000.80.2172.0Q910707KB910707910707 FIX: When you query a view that was created by using the VIEW_METADATA option, an access violation may occur in SQL Server 2000July 26, 2006
8.00.21718.0.21712000.80.2171.0Q909369KB909369909369 FIX: Automatic checkpoints on some SQL Server 2000 databases do not run as expectedJuly 26, 2006
8.00.21688.0.21682000.80.2168.0Q907813KB907813907813 FIX: An error occurs when you try to access the Analysis Services performance monitor counter object after you apply Windows Server 2003 SP1November 21, 2006
8.00.21668.0.21662000.80.2166.0Q909734KB909734909734 FIX: An error message is logged, and new diagnostics do not capture the thread stack when the SQL Server User Mode Scheduler (UMS) experiences a nonyielding thread in SQL Server 2000 Service Pack 4July 26, 2006
8.00.21628.0.21622000.80.2162.0Q904660KB904660904660 A cumulative hotfix package is available for SQL Server 2000 Service Pack 4 build 2162September 15, 2006
8.00.21598.0.21592000.80.2159.0Q907250KB907250907250 FIX: You may experience concurrency issues when you run the DBCC INDEXDEFRAG statement in SQL Server 2000July 26, 2006
8.00.21568.0.21562000.80.2156.0Q906790KB906790906790 FIX: You receive an error message when you try to rebuild the master database after you have installed hotfix builds in SQL Server 2000 SP4 64-bitJuly 25, 2006
8.00.21518.0.21512000.80.2151.0Q903742KB903742903742 FIX: You receive an "Error: 8526, Severity: 16, State: 2" error message in SQL Profiler when you use SQL Query Analyzer to start or to enlist into a distributed transaction after you have installed SQL Server 2000 SP4July 25, 2006
8.00.21518.0.21512000.80.2151.0Q904244KB904244904244 FIX: Incorrect data is inserted unexpectedly when you perform a bulk copy operation by using the DB-Library API in SQL Server 2000 Service Pack 4June 13, 2007
8.00.21488.0.21482000.80.2148.0Q899430KB899430899430 FIX: An access violation may occur when you run a SELECT query and the NO_BROWSETABLE option is set to ON in Microsoft SQL Server 2000July 25, 2006
8.00.21488.0.21482000.80.2148.0Q899431KB899431899431 FIX: An access violation occurs in the Mssdi98.dll file, and SQL Server crashes when you use SQL Query Analyzer to debug a stored procedure in SQL Server 2000 Service Pack 4July 25, 2006
8.00.21488.0.21482000.80.2148.0Q900390KB900390900390 FIX: The Mssdmn.exe process may use lots of CPU capacity when you perform a SQL Server 2000 full text search of Office Word documentsJune 1, 2006
8.00.21488.0.21482000.80.2148.0Q900404KB900404900404 FIX: The results of the query may be returned much slower than you expect when you run a query that includes a GROUP BY statement in SQL Server 2000June 1, 2006
8.00.21488.0.21482000.80.2148.0Q901212KB901212901212 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 SP4July 25, 2006
8.00.21488.0.21482000.80.2148.0Q902150KB902150902150 FIX: Some 32-bit applications that use SQL-DMO and SQL-VDI APIs may stop working after you install SQL Server 2000 Service Pack 4 on an Itanium-based computerJune 1, 2006
8.00.21488.0.21482000.80.2148.0Q902955KB902955902955 FIX: You receive a "Getting registry information" message when you run the Sqldiag.exe utility after you install SQL Server 2000 SP4July 25, 2006
8.00.21478.0.21472000.80.2147.0Q899410KB899410899410 FIX: You may experience slow server performance when you start a trace in an instance of SQL Server 2000 that runs on a computer that has more than four processorsJune 1, 2006
8.00.21458.0.21452000.80.2145.0Q826906KB826906826906 FIX: A query that uses a view that contains a correlated subquery and an aggregate runs slowlyOctober 25, 2005
8.00.21458.0.21452000.80.2145.0Q836651KB836651836651 FIX: You receive query results that were not expected when you use both ANSI joins and non-ANSI joinsJune 7, 2006
8.00.20658.0.20652000.80.2065.0Q983808KB983808983808 MS12-027: Description of the security update for Microsoft SQL Server 2000 Service Pack 4 GDR: April 10, 2012April 10, 2012
8.00.20558.0.20552000.80.2055.0Q959420KB959420959420 MS09-004: Vulnerabilities in Microsoft SQL Server could allow remote code executionFebruary 10, 2009
8.00.20408.0.20402000.80.2040.0Q899761KB899761899761 FIX: Not all memory is available when AWE is enabled on a computer that is running a 32-bit version of SQL Server 2000 SP4August 15, 2006
8.00.20398.0.20392000.80.2039.0SQL Server 2000 Service Pack 4 (SP4)May 6, 2005Downloadable
8.00.20268.0.20262000.80.2026.0SQL Server 2000 Service Pack 4 (SP4) Beta
8.00.15478.0.15472000.80.1547.0Q899410KB899410899410 FIX: You may experience slow server performance when you start a trace in an instance of SQL Server 2000 that runs on a computer that has more than four processorsJune 1, 2006
8.00.10378.0.10372000.80.1037.0Q930484KB930484930484 FIX: CPU utilization may approach 100 percent on a computer that is running SQL Server 2000 after you run the BACKUP DATABASE statement or the BACKUP LOG statementFebruary 2, 2007
8.00.10368.0.10362000.80.1036.0Q929410KB929410929410 FIX: Error message when you run a full-text query in SQL Server 2000: "Error: 17883, Severity: 1, State: 0"January 11, 2007
8.00.10358.0.10352000.80.1035.0Q917593KB917593917593 FIX: The "Audit Logout" event does not appear in the trace results file when you run a profiler trace against a linked server instance in SQL Server 2000September 22, 2006
8.00.10348.0.10342000.80.1034.0Q915328KB915328915328 FIX: You may intermittently experience an access violation error when a query is executed in a parallel plan and the execution plan contains either a HASH JOIN operation or a Sort operation in SQL Server 2000August 9, 2006
8.00.10298.0.10292000.80.1029.0Q902852KB902852902852 FIX: Error message when you run an UPDATE statement that uses two JOIN hints to update a table in SQL Server 2000: "Internal SQL Server error"June 1, 2006
8.00.10278.0.10272000.80.1027.0Q900416KB900416900416 FIX: A 17883 error may occur you run a query that uses a hash join in SQL Server 2000July 25, 2006
8.00.10258.0.10252000.80.1025.0Q899428KB899428899428 FIX: You receive incorrect results when you run a query that uses a cross join operator in SQL Server 2000 SP3June 1, 2006
8.00.10258.0.10252000.80.1025.0Q899430KB899430899430 FIX: An access violation may occur when you run a SELECT query and the NO_BROWSETABLE option is set to ON in Microsoft SQL Server 2000July 25, 2006
8.00.10248.0.10242000.80.1024.0Q898709KB898709898709 FIX: Error message when you use SQL Server 2000: "Time out occurred while waiting for buffer latch type 3"July 25, 2006
8.00.10218.0.10212000.80.1021.0Q887700KB887700887700 FIX: Server Network Utility may display incorrect protocol properties in SQL Server 2000July 25, 2006
8.00.10208.0.10202000.80.1020.0Q896985KB896985896985 FIX: The Subscriber may not be able to upload changes to the Publisher when you incrementally add an article to a publication in SQL Server 2000 SP3July 25, 2006
8.00.10198.0.10192000.80.1019.0Q897572KB897572897572 FIX: You may receive a memory-related error message when you repeatedly create and destroy an out-of-process COM object within the same batch or stored procedure in SQL Server 2000June 1, 2006
8.00.10178.0.10172000.80.1017.0Q896425KB896425896425 FIX: The BULK INSERT statement silently skips insert attempts when the data value is NULL and the column is defined as NOT NULL for INT, SMALLINT, and BIGINT data types in SQL Server 2000June 1, 2006
8.00.10148.0.10142000.80.1014.0Q895123KB895123895123 FIX: You may receive error message 701, error message 802, and error message 17803 when many hashed buffers are available in SQL Server 2000June 1, 2006
8.00.10148.0.10142000.80.1014.0Q895187KB895187895187 FIX: You receive an error message when you try to delete records by running a Delete Transact-SQL statement in SQL Server 2000July 25, 2006
8.00.10138.0.10132000.80.1013.0Q891866KB891866891866 FIX: The query runs slower than you expected when you try to parse a query in SQL Server 2000June 1, 2006
8.00.10098.0.10092000.80.1009.0Q894257KB894257894257 FIX: You receive an "Incorrect syntax near ')'" error message when you run a script that was generated by SQL-DMO for an Operator object in SQL Server 2000June 1, 2006
8.00.10078.0.10072000.80.1007.0Q893312KB893312893312 FIX: You may receive a "SQL Server could not spawn process_loginread thread" error message, and a memory leak may occur when you cancel a remote query in SQL Server 2000June 1, 2006
8.00.10038.0.10032000.80.1003.0Q892923KB892923892923 FIX: Differential database backups may not contain database changes in the Page Free Space (PFS) pages in SQL Server 2000June 1, 2006
8.00.10018.0.10012000.80.1001.0Q892205KB892205892205 FIX: You may receive a 17883 error message when SQL Server 2000 performs a very large hash operationJune 1, 2006
8.00.10008.0.10002000.80.1000.0Q891585KB891585891585 FIX: Database recovery does not occur, or a user database is marked as suspect in SQL Server 2000June 1, 2006
8.00.9978.0.9972000.80.997.0Q891311KB891311891311 FIX: You cannot create new TCP/IP socket based connections after error messages 17882 and 10055 are written to the Microsoft SQL Server 2000 error logJuly 18, 2006
8.00.9968.0.9962000.80.996.0Q891017KB891017891017 FIX: SQL Server 2000 may stop responding to other requests when you perform a large deallocation operationJune 1, 2006
8.00.9968.0.9962000.80.996.0Q891268KB891268891268 FIX: You receive a 17883 error message and SQL Server 2000 may stop responding to other requests when you perform large in-memory sort operationsJune 1, 2006
8.00.9948.0.9942000.80.994.0Q890942KB890942890942 FIX: Some complex queries are slower after you install SQL Server 2000 Service Pack 2 or SQL Server 2000 Service Pack 3June 1, 2006
8.00.9948.0.9942000.80.994.0Q890768KB890768890768 FIX: You experience non-convergence in a replication topology when you unpublish or drop columns from a dynamically filtered publication in SQL Server 2000June 1, 2006
8.00.9948.0.9942000.80.994.0Q890767KB890767890767 FIX: You receive a "Server: Msg 107, Level 16, State 3, Procedure TEMP_VIEW_Merge, Line 1" error message when the sum of the length of the published column names in a merge publication exceeds 4,000 characters in SQL Server 2000June 1, 2006
8.00.9938.0.9932000.80.993.0Q890925KB890925890925 FIX: The @@ERROR system function may return an incorrect value when you execute a Transact-SQL statement that uses a parallel execution plan in SQL Server 2000 32-bit or in SQL Server 2000 64-bitJune 1, 2006
8.00.9938.0.9932000.80.993.0Q888444KB888444888444 FIX: You receive a 17883 error in SQL Server 2000 Service Pack 3 or in SQL Server 2000 Service Pack 3a when a worker thread becomes stuck in a registry callJune 1, 2006
8.00.9938.0.9932000.80.993.0Q890742KB890742890742 FIX: Error message when you use a loopback linked server to run a distributed query in SQL Server 2000: "Could not perform the requested operation because the  minimum query memory is not available"May 15, 2006
8.00.9918.0.9912000.80.991.0Q889314KB889314889314 FIX: Non-convergence may occur in a merge replication topology if the primary connection to the publisher is disconnectedJune 1, 2006
8.00.9908.0.9902000.80.990.0Q890200KB890200890200 FIX: SQL Server 2000 stops listening for new TCP/IP Socket connections unexpectedly after error message 17882 is written to the SQL Server 2000 error logJune 1, 2006
8.00.9888.0.9882000.80.988.0Q889166KB889166889166 FIX: You receive a "Msg 3628" error message when you run an inner join query in SQL Server 2000June 1, 2006
8.00.9858.0.9852000.80.985.0Q889239KB889239889239 FIX: Start times in the SQL Profiler are different for the Audit:Login and Audit:Logout Events in SQL Server 2000June 1, 2006
8.00.9808.0.9802000.80.980.0Q887974KB887974887974 FIX: A fetch on a dynamic cursor can cause unexpected results in SQL Server 2000 Service Pack 3 June 1, 2006
8.00.9778.0.9772000.80.977.0Q888007KB888007888007 You receive a "The product does not have a prerequisite update installed" error message when you try to install a SQL Server 2000 post-Service Pack 3 hotfixAugust 31, 2005
8.00.9738.0.9732000.80.973.0Q884554KB884554884554 FIX: A SPID stops responding with a NETWORKIO (0x800) waittype in SQL Server Enterprise Manager when SQL Server tries to process a fragmented TDS network packetJune 1, 2006
8.00.9728.0.9722000.80.972.0Q885290KB885290885290 FIX: An assertion error occurs when you insert data in the same row in a table by using multiple connections to an instance of SQL ServerJune 1, 2006
8.00.9708.0.9702000.80.970.0Q872842KB872842872842 FIX: A CHECKDB statement reports a 2537 corruption error after SQL Server transfers data to a sql_variant column in SQL Server 2000June 1, 2006
8.00.9678.0.9672000.80.967.0Q878501KB878501878501 FIX: You may receive an error message when you run a SET IDENTITY_INSERT ON statement on a table and then try to insert a row into the table in SQL Server 2000June 1, 2006
8.00.9628.0.9622000.80.962.0Q883415KB883415883415 FIX: A user-defined function returns results that are not correct for a queryJune 1, 2006
8.00.9618.0.9612000.80.961.0Q873446KB873446873446 FIX: An access violation exception may occur when multiple users try to perform data modification operations at the same time that fire triggers that reference a deleted or an inserted table in SQL Server 2000 on a computer that is running SMPJune 1, 2006
8.00.9598.0.9592000.80.959.0Q878500KB878500878500 FIX: An Audit Object Permission event is not produced when you run a TRUNCATE TABLE statementJune 1, 2006
8.00.9578.0.9572000.80.957.0Q870994KB870994870994 FIX: An access violation exception may occur when you run a query that uses index names in the WITH INDEX option to specify an index hintJune 1, 2006
8.00.9558.0.9552000.80.955.0Q867798KB867798867798 FIX: The @date_received parameter of the xp_readmail extended stored procedure incorrectly returns the date and the time that an e-mail message is submitted by the sender in SQL Server 2000January 8, 2007
8.00.9548.0.9542000.80.954.0Q843282KB843282843282 FIX: The Osql.exe utility does not run a Transact-SQL script completely if you start the program from a remote session by using a background service and then log off the console sessionJanuary 5, 2007
8.00.9528.0.9522000.80.952.0Q867878KB867878867878 FIX: The Log Reader Agent may cause 17883 error messagesJune 1, 2006
8.00.9528.0.9522000.80.952.0Q867879KB867879867879 FIX: Merge replication non-convergence occurs with SQL Server CE subscribersJune 1, 2006
8.00.9528.0.9522000.80.952.0Q867880KB867880867880 FIX: Merge Agent may fail with an "Invalid character value for cast specification" error messageJune 1, 2006
8.00.9498.0.9492000.80.949.0Q843266KB843266843266 FIX: Shared page locks can be held until end of the transaction and can cause blocking or performance problems in SQL Server 2000 Service Pack 3 (SP3)June 2, 2006
8.00.9488.0.9482000.80.948.0Q843263KB843263843263 FIX: You may receive an 8623 error message when you try to run a complex query on an instance of SQL ServerJune 1, 2006
8.00.9448.0.9442000.80.944.0Q839280KB839280839280 FIX: SQL debugging does not work in Visual Studio .NET after you install Windows XP Service Pack 2June 5, 2006
8.00.9378.0.9372000.80.937.0Q841776KB841776841776 FIX: Additional diagnostics have been added to SQL Server 2000 to detect unreported read operation failuresJune 1, 2006
8.00.9368.0.9362000.80.936.0Q841627KB841627841627 FIX: SQL Server 2000 may underestimate the cardinality of a query expression under certain circumstancesJune 1, 2006
8.00.9358.0.9352000.80.935.0Q841401KB841401841401 FIX: You may notice incorrect values for the "Active Transactions" counter when you perform multiple transactions on an instance of SQL Server 2000 that is  running on an SMP computerJune 1, 2006
8.00.9348.0.9342000.80.934.0Q841404KB841404841404 FIX: You may receive a "The query processor could not produce a query plan" error message in SQL Server when you run a query that includes multiple subqueries that use self-joinsJune 1, 2006
8.00.9338.0.9332000.80.933.0Q840856KB840856840856 FIX: The MSSQLServer service exits unexpectedly in SQL Server 2000 Service Pack 3June 2, 2006
8.00.9298.0.9292000.80.929.0Q839529KB839529839529 FIX: 8621 error conditions may cause SQL Server 2000 64-bit to close unexpectedlyJune 1, 2006
8.00.9288.0.9282000.80.928.0Q839589KB839589839589 FIX: The thread priority is raised for some threads in a parallel queryJune 1, 2006
8.00.9278.0.9272000.80.927.0Q839688KB839688839688 FIX: Profiler RPC events truncate parameters that have a text data type to 16 charactersJune 1, 2006
8.00.9268.0.9262000.80.926.0Q839523KB839523839523 FIX: An access violation exception may occur when you update a text column by using a stored procedure in SQL Server 2000June 1, 2006
8.00.9238.0.9232000.80.923.0Q838460KB838460838460 FIX: The xp_logininfo procedure may fail with error 8198 after you install Q825042 or any hotfix with SQL Server 8.00.0840 or laterJune 1, 2006
8.00.9228.0.9222000.80.922.0Q837970KB837970837970 FIX: You may receive an "Invalid object name..." error message when you run the DBCC CHECKCONSTRAINTS Transact-SQL statement on a table in SQL Server 2000October 25, 2005
8.00.9198.0.9192000.80.919.0Q837957KB837957837957 FIX: When you use Transact-SQL cursor variables to perform operations that have large iterations, memory leaks may occur in SQL Server 2000October 25, 2005
8.00.9168.0.9162000.80.916.0Q317989KB317989317989 FIX: Sqlakw32.dll May Corrupt SQL StatementsSeptember 27, 2005
8.00.9158.0.9152000.80.915.0Q837401KB837401837401 FIX: Rows are not successfully inserted into a table when you use the BULK INSERT command to insert rowsOctober 25, 2005
8.00.9138.0.9132000.80.913.0Q836651KB836651836651 FIX: You receive query results that were not expected when you use both ANSI joins and non-ANSI joinsJune 7, 2006
8.00.9118.0.9112000.80.911.0Q837957KB837957837957 FIX: When you use Transact-SQL cursor variables to perform operations that have large iterations, memory leaks may occur in SQL Server 2000October 25, 2005
8.00.9108.0.9102000.80.910.0Q834798KB834798834798 FIX: SQL Server 2000 may not start if many users try to log in to SQL Server when SQL Server is trying to startOctober 25, 2005
8.00.9088.0.9082000.80.908.0Q834290KB834290834290 FIX: You receive a 644 error message when you run an UPDATE statement and the isolation level is set to READ UNCOMMITTEDOctober 25, 2005
8.00.9048.0.9042000.80.904.0Q834453KB834453834453 FIX: The Snapshot Agent may fail after you make schema changes to the underlying tables of a publicationApril 22, 2005
8.00.8928.0.8922000.80.892.0Q833710KB833710833710 FIX: You receive an error message when you try to restore a database backup that spans multiple devicesOctober 25, 2005
8.00.8918.0.8912000.80.891.0Q836141KB836141836141 FIX: An access violation exception may occur when SQL Server runs many parallel query processing operations on a multiprocessor computerApril 1, 2005
8.00.8798.0.8792000.80.879.0Q832977KB832977832977 FIX: The DBCC PSS Command may cause access violations and 17805 errors in SQL  Server 2000October 25, 2005
8.00.8788.0.8782000.80.878.0Q831950KB831950831950 FIX: You receive error message 3456 when you try to apply a transaction log to a serverOctober 25, 2005
8.00.8768.0.8762000.80.876.0Q830912KB830912830912 FIX: Key Names Read from an .Ini File for a Dynamic Properties Task May Be TruncatedOctober 25, 2005
8.00.8768.0.8762000.80.876.0Q831997KB831997831997 FIX: An invalid cursor state occurs after you apply Hotfix 8.00.0859 or later in SQL Server 2000October 25, 2005
8.00.8768.0.8762000.80.876.0Q831999KB831999831999 FIX: An AWE system uses more memory for sorting or for hashing than a non-AWE system in SQL Server 2000October 25, 2005
8.00.8738.0.8732000.80.873.0Q830887KB830887830887 FIX: Some queries that have a left outer join and an IS NULL filter run slower after you install SQL Server 2000 post-SP3 hotfixOctober 25, 2005
8.00.8718.0.8712000.80.871.0Q830767KB830767830767 FIX: SQL Query Analyzer may stop responding when you close a query window or open a fileOctober 25, 2005
8.00.8718.0.8712000.80.871.0Q830860KB830860830860 FIX: The performance of a computer that is running SQL Server 2000 degrades when query execution plans against temporary tables remain in the procedure cache October 25, 2005
8.00.8708.0.8702000.80.870.0Q830262KB830262830262 FIX: Unconditional Update May Not Hold Key Locks on New Key ValuesOctober 25, 2005
8.00.8698.0.8692000.80.869.0Q830588KB830588830588 FIX: Access violation when you trace keyset-driven cursors by using SQL ProfilerOctober 25, 2005
8.00.8668.0.8662000.80.866.0Q830366KB830366830366 FIX: An access violation occurs in SQL Server 2000 when a high volume of local shared memory connections occur after you install security update MS03-031January 16, 2006
8.00.8658.0.8652000.80.865.0Q830395KB830395830395 FIX: An access violation occurs during compilation if the table contains statistics for a computed columnOctober 25, 2005
8.00.8658.0.8652000.80.865.0Q828945KB828945828945 FIX: You cannot insert explicit values in an IDENTITY column of a SQL Server table by using the SQLBulkOperations function or the SQLSetPos ODBC function in SQL Server 2000October 25, 2005
8.00.8638.0.8632000.80.863.0Q829205KB829205829205 FIX: Query performance may be slow and may be inconsistent when you run a query while another query that contains an IN operator with many values is compiledOctober 25, 2005
8.00.8638.0.8632000.80.863.0Q829444KB829444829444 FIX: A floating point exception occurs during the optimization of a queryOctober 25, 2005
8.00.8598.0.8592000.80.859.0Q821334KB821334821334 FIX: Issues that are resolved in SQL Server 2000 build 8.00.0859March 31, 2005
8.00.8588.0.8582000.80.858.0Q828637KB828637828637 FIX: Users Can Control the Compensating Change Process in Merge ReplicationOctober 25, 2005
8.00.8578.0.8572000.80.857.0Q828017KB828017828017 The Knowledge Base (KB) Article You Requested Is Currently Not Available
8.00.8578.0.8572000.80.857.0Q827714KB827714827714 FIX: A query may fail with retail assertion when you use the NOLOCK hint or the READ UNCOMMITTED isolation levelNovember 23, 2005
8.00.8578.0.8572000.80.857.0Q828308KB828308828308 FIX: An Internet Explorer script error occurs when you access metadata information by using DTS in SQL Server Enterprise ManagerOctober 25, 2005
8.00.8568.0.8562000.80.856.0Q828096KB828096828096 FIX: Key Locks Are Held Until the End of the Statement for Rows That Do Not Pass Filter CriteriaOctober 25, 2005
8.00.8548.0.8542000.80.854.0Q828699KB828699828699 FIX: An Access Violation Occurs When You Run DBCC UPDATEUSAGE on a Database That Has Many ObjectsOctober 25, 2005
8.00.8528.0.8522000.80.852.0Q830466KB830466830466 FIX: You may receive an "Internal SQL Server error" error message when you run a Transact-SQL SELECT statement on a view that has many subqueries in SQL Server 2000April 1, 2005
8.00.8528.0.8522000.80.852.0Q827954KB827954827954 FIX: Slow Execution Times May Occur When You Run DML Statements Against Tables That Have Cascading Referential Integrity October 25, 2005
8.00.8518.0.8512000.80.851.0Q826754KB826754826754 FIX: A Deadlock Occurs If You Run an Explicit UPDATE STATISTICS CommandOctober 25, 2005
8.00.8508.0.8502000.80.850.0Q826860KB826860826860 FIX: Linked Server Query May Return NULL If It Is Performed Through a Keyset CursorOctober 25, 2005
8.00.8508.0.8502000.80.850.0Q826815KB826815826815 FIX: You receive an 8623 error message in SQL Server when you try to run a query that has multiple correlated subqueriesOctober 25, 2005
8.00.8508.0.8502000.80.850.0Q826906KB826906826906 FIX: A query that uses a view that contains a correlated subquery and an aggregate runs slowlyOctober 25, 2005
8.00.8488.0.8482000.80.848.0Q826822KB826822826822 FIX: A Member of the db_accessadmin Fixed Database Role Can Create an Alias for the dbo Special UserOctober 25, 2005
8.00.8478.0.8472000.80.847.0Q826433KB826433826433 PRB: Additional SQL Server Diagnostics Added to Detect Unreported I/O ProblemsOctober 25, 2005
8.00.8458.0.8452000.80.845.0Q826364KB826364826364 FIX: A Query with a LIKE Comparison Results in a Non-Optimal Query Plan When You Use a Hungarian SQL Server CollationOctober 5, 2005
8.00.8458.0.8452000.80.845.0Q825854KB825854825854 FIX: No Exclusive Locks May Be Taken If the DisAllowsPageLocks Value Is Set to TrueOctober 25, 2005
8.00.8448.0.8442000.80.844.0Q826080KB826080826080 FIX: SQL Server 2000 protocol encryption applies to JDBC clientsOctober 17, 2006
8.00.8428.0.8422000.80.842.0Q825043KB825043825043 FIX: Rows are unexpectedly deleted when you run a distributed query to delete or to update a linked server tableOctober 25, 2005
8.00.8418.0.8412000.80.841.0Q825225KB825225825225 FIX: You receive an error message when you run a parallel query that uses an aggregation function or the GROUP BY clauseOctober 25, 2005
8.00.8408.0.8402000.80.840.0Q319477KB319477319477 FIX: Extremely Large Number of User Tables on AWE System May Cause BPool::Map ErrorsSeptember 27, 2005
8.00.8408.0.8402000.80.840.0Q319477KB319477319477 FIX: Extremely Large Number of User Tables on AWE System May Cause BPool::Map ErrorsSeptember 27, 2005
8.00.8398.0.8392000.80.839.0Q823877KB823877823877 FIX: An Access Violation May Occur When You Run a Query That Contains 32,000 or More OR ClausesOctober 25, 2005
8.00.8398.0.8392000.80.839.0Q824027KB824027824027 FIX: A Cursor with a Large Object Parameter May Cause an Access Violation on CStmtCond::XretExecuteOctober 25, 2005
8.00.8378.0.8372000.80.837.0Q820788KB820788820788 FIX: Delayed domain authentication may cause SQL Server to stop respondingOctober 25, 2005
8.00.8378.0.8372000.80.837.0Q821741KB821741821741 FIX: Lock monitor exception in DeadlockMonitor::ResolveDeadlockOctober 25, 2005
8.00.8378.0.8372000.80.837.0Q821548KB821548821548 FIX: A Parallel Query May Generate an Access Violation After You Install SQL Server 2000 SP3October 25, 2005
8.00.8378.0.8372000.80.837.0Q821740KB821740821740 FIX: MS DTC Transaction Commit Operation Blocks ItselfOctober 25, 2005
8.00.8378.0.8372000.80.837.0Q823514KB823514823514 FIX: Build 8.00.0837: A query that contains a correlated subquery runs slowlyOctober 25, 2005
8.00.8198.0.8192000.80.819.0Q826161KB826161826161 FIX: You are prompted for password confirmation after you change a standard SQL Server login October 25, 2005
8.00.8188.0.8182000.80.818.0Q821277KB821277821277 MS03-031: Security patch for SQL Server 2000 Service Pack 3January 9, 2006
8.00.8188.0.8182000.80.818.0Q821337KB821337821337 FIX: Localized versions of SQL Mail and the Web Assistant Wizard may not work as expected in SQL Server 2000 64 bitMarch 16, 2005
8.00.8188.0.8182000.80.818.0Q818388KB818388818388 FIX: A Transact-SQL Statement That Is Embedded in the Database Name Runs with System Administrator PermissionsFebruary 10, 2005
8.00.8188.0.8182000.80.818.0Q826161KB826161826161 FIX: You are prompted for password confirmation after you change a standard SQL Server login October 25, 2005
8.00.8188.0.8182000.80.818.0Q821280KB821280821280 MS03-031: Security Patch for SQL Server 2000 64-bitMarch 14, 2006
8.00.8168.0.8162000.80.816.0Q818766KB818766818766 FIX: Intense SQL Server activity results in spinloop waitOctober 25, 2005
8.00.8148.0.8142000.80.814.0Q819662KB819662819662 FIX: Distribution Cleanup Agent Incorrectly Cleans Up Entries for Anonymous SubscribersOctober 25, 2005
8.00.8118.0.8112000.80.811.0Q819248KB819248819248 FIX: An access violation exception may occur when you insert a row in a table that is referenced by indexed views in SQL Server 2000April 3, 2006
8.00.8118.0.8112000.80.811.0Q819662KB819662819662 FIX: Distribution Cleanup Agent Incorrectly Cleans Up Entries for Anonymous SubscribersOctober 25, 2005
8.00.8118.0.8112000.80.811.0Q818897KB818897818897 FIX: Invalid TDS Sent to SQL Server Results in Access ViolationOctober 25, 2005
8.00.8078.0.8072000.80.807.0Q818899KB818899818899 FIX: Error Message 3628 May Occur When You Run a Complex QueryOctober 25, 2005
8.00.8048.0.8042000.80.804.0Q818729KB818729818729 FIX: Internal Query Processor Error 8623 When Microsoft SQL Server Tries to Compile a Plan for a Complex QueryOctober 25, 2005
8.00.8018.0.8012000.80.801.0Q818540KB818540818540 FIX: SQL Server Enterprise Manager unexpectedly quits when you modify a DTS packageJanuary 26, 2006
8.00.8008.0.8002000.80.800.0Q818414KB818414818414 FIX: The Sqldumper.exe File Does Not Generate a Userdump File When It Runs Against a Windows ServiceSeptember 27, 2005
8.00.8008.0.8002000.80.800.0Q818097KB818097818097 FIX: An Access Violation May Occur When You Run DBCC DBREINDEX on a Table That Has Hypothetical IndexesSeptember 27, 2005
8.00.8008.0.8002000.80.800.0Q818188KB818188818188 FIX: Query on the sysmembers Virtual Table May Fail with a Stack OverflowSeptember 27, 2005
8.00.7988.0.7982000.80.798.0Q817464KB817464817464 FIX: Using Sp_executesql in Merge Agent OperationsSeptember 27, 2005
8.00.7948.0.7942000.80.794.0Q817464KB817464817464 FIX: Using Sp_executesql in Merge Agent OperationsSeptember 27, 2005
8.00.7948.0.7942000.80.794.0Q813524KB813524813524 FIX: OLE DB conversion errors may occur after you select a literal string that represents datetime data as a columnSeptember 27, 2005
8.00.7948.0.7942000.80.794.0Q816440KB816440816440 FIX: Error 8623 is Raised When SQL Server Compiles a Complex QuerySeptember 27, 2005
8.00.7948.0.7942000.80.794.0Q817709KB817709817709 FIX: SQL Server 2000 might produce an incorrect cardinality estimate for outer joinsFebruary 11, 2005
8.00.7918.0.7912000.80.791.0Q815249KB815249815249 FIX: Performance of a query that is run from a client program on a SQL Server SP3 database is slow after you restart the instance of SQL ServerSeptember 27, 2005
8.00.7908.0.7902000.80.790.0Q817081KB817081817081 FIX: You receive an error message when you use the SQL-DMO BulkCopy object to import data into a SQL Server tableSeptember 27, 2005
8.00.7898.0.7892000.80.789.0Q816840KB816840816840 FIX: Error 17883 May Display Message Text That Is Not CorrectSeptember 27, 2005
8.00.7888.0.7882000.80.788.0Q816985KB816985816985 FIX: You cannot install SQL Server 2000 SP3 on the Korean version of SQL Server 2000September 27, 2005
8.00.7818.0.7812000.80.781.0Q815057KB815057815057 FIX: SQL Server 2000 Uninstall Option Does Not Remove All FilesSeptember 27, 2005
8.00.7808.0.7802000.80.780.0Q816039KB816039816039 FIX: Code Point Comparison Semantics for SQL_Latin1_General_Cp850_BIN  CollationSeptember 27, 2005
8.00.7808.0.7802000.80.780.0Q816084KB816084816084 FIX: sysindexes.statblob Column May Be Corrupted After You Run a DBCC DBREINDEX StatementSeptember 27, 2005
8.00.7808.0.7802000.80.780.0Q810185KB810185810185 SQL Server 2000 hotfix update for SQL Server 2000 Service Pack 3 and 3aOctober 10, 2006
8.00.7798.0.7792000.80.779.0Q814035KB814035814035 FIX: A Full-Text Population Fails After You Apply SQL Server 2000 Service Pack 3September 27, 2005
8.00.7768.0.7762000.80.776.0Unidentified
8.00.7758.0.7752000.80.775.0Q815115KB815115815115 FIX: A DTS package that uses global variables ignores an error message raised by RAISERRORSeptember 27, 2005
8.00.7698.0.7692000.80.769.0Q814889KB814889814889 FIX: A DELETE statement with a JOIN might fail and you receive a 625 errorSeptember 27, 2005
8.00.7698.0.7692000.80.769.0Q814893KB814893814893 FIX: Error Message: "Insufficient key column information for updating" Occurs in SQL Server 2000 SP3September 27, 2005
8.00.7658.0.7652000.80.765.0Q810163KB810163810163 FIX: An Access Violation Occurs if an sp_cursoropen Call References a Parameter That Is Not DefinedSeptember 27, 2005
8.00.7658.0.7652000.80.765.0Q810688KB810688810688 FIX: Merge Agent Can Resend Changes for Filtered PublicationsSeptember 27, 2005
8.00.7658.0.7652000.80.765.0Q811611KB811611811611 FIX: Reinitialized SQL Server CE 2.0 subscribers may experience data loss and non-convergenceSeptember 27, 2005
8.00.7658.0.7652000.80.765.0Q813769KB813769813769 FIX: You May Experience Slow Performance When You Debug a SQL Server ServiceSeptember 27, 2005
8.00.7638.0.7632000.80.763.0Q814113KB814113814113 FIX: DTS Designer may generate an access violation after you install SQL Server 2000 Service Pack 3September 27, 2005
8.00.7628.0.7622000.80.762.0Q814032KB814032814032 FIX: Merge publications cannot synchronize on SQL Server 2000 Service Pack 3September 27, 2005
8.00.7608.0.7602000.80.760.0SQL Server 2000 Service Pack 3 (SP3 / SP3a)August 27, 2003Downloadable
8.00.7438.0.7432000.80.743.0Q818406KB818406818406 FIX: A Transact-SQL query that uses views may fail unexpectedly in SQL Server 2000 SP2October 18, 2005
8.00.7438.0.7432000.80.743.0Q818763KB818763818763 FIX: Intense SQL Server Activity Results in Spinloop Wait in SQL Server 2000 Service Pack 2October 25, 2005
8.00.7418.0.7412000.80.741.0Q818096KB818096818096 FIX: Many Extent Lock Time-outs May Occur During Extent AllocationFebruary 10, 2005
8.00.7368.0.7362000.80.736.0Q816937KB816937816937 FIX: A memory leak may occur when you use the sp_OAMethod stored procedure to  call a method of a COM objectSeptember 27, 2005
8.00.7358.0.7352000.80.735.0Q814889KB814889814889 FIX: A DELETE statement with a JOIN might fail and you receive a 625 errorSeptember 27, 2005
8.00.7338.0.7332000.80.733.0Q813759KB813759813759 FIX: A Large Number of NULL Values in Join Columns Result in Slow Query PerformanceSeptember 27, 2005
8.00.7308.0.7302000.80.730.0Q813769KB813769813769 FIX: You May Experience Slow Performance When You Debug a SQL Server ServiceSeptember 27, 2005
8.00.7288.0.7282000.80.728.0Q814460KB814460814460 FIX: Merge Replication with Alternate Synchronization Partners May Not Succeed After You Change the Retention PeriodSeptember 27, 2005
8.00.7258.0.7252000.80.725.0Q812995KB812995812995 FIX: A Query with an Aggregate Function May Fail with a 3628 ErrorSeptember 27, 2005
8.00.7258.0.7252000.80.725.0Q813494KB813494813494 FIX: Distribution Agent Fails with "Violation of Primary Key Constraint" Error MessageSeptember 27, 2005
8.00.7238.0.7232000.80.723.0Q812798KB812798812798 FIX: A UNION ALL View May Not Use Index If Partitions Are Removed at Compile TimeSeptember 27, 2005
8.00.7218.0.7212000.80.721.0Q812250KB812250812250 FIX: Indexed View May Cause a Handled Access Violation in CIndex::SetLevel1NamesSeptember 27, 2005
8.00.7218.0.7212000.80.721.0Q812393KB812393812393 FIX: Update or Delete Statement Fails with Error 1203 During Row Lock EscalationSeptember 27, 2005
8.00.7188.0.7182000.80.718.0Q811703KB811703811703 FIX: Unexpected results from partial aggregations based on conversionsSeptember 27, 2005
8.00.7158.0.7152000.80.715.0Q810688KB810688810688 FIX: Merge Agent Can Resend Changes for Filtered PublicationsSeptember 27, 2005
8.00.7158.0.7152000.80.715.0Q811611KB811611811611 FIX: Reinitialized SQL Server CE 2.0 subscribers may experience data loss and non-convergenceSeptember 27, 2005
8.00.7148.0.7142000.80.714.0Q811478KB811478811478 FIX: Restoring a SQL Server 7.0 database backup in SQL Server 2000 Service Pack 2 (SP2) may cause an assertion error in the Xdes.cpp fileOctober 18, 2005
8.00.7138.0.7132000.80.713.0Q811205KB811205811205 FIX: An error message occurs when you perform a database or a file SHRINK operationSeptember 27, 2005
8.00.7108.0.7102000.80.710.0Q811052KB811052811052 FIX: Latch Time-Out Message 845 Occurs When You Perform a Database or File SHRINK OperationSeptember 27, 2005
8.00.7058.0.7052000.80.705.0Q810920KB810920810920 FIX: The JOIN queries in the triggers that involve the inserted table or the deleted table may return results that are not consistentSeptember 27, 2005
8.00.7038.0.7032000.80.703.0Q810526KB810526810526 FIX: Cursors That Have a Long Lifetime May Cause Memory FragmentationSeptember 27, 2005
8.00.7028.0.7022000.80.702.0Q328551KB328551328551 FIX: Concurrency enhancements for the tempdb databaseJuly 19, 2006
8.00.7018.0.7012000.80.701.0Q810026KB810026810026 FIX: A DELETE Statement with a Self-Join May Fail and You Receive a 625 ErrorSeptember 27, 2005
8.00.7018.0.7012000.80.701.0Q810163KB810163810163 FIX: An Access Violation Occurs if an sp_cursoropen Call References a Parameter That Is Not DefinedSeptember 27, 2005
8.00.7008.0.7002000.80.700.0Q810072KB810072810072 FIX: Merge Replication Reconciler Stack OverflowSeptember 27, 2005
8.00.6968.0.6962000.80.696.0Q810052KB810052810052 FIX: A Memory Leak Occurs When Cursors Are Opened During a ConnectionSeptember 27, 2005
8.00.6968.0.6962000.80.696.0Q810010KB810010810010 FIX: The fn_get_sql System Table Function May Cause Various Handled Access ViolationsSeptember 27, 2005
8.00.6958.0.6952000.80.695.0Q331885KB331885331885 FIX: Update/Delete Statement Fails with Error 1203 During Page Lock EscalationSeptember 27, 2005
8.00.6958.0.6952000.80.695.0Q331965KB331965331965 FIX: The xp_readmail Extended Stored Procedure Overwrites Attachment That Already ExistsFebruary 10, 2005
8.00.6958.0.6952000.80.695.0Q331968KB331968331968 FIX: The xp_readmail and xp_findnextmsg Extended Stored Procedures Do Not Read Mail in Time Received OrderFebruary 10, 2005
8.00.6938.0.6932000.80.693.0Q330212KB330212330212 FIX: Parallel logical operation returns results that are not consistentSeptember 27, 2005
8.00.6908.0.6902000.80.690.0Q311104KB311104311104 FIX: The SELECT Statement with Parallelism Enabled May Cause an AssertionOctober 12, 2005
8.00.6898.0.6892000.80.689.0Q329499KB329499329499 FIX: Replication Removed from Database After Restore WITH RECOVERYOctober 11, 2005
8.00.6888.0.6882000.80.688.0Q329487KB329487329487 FIX: Transaction Log Restore Fails with Message 3456October 11, 2005
8.00.6868.0.6862000.80.686.0Q316333KB316333316333 SQL Server 2000 Security Update for Service Pack 2November 24, 2006
8.00.6828.0.6822000.80.682.0Q319851KB319851319851 FIX: Assertion and Error Message 3314 Occurs If You Try to Roll Back a Text Operation with READ UNCOMMITTEDOctober 18, 2005
8.00.6798.0.6792000.80.679.0Q316333KB316333316333 SQL Server 2000 Security Update for Service Pack 2November 24, 2006
8.00.6788.0.6782000.80.678.0Q328354KB328354328354 FIX: A RESTORE DATABASE WITH RECOVERY Statement Can Fail with Error 9003 or Error 9004September 27, 2005
8.00.6678.0.6672000.80.667.02000 SP2+8/14 fix
8.00.6658.0.6652000.80.665.02000 SP2+8/8 fix
8.00.6618.0.6612000.80.661.0Q326999KB326999326999 FIX: Lock escalation on a scan while an update query is running causes a 1203 error message to occurSeptember 27, 2005
8.00.6558.0.6552000.80.655.02000 SP2+7/24 fix
8.00.6528.0.6522000.80.652.0Q810010KB810010810010 FIX: The fn_get_sql System Table Function May Cause Various Handled Access ViolationsSeptember 27, 2005
8.00.6508.0.6502000.80.650.0Q322853KB322853322853 FIX: SQL Server Grants Unnecessary Permissions or an Encryption Function Contains Unchecked BuffersNovember 5, 2003
8.00.6448.0.6442000.80.644.0Q324186KB324186324186 FIX: Slow Compile Time and Execution Time with Query That Contains Aggregates and SubqueriesSeptember 27, 2005
8.00.6088.0.6082000.80.608.0Q319507KB319507319507 FIX: SQL Extended Procedure Functions Contain Unchecked BuffersJune 21, 2004
8.00.6048.0.6042000.80.604.02000 SP2+3/29 fix
8.00.5998.0.5992000.80.599.0Q319869KB319869319869 FIX: Improved SQL Manager Robustness for Odd Length BufferSeptember 27, 2005
8.00.5948.0.5942000.80.594.0Q319477KB319477319477 FIX: Extremely Large Number of User Tables on AWE System May Cause BPool::Map ErrorsSeptember 27, 2005
8.00.5848.0.5842000.80.584.0Q318530KB318530318530 FIX: Reorder outer joins with filter criteria before non-selective joins and outer joinsFebruary 4, 2008
8.00.5788.0.5782000.80.578.0Q317979KB317979317979 FIX: Unchecked Buffer May Occur When You Connect to Remote Data SourceSeptember 27, 2005
8.00.5788.0.5782000.80.578.0Q318045KB318045318045 FIX: SELECT with Timestamp Column That Uses FOR XML AUTO May Fail with Stack Overflow or AVSeptember 27, 2005
8.00.5618.0.5612000.80.561.02000 SP2+1/29 fix
8.00.5588.0.5582000.80.558.0Q314003KB314003314003 FIX: Query That Uses DESC Index May Result in Access ViolationSeptember 26, 2005
8.00.5588.0.5582000.80.558.0Q315395KB315395315395 FIX: COM May Not Be Uninitialized for Worker Thread When You Use sp_OASeptember 27, 2005
8.00.5528.0.5522000.80.552.0Q313002KB313002313002 The Knowledge Base (KB) Article You Requested Is Currently Not Available
8.00.5528.0.5522000.80.552.0Q313005KB313005313005 FIX: SELECT from Computed Column That References UDF Causes SQL Server to TerminateSeptember 26, 2005
8.00.5348.0.5342000.80.534.02000 SP2.01
8.00.5328.0.5322000.80.532.0SQL Server 2000 Service Pack 2 (SP2)February 4, 2003Downloadable
8.00.4758.0.4752000.80.475.02000 SP1+1/29 fix
8.00.4748.0.4742000.80.474.0Q315395KB315395315395 FIX: COM May Not Be Uninitialized for Worker Thread When You Use sp_OASeptember 27, 2005
8.00.4738.0.4732000.80.473.0Q314003KB314003314003 FIX: Query That Uses DESC Index May Result in Access ViolationSeptember 26, 2005
8.00.4718.0.4712000.80.471.0Q313302KB313302313302 FIX: Shared Table Lock Is Not Released After Lock Escalation September 26, 2005
8.00.4698.0.4692000.80.469.0Q313005KB313005313005 FIX: SELECT from Computed Column That References UDF Causes SQL Server to TerminateSeptember 26, 2005
8.00.4528.0.4522000.80.452.0Q308547KB308547308547 FIX: SELECT DISTINCT from Table with LEFT JOIN of View Causes Error Messages or Client Application May Stop RespondingSeptember 26, 2005
8.00.4448.0.4442000.80.444.0Q307540KB307540307540 FIX: SQLPutData May Result in Leak of Buffer Pool MemorySeptember 26, 2005
8.00.4448.0.4442000.80.444.0Q307655KB307655307655 FIX: Querying Syslockinfo with Large Numbers of Locks May Cause Server to Stop RespondingOctober 7, 2005
8.00.4438.0.4432000.80.443.0Q307538KB307538307538 FIX: SQLTrace Start and Stop is Now Reported in Windows NT Event Log for SQL Server 2000September 26, 2005
8.00.4288.0.4282000.80.428.0Q304850KB304850304850 FIX: SQL Server Text Formatting Functions Contain Unchecked BuffersAugust 5, 2004
8.00.3848.0.3842000.80.384.0SQL Server 2000 Service Pack 1 (SP1)June 11, 2001Downloadable
8.00.2968.0.2962000.80.296.0Q299717KB299717299717 FIX: Query Method Used to Access Data May Allow Rights that the Login Might Not Normally HaveAugust 9, 2004
8.00.2878.0.2872000.80.287.0Q297209KB297209297209 FIX: Deletes, Updates and Rank Based Selects May Cause Deadlock of MSSEARCHOctober 7, 2005
8.00.2518.0.2512000.80.251.0Q300194KB300194300194 FIX: Error 644 Using Two Indexes on a Column with Uppercase Preference Sort OrderOctober 17, 2003
8.00.2508.0.2502000.80.250.0Q291683KB291683291683 The Knowledge Base (KB) Article You Requested Is Currently Not Available
8.00.2498.0.2492000.80.249.0Q288122KB288122288122 FIX: Lock Monitor Uses Excessive CPUSeptember 12, 2003
8.00.2398.0.2392000.80.239.0Q285290KB285290285290 FIX: Complex ANSI Join Query with Distributed Queries May Cause Handled Access ViolationOctober 9, 2003
8.00.2338.0.2332000.80.233.0Q282416KB282416282416 FIX: Opening the Database Folder in SQL Server Enterprise Manager 2000 Takes a Long TimeOctober 9, 2003
8.00.2318.0.2312000.80.231.0Q282279KB282279282279 FIX: Execution of sp_OACreate on COM Object Without Type Information Causes Server Shut DownOctober 9, 2003
8.00.2268.0.2262000.80.226.0Q278239KB278239278239 FIX: Extreme Memory Usage When Adding Many Security RolesNovember 21, 2006
8.00.2258.0.2252000.80.225.0Q281663KB281663281663 "Access Denied" Error Message When You Try to Use a Network Drive to Modify Windows 2000 PermissionsOctober 30, 2006
8.00.2238.0.2232000.80.223.0Q280380KB280380280380 FIX: Buffer Overflow Exploit Possible with Extended Stored ProceduresJune 29, 2004
8.00.2228.0.2222000.80.222.0Q281769KB281769281769 FIX: Exception Access Violation Encountered During Query NormalizationOctober 7, 2005
8.00.2188.0.2182000.80.218.0Q279183KB279183279183 FIX: Scripting Object with Several Extended Properties May Cause ExceptionOctober 9, 2003
8.00.2178.0.2172000.80.217.0Q279293KB279293279293 FIX: CASE Using LIKE with Empty String Can Result in Access Violation or Abnormal Server ShutdownOctober 9, 2003
8.00.2118.0.2112000.80.211.0Q276329KB276329276329 FIX: Complex Distinct or Group By Query Can Return Unexpected Results with Parallel Execution PlanNovember 5, 2003
8.00.2108.0.2102000.80.210.0Q275900KB275900275900 FIX: Linked Server Query with Hyphen in LIKE Clause May Run SlowlyOctober 9, 2003
8.00.2058.0.2052000.80.205.0Q274330KB274330274330 FIX: Sending Open Files as Attachment in SQL Mail Fails with Error 18025October 7, 2005
8.00.2048.0.2042000.80.204.0Q274329KB274329274329 FIX: Optimizer Slow to Generate Query Plan for Complex Queries that have Many Joins and Semi-JoinsOctober 9, 2003
8.00.1948.0.1942000.80.194.0SQL Server 2000 RTM (no SP)
8.00.1908.0.1902000.80.190.0SQL Server 2000 Gold
8.00.1008.0.1002000.80.100.0SQL Server 2000 Beta 2
8.00.0788.0.0782000.80.078.0SQL Server 2000 EAP5
8.00.0478.0.0472000.80.047.0SQL Server 2000 EAP4