Tuesday 17 May 2011

SSIS Documentation

Description



  • Author: Brian Knight, Allan Mitchell, Darren Green, and Douglas Hinson
  • Publisher: Wrox
  • Publish Date: January 12, 2006
  • Pages: 720

This book will help you get past the initial learning curve quickly so that you can get started using SSIS to transform data, create a workflow, or maintain your SQL Server. Offering you hands-on guidance, you'll learn a new world of integration possibilities and be able to move away from scripting complex logic to programming tasks using a full-featured language.
What you will learn from this book
  • Ways to quickly move and transform data
  • How to configure every aspect of SSIS
  • How to interface SSIS with web services and XML
  • Techniques to scale the SSIS and make it more reliable
  • How to migrate DTS packages to SSIS
  • How to create your own custom tasks and user interfaces
  • How to create an application that interfaces with SSIS to manage the environment
  • A detailed usable case study for a complete ETL solution
Who this book is for
This book is for developers, DBAs, and users who are looking to program custom code in all of the .NET languages. It is expected that you know the basics of how to query the SQL Server and have some fundamental programming skills.

Monday 11 April 2011

When does my SQL Server support end ?

SQL Server VersionRelease DateMainstream Support EndExtended Support EndLink to Microsoft Support Lifecycle
SQL 703-01-199912-31-200501-11-2011Support Lifecycle
SQL 200011-30-200004-08-200804-09-2013Support Lifecycle
SQL 200501-14-200604-12-201104-12-2016Support Lifecycle
SQL 200811-06-200801-14-201401-08-2019Support Lifecycle
SQL 2008 R207-20-201001-14-201401-08-2019Support Lifecycle

The Support Lifecycle links will have more detailed information about Service Packs and support guidelines for the specific versions.

Query to find Service account of SQL Server

DECLARE @serviceaccount varchar(100)
EXECUTE master.dbo.xp_instance_regread
N'HKEY_LOCAL_MACHINE',
N'SYSTEM\CurrentControlSet\Services\MSSQLSERVER',
N'ObjectName',
@ServiceAccount OUTPUT,
N'no_output'
SELECT @Serviceaccount

How to retrieve table name and privilages of user in SQL server

Select TABLE_NAME, PRIVILEGE_TYPE from INFORMATION_SCHEMA.TABLE_PRIVILEGES where
GRANTEE = 'Toolbox'

Query to find the job history in SQL Server

select a.run_date,b.name,a.run_duration,run_time,a.server  from sysjobhistory a inner join sysjobs b on a.job_id=b.job_id where a.job_id='8E7D12F1-6B7E-4C08-8063-D8AAFD99F267' and a.step_id =0  order by a.run_date desc

Query to find the object permission for specific objects

select
sys.database_permissions.state_desc + ' ' + sys.database_permissions.permission_name + ' on ['+ sys.schemas.name + '].[' + sys.objects.name + '] to [' + sys.database_principals.name + ']' COLLATE LATIN1_General_CI_AS
from sys.database_permissions
join sys.objects on sys.database_permissions.major_id =
sys.objects.object_id
join sys.schemas on sys.objects.schema_id = sys.schemas.schema_id
join sys.database_principals on sys.database_permissions.grantee_principal_id =
sys.database_principals.principal_id
where sys.objects.name='object_name’

How to find table count of all tables in a database in sql

How to find table count of all tables in a database


SELECT o.name AS "Table Name", i.rowcnt AS "Row Count"

FROM sysobjects o, sysindexes i

WHERE i.id = o.id

AND indid IN(0,1)

AND xtype = 'u'

AND o.name <> 'sysdiagrams'

ORDER BY i.rowcnt DESC

Thursday 31 March 2011

Can we take backup of Resource database

We can't take backup of resource database but we can have backup of Data file and log file..

In SQL Server  changes will only be made to the this database and will be reflected on all the system and user databases on the instance. If you need to apply a service pack on multiple instances, all you need to do is copy the Resource database's MDF and LDF files to the target instances. Rolling back the changes is as simple as overwriting the database files with an older copy. The physical file names of the Resource database are mssqlsystemresource.mdf and mssqlsystemresource.ldf and are located, by default, in <drive>:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data

Ghost cleanup in sql server

Ghost Cleanup is the removal of pages that have been marked for deletion.  When a record is deleted, it is marked with a bit, and is no longer "available".  In other words, it becomes a ghost record.  The Ghost Cleanup process comes along, and physically removes the records, so the space can be reused.  If you want to stop Ghost clean up follow the below process

Trace flag 661: Disable the ghost record removal process
Trace flag 661 disables the ghost record removal process. A ghost record is the result of a delete operation. When you delete a record, the deleted record is kept as a ghost record. Later, the deleted record is purged by the ghost record removal process. When you disable this process, the deleted record is not purged. Therefore, the space that the deleted record consumes is not freed. This behavior affects space consumption and the performance of scan operations.

When you turn on trace flag 661 at startup or in a user session, trace flag 661 always applies across the server and has global scope. If you turn off this trace flag, the ghost record removal process works correctly.

WAL in SQL server

.WAL      

A)    Write ahead logging protocol  (WAL)  is a technique which helps to adhere to two of the four acid properties ‘Atomicity’ and durability, Now that we understand what is atomicity and durability… next is to understand “How WAL works” and also we need to peep into the advantages we get from it.
B)    Let me just put my words as per SQL Books online which is very much easier to understand:
Write-ahead log (WAL) guarantees that no data modifications are written to disk before the associated log record is written to disk. This maintains the ACID properties for a transaction.
C)    To understand how the write-ahead log works, it is important for us to know how modified data is written to disk. SQL Server maintains a buffer cache into which it reads data pages when data must be retrieved. Data modifications are not made directly to disk, but are made to the copy of the page in the buffer cache. The modification is not written to disk until a checkpoint occurs in the database, or the modification needs to be written to disk so the buffer can be used to hold a new page. Writing a modified data page from the buffer cache to disk is called flushing the page. A page modified in the cache, but not yet written to disk, is called a dirty page.
D)    At the time when modification is made to a page in the buffer, a log record is built in the log cache that records the modification. This log record must be written to disk before the associated dirty page is flushed from the buffer cache to disk. If the dirty page is flushed before the log record is written, the dirty page creates a modification on the disk that cannot be rolled back if the server fails before the log record is written to disk. SQL Server has logic that prevents a dirty page from being flushed before the associated log record is written. Log records are written to disk when the transactions are committed.

Thursday 24 March 2011

Generate Alert if job has not run for more than 2 days in 2005

declare @LSTexecDateInt varchar(8), @LSTexecDate datetime
declare @days int , @test varchar(250)
set @LSTexecDateInt = (select max(run_date)
from sysjobhistory where job_id = 'F7FF3E3A-97FC-42F6-84FB-7746138F5432' )
--Set @LSTexecDateInt = '20110225'
Set @LSTexecDate = Convert(datetime,left(@LSTexecDateInt,4) + '-' + left(right(@LSTexecDateInt,4),2) + '-' + right(@LSTexecDateInt,2))
Set @days = datediff(dd,@LSTexecDate ,getdate())
--print @days

if (@days)>2
begin
set @test = 'Backup for Master and MSDB database in server A  not taken from '+ convert(varchar(3) , @days) +'    days'
EXEC msdb.dbo.sp_send_dbmail  @recipients =
                                          @body = @test,
@subject = 'Backup for Master server  master database  not taken ',
@profile_name = 'DB profile name'
end

Monday 14 March 2011

Microsoft SQL Server 2005 Builds


Build SQLSERVR.EXE Build File version Q KB KB / Description Date Updated Availability
9.00.5254 9.0.5254 2005.90.5254.0Q246407 KB246407 2464079 Cumulative update package 1 (CU1) for SQL Server 2005 Service Pack 4 December 24, 2010 Downloadable
9.00.5000 9.0.5000 2005.90.5000.0SQL Server 2005 Service Pack 4 (SP4) December 17, 2010 Downloadable
9.00.4912 9.0.4912 2005.90.4912.0SQL Server 2005 Service Pack 4 (SP4) - Customer Technology Preview (CTP) November 3, 2010 Downloadable
9.00.4315 9.0.4315 2005.90.4315.0Q243834 KB243834 2438344 Cumulative update package 13 (CU13) for SQL Server 2005 Service Pack 3 December 23, 2010 Downloadable
9.00.4311 9.0.4311 2005.90.4311.0Q234544 KB234544 2345449 Cumulative update package 12 (CU12) for SQL Server 2005 Service Pack 3 October 18, 2010 Downloadable
9.00.4309 9.0.4309 2005.90.4309.0Q225885 KB225885 2258854 Cumulative update package 11 (CU11) for SQL Server 2005 Service Pack 3 August 16, 2010 Downloadable
9.00.4305 9.0.4305 2005.90.4305.0Q983329 KB983329 983329 Cumulative update package 10 (CU10) for SQL Server 2005 Service Pack 3 June 23, 2010 Downloadable
9.00.4294 9.0.4294 2005.90.4294.0Q980176 KB980176 980176 Cumulative update package 9 (CU9) for SQL Server 2005 Service Pack 3 April 19, 2010 Downloadable
9.00.4285 9.0.4285 2005.90.4285.0Q978915 KB978915 978915 Cumulative update package 8 (CU8) for SQL Server 2005 Service Pack 3 February 16, 2010 Downloadable
9.00.4273 9.0.4273 2005.90.4273.0Q976951 KB976951 976951 Cumulative update package 7 (CU7) for SQL Server 2005 Service Pack 3 December 21, 2009 Downloadable
9.00.4268 9.0.4268 2005.90.4268.0Q977151 KB977151 977151 FIX: Error message when you add a subscription to a republisher that is in a merge publication in SQL Server 2005: "Cannot create the subscription because the subscription already exists in the subscription database" December 21, 2009 Downloadable
9.00.4266 9.0.4266 2005.90.4266.0Q974648 KB974648 974648 Cumulative update package 6 (CU6) for SQL Server 2005 Service Pack 3 October 19, 2009 Downloadable
9.00.4262 9.0.4262 2005.90.4262.0Q970894 KB970894 970894 MS09-062: Description of the security update for SQL Server 2005 Service Pack 3 QFE: October 13, 2009 October 13, 2009 Downloadable
9.00.4230 9.0.4230 2005.90.4230.0Q972511 KB972511 972511 Cumulative update package 5 (CU5) for SQL Server 2005 Service Pack 3 August 17, 2009 Downloadable
9.00.4226 9.0.4226 2005.90.4226.0Q970279 KB970279 970279 Cumulative update package 4 (CU4) for SQL Server 2005 Service Pack 3 June 16, 2009 Downloadable
9.00.4224 9.0.4224 2005.90.4224.0Q971409 KB971409 971409 FIX: Error message when you run a query that contains duplicate join conditions in SQL Server 2005: "Internal Query Processor Error: The query processor could not produce a query plan" June 16, 2009
9.00.4220 9.0.4220 2005.90.4220.0Q967909 KB967909 967909 Cumulative update package 3 (CU3) for SQL Server 2005 Service Pack 3 April 20, 2009 Downloadable
9.00.4216 9.0.4216 2005.90.4216.0Q967101 KB967101 967101 FIX: The performance of database mirroring decreases when you run a database maintenance job that generates a large number of transaction log activities in SQL Server 2005 April 20, 2009 Downloadable
9.00.4211 9.0.4211 2005.90.4211.0Q961930 KB961930 961930 Cumulative update package 2 (CU2) for SQL Server 2005 Service Pack 3 February 17, 2009 Downloadable
9.00.4207 9.0.4207 2005.90.4207.0Q959195 KB959195 959195 Cumulative update package 1 (CU1) for SQL Server 2005 Service Pack 3 December 20, 2008 Downloadable
9.00.4053 9.0.4053 2005.90.4053.0Q970892 KB970892 970892 MS09-062: Description of the security update for SQL Server 2005 Service Pack 3 GDR: October 13, 2009 October 13, 2009 Downloadable
9.00.4035 9.0.4035 2005.90.4035.0SQL Server 2005 Service Pack 3 (SP3) December 15, 2008 Downloadable
9.00.4028 9.0.4028 2005.90.4028.0SQL Server 2005 Service Pack 3 (SP3) - CTP October 27, 2008
9.00.3356 9.0.3356 2005.90.3356.0Q976952 KB976952 976952 Cumulative update package 17 (CU17) for SQL Server 2005 Service Pack 2 December 21, 2009 Downloadable
9.00.3355 9.0.3355 2005.90.3355.0Q974647 KB974647 974647 Cumulative update package 16 (CU16) for SQL Server 2005 Service Pack 2 October 19, 2009 Downloadable
9.00.3353 9.0.3353 2005.90.3353.0Q970896 KB970896 970896 MS09-062: Description of the security update for SQL Server 2005 Service Pack 2 QFE: October 13, 2009 October 13, 2009 Downloadable
9.00.3330 9.0.3330 2005.90.3330.0Q972510 KB972510 972510 Cumulative update package 15 (CU15) for SQL Server 2005 Service Pack 2 August 18, 2009 Downloadable
9.00.3328 9.0.3328 2005.90.3328.0Q970278 KB970278 970278 Cumulative update package 14 (CU14) for SQL Server 2005 Service Pack 2 June 16, 2009 Downloadable
9.00.3325 9.0.3325 2005.90.3325.0Q967908 KB967908 967908 Cumulative update package 13 (CU13) for SQL Server 2005 Service Pack 2 April 20, 2009 Downloadable
9.00.3320 9.0.3320 2005.90.3320.0Q969142 KB969142 969142 FIX: Error message when you run the DBCC CHECKDB statement on a database in SQL Server 2005: "Unable to deallocate a kept page" April 1, 2009 Downloadable
9.00.3318 9.0.3318 2005.90.3318.0Q967199 KB967199 967199 FIX: The Wmiprvse.exe host process stops responding when you run a SQL Server 2005-based application that sends a Windows Management Instrumentation (WMI) query to the SQL Server WMI provider April 20, 2009 Downloadable
9.00.3315 9.0.3315 2005.90.3315.0Q962970 KB962970 962970 Cumulative update package 12 (CU12) for SQL Server 2005 Service Pack 2 February 17, 2009 Downloadable
9.00.3310 9.0.3310 2005.90.3310.0Q960090 KB960090 960090 MS09-004: Description of the security update for SQL Server 2005 QFE: February 10, 2009 February 10, 2009 Downloadable
9.00.3301 9.0.3301 2005.90.3301.0Q958735 KB958735 958735 Cumulative update package 11 (CU11) for SQL Server 2005 Service Pack 2 December 16, 2008 Downloadable
9.00.3294 9.0.3294 2005.90.3294.0Q956854 KB956854 956854 Cumulative update package 10 (CU10) for SQL Server 2005 Service Pack 2 October 20, 2008 Downloadable
9.00.3282 9.0.3282 2005.90.3282.0Q953752 KB953752 953752 Cumulative update package 9 (CU9) for SQL Server 2005 Service Pack 2 June 16, 2008 Downloadable
9.00.3260 9.0.3260 2005.90.3260.0Q954950 KB954950 954950 FIX: Error message when you run a distributed query in SQL Server 2005: "OLE DB provider 'SQLNCLI' for linked server '<Linked Server>' returned message 'No transaction is active'" July 14, 2008
9.00.3259 9.0.3259 2005.90.3259.0Q954831 KB954831 954831 FIX: In SQL Server 2005, the session that runs the TRUNCATE TABLE statement may stop responding, and you cannot end the session August 14, 2008
9.00.3259 9.0.3259 2005.90.3259.0Q954669 KB954669 954669 FIX: An ongoing MS DTC transaction is orphaned in SQL Server 2005 July 14, 2008
9.00.3257 9.0.3257 2005.90.3257.0Q951217 KB951217 951217 Cumulative update package 8 (CU8) for SQL Server 2005 Service Pack 2 June 18, 2008 Downloadable
9.00.3246 9.0.3246 2005.90.3246.0Q952233 KB952233 952233 FIX: All the MDX queries that are running on an instance of SQL Server 2005 Analysis Services are canceled when you start or stop a SQL Server Profiler trace for the instance May 23, 2008
9.00.3244 9.0.3244 2005.90.3244.0Q952330 KB952330 952330 FIX: The Replication Log Reader Agent may fail intermittently when a transactional replication synchronizes data in SQL Server 2005 June 3, 2008
9.00.3240 9.0.3240 2005.90.3240.0Q951204 KB951204 951204 FIX: An access violation occurs when you update a table through a view by using a cursor in SQL Server 2005 May 21, 2008
9.00.3239 9.0.3239 2005.90.3239.0Q949095 KB949095 949095 Cumulative update package 7 (CU7) for SQL Server 2005 Service Pack 2 April 17, 2008 Downloadable
9.00.3232 9.0.3232 2005.90.3232.0Q949959 KB949959 949959 FIX: Error message when you synchronize the data of a merge replication in SQL Server 2005: "The merge process is retrying a failed operation made to article 'ArticleName' - Reason: 'Invalid input parameter values. Check the status values for detail.'" March 19, 2008
9.00.3231 9.0.3231 2005.90.3231.0Q949595 KB949595 949595 FIX: Error message when you run a query that uses a join condition in SQL Server 2005: "Non-yielding Scheduler" March 18, 2008
9.00.3231 9.0.3231 2005.90.3231.0Q949687 KB949687 949687 FIX: Error message when you run a transaction from a remote server by using a linked server in SQL Server 2005: "This operation conflicts with another pending operation on this transaction" March 14, 2008
9.00.3230 9.0.3230 2005.90.3230.0Q949199 KB949199 949199 FIX: Error message when you run queries on a database that has the SNAPSHOT isolation level enabled in SQL Server 2005: "Unable to deallocate a kept page" March 7, 2008
9.00.3228 9.0.3228 2005.90.3228.0Q946608 KB946608 946608 Cumulative update package 6 (CU6) for SQL Server 2005 Service Pack 2 February 19, 2008 Downloadable
9.00.3224 9.0.3224 2005.90.3224.0Q947463 KB947463 947463 FIX: A stored procedure cannot finish its execution in SQL Server 2005 February 4, 2008
9.00.3221 9.0.3221 2005.90.3221.0Q942908 KB942908 942908 FIX: The change may be undone during the later synchronizations when you change an article on the subscriber in SQL Server 2005 January 31, 2008
9.00.3221 9.0.3221 2005.90.3221.0Q945443 KB945443 945443 FIX: A query takes longer to finish in SQL Server 2005 than in SQL Server 2000 when you open a fast forward-only cursor for the query January 11, 2008
9.00.3221 9.0.3221 2005.90.3221.0Q945916 KB945916 945916 FIX: Error messages when you delete some records of a table in a transaction or when you update some records of a table in a transaction in SQL Server 2005: "Msg 9002," "Msg 3314," and "Msg 9001" January 10, 2008
9.00.3221 9.0.3221 2005.90.3221.0Q945442 KB945442 945442 FIX: You cannot cancel the query execution immediately if you open a fast forward-only cursor for the query in SQL Server 2005 January 9, 2008
9.00.3215 9.0.3215 2005.90.3215.0Q943656 KB943656 943656 Cumulative update package 5 (CU5) for SQL Server 2005 Service Pack 2 December 18, 2007 Downloadable
9.00.3208 9.0.3208 2005.90.3208.0Q944902 KB944902 944902 FIX: A federated database server stops responding when you run parallel queries on a multiprocessor computer that uses NUMA architecture in SQL Server 2005 November 21, 2007
9.00.3206 9.0.3206 2005.90.3206.0Q944677 KB944677 944677 FIX: Conflicts are not logged when you use the Microsoft SQL Server Subscriber Always Wins Conflict Resolver for an article in a merge replication in Microsoft SQL Server 2005 December 11, 2007
9.00.3200 9.0.3200 2005.90.3200.0Q941450 KB941450 941450 Cumulative update package 4 (CU4) for SQL Server 2005 Service Pack 2 October 17, 2007 Downloadable
9.00.3194 9.0.3194 2005.90.3194.0Q940933 KB940933 940933 FIX: Some changes from subscribers who use SQL Server 2005 Compact Edition or Web synchronization are not uploaded to the publisher when you use the republishing model in a merge publication in Microsoft SQL Server 2005 September 24, 2007
9.00.3186 9.0.3186 2005.90.3186.0Q940943 KB940943 940943 FIX: The performance of a query that performs an insert operation or an update operation is much slower in SQL Server 2005 SP2 than in earlier versions of SQL Server 2005 August 29, 2007
9.00.3186 9.0.3186 2005.90.3186.0Q940378 KB940378 940378 FIX: A cursor uses the incorrect transaction isolation level after you change the transaction isolation level for the cursor in SQL Server 2005 August 24, 2007
9.00.3186 9.0.3186 2005.90.3186.0Q940269 KB940269 940269 FIX: Error message when you try to edit a SQL Server Agent job or a maintenance plan by using SQL Server Management Studio in SQL Server 2005: "String or binary data would be truncated" August 23, 2007
9.00.3186 9.0.3186 2005.90.3186.0Q940945 KB940945 940945 FIX: Performance is very slow when the same stored procedure is executed at the same time in many connections on a multiple-processor computer that is running SQL Server 2005 August 22, 2007
9.00.3186 9.0.3186 2005.90.3186.0Q940937 KB940937 940937 FIX: Error message when you try to update the index key columns of a non-unique clustered index in SQL Server 2005: "Cannot insert duplicate key row in object 'ObjectName' with unique index 'IndexName'" August 21, 2007
9.00.3186 9.0.3186 2005.90.3186.0Q940379 KB940379 940379 FIX: Error message when you use the UNLOAD and REWIND options to back up a database to a tape device in SQL Server 2005: "Operation on device '<TapeDevice>' exceeded retry count" August 20, 2007
9.00.3186 9.0.3186 2005.90.3186.0Q940375 KB940375 940375 FIX: Error message when you use the Copy Database Wizard to move a database from SQL Server 2000 to SQL Server 2005 August 20, 2007
9.00.3186 9.0.3186 2005.90.3186.0Q937100 KB937100 937100 FIX: Error message when you run a SQL Server 2005 Integration Services package that contains a Script Component transformation:"Insufficient memory to continue the execution of the program" August 20, 2007
9.00.3186 9.0.3186 2005.90.3186.0Q940126 KB940126 940126 FIX: Error 9003 is logged in the SQL Server error log file when you use log shipping in SQL Server 2005 August 20, 2007
9.00.3186 9.0.3186 2005.90.3186.0Q938363 KB938363 938363 FIX: Data is not replicated to a subscriber in a different partition by using parameterized row filters in SQL Server 2005 August 17, 2007
9.00.3186 9.0.3186 2005.90.3186.0Q940935 KB940935 940935 FIX: Error message when you run a query that is associated with a parallel execution plan in SQL Server 2005: "SQL Server Assertion: File: <lckmgr.cpp>, line=10850 Failed Assertion = 'GetLocalLockPartition () == xactLockInfo->GetLocalLockPartition ()'" August 17, 2007
9.00.3186 9.0.3186 2005.90.3186.0Q940221 KB940221 940221 FIX: Error message when you try to create an Oracle publication by using the New Publication Wizard in SQL Server 2005 Service Pack 2: "OLE DB Provider 'OraOLEDB.ORACLE' for Linked server <LinkedServerName> returned message" August 17, 2007
9.00.3186 9.0.3186 2005.90.3186.0Q940942 KB940942 940942 FIX: Error message when you run a stored procedure that references tables after you upgrade a database from SQL Server 2000 to SQL Server 2005: "A time-out occurred while waiting for buffer latch" August 17, 2007
9.00.3186 9.0.3186 2005.90.3186.0Q940384 KB940384 940384 FIX: You receive a System.InvalidCastException exception when you run an application that calls the Server.JobServer.Jobs.Contains method on a computer that has SQL Server 2005 Service Pack 2 installed August 13, 2007
9.00.3186 9.0.3186 2005.90.3186.0Q940281 KB940281 940281 FIX: An access violation may occur, and you may receive an error message, when you query the sys.dm_exe_sessions dynamic management view in SQL Server 2005 August 13, 2007
9.00.3186 9.0.3186 2005.90.3186.0Q940545 KB940545 940545 FIX: The performance of insert operations against a table that contains an identity column may be slow in SQL Server 2005 August 10, 2007
9.00.3186 9.0.3186 2005.90.3186.0Q940210 KB940210 940210 FIX: Error message when you try to insert more than 3 megabytes of data into a distributed partitioned view in SQL Server 2005: "A system assertion check has failed" August 8, 2007
9.00.3186 9.0.3186 2005.90.3186.0Q939537 KB939537 939537 Cumulative update package 3 (CU3) for SQL Server 2005 Service Pack 2 August 23, 2007 Downloadable
9.00.3182 9.0.3182 2005.90.3182.0Q940128 KB940128 940128 FIX: You receive error 8623 when you run a complex query in SQL Server 2005 August 3, 2007
9.00.3179 9.0.3179 2005.90.3179.0Q938243 KB938243 938243 FIX: Error message when you run a full-text query against a catalog in SQL Server 2005: "The execution of a full-text query failed. The content index is corrupt." July 30, 2007
9.00.3178 9.0.3178 2005.90.3178.0Q938086 KB938086 938086 FIX: A SQL Server Agent job fails when you run the SQL Server Agent job in the context of a proxy account in SQL Server 2005 August 22, 2007
9.00.3177 9.0.3177 2005.90.3177.0Q939285 KB939285 939285 FIX: Error message when you run a stored procedure that starts a transaction that contains a Transact-SQL statement in SQL Server 2005: "New request is not allowed to start because it should come with valid transaction descriptor" August 22, 2007
9.00.3177 9.0.3177 2005.90.3177.0Q939562 KB939562 939562 FIX: Error message when you run a query that fires an INSTEAD OF trigger in SQL Server 2005 Service Pack 2: "Internal Query Processor Error The query processor could not produce a query plan" August 20, 2007
9.00.3177 9.0.3177 2005.90.3177.0Q939563 KB939563 939563 FIX: Error message when you synchronize a merge replication in Microsoft SQL Server 2005: "MSmerge_del_<GUID>, Line 42 String or binary data would be truncated" August 9, 2007
9.00.3175 9.0.3175 2005.90.3175.0Q936534 KB936534 936534 FIX: Error message when the Distribution Agent tries to apply the snapshot to the subscriber in SQL Server 2005: "Must declare the scalar variable "@Variable"" August 20, 2007
9.00.3175 9.0.3175 2005.90.3175.0Q938671 KB938671 938671 FIX: The Distribution Agent may skip some rows when you configure a transactional replication that uses the "-SkipErrors" parameter in SQL Server 2005 August 1, 2007
9.00.3175 9.0.3175 2005.90.3175.0Q936488 KB936488 936488 The service pack update or hotfix installation stops unexpectedly when you try to install either Microsoft SQL Server 2005 Service Pack 2 or a hotfix for SQL Server 2005 SP2 July 10, 2007
9.00.3175 9.0.3175 2005.90.3175.0Q938825 KB938825 938825 FIX: A foreign key constraint that you drop on a table at the publisher is not dropped on the table at the subscriber in a SQL Server 2005 merge replication June 29, 2007
9.00.3175 9.0.3175 2005.90.3175.0Q936305 KB936305 936305 Cumulative update package 2 (CU2 build 3175) for SQL Server 2005 Service Pack 2 is available June 28, 2007 Downloadable
9.00.3171 9.0.3171 2005.90.3171.0Q937745 KB937745 937745 FIX: You may receive error messages when you try to log in to an instance of SQL Server 2005 and SQL Server handles many concurrent connections July 16, 2007
9.00.3169 9.0.3169 2005.90.3169.0Q937033 KB937033 937033 FIX: Error message when you run a linked server query in SQL Server 2005: "The oledbprovider unisys.dmsII.1 for linkserver '<ServerName>' reported an error the provider ran out of memory" June 19, 2007
9.00.3169 9.0.3169 2005.90.3169.0Q937041 KB937041 937041 FIX: Changes in the publisher database are not replicated to the subscribers in a transactional replication if the publisher database runs exposed in a database mirroring session in SQL Server 2005 May 25, 2007
9.00.3166 9.0.3166 2005.90.3166.0Q936185 KB936185 936185 FIX: Blocking and performance problems may occur when you enable trace flag 1118 in SQL Server 2005 if the temporary table creation workload is high June 11, 2007
9.00.3166 9.0.3166 2005.90.3166.0Q934734 KB934734 934734 FIX: A database is marked as suspect when you update a table that contains a nonclustered index in SQL Server 2005 July 16, 2007
9.00.3161 9.0.3161 2005.90.3161.0Q935789 KB935789 935789 FIX: On a computer that is running SQL Server 2005 and that has multiple processors, you may receive incorrect results when you run a query that contains an inner join September 24, 2007
9.00.3161 9.0.3161 2005.90.3161.0Q934706 KB934706 934706 FIX: Error message when you perform a piecemeal restore operation after you enable vardecimal database compression in SQL Server 2005 Service Pack 2: "Piecemeal restore is not supported when an upgrade is involved" June 4, 2007
9.00.3161 9.0.3161 2005.90.3161.0Q933724 KB933724 933724 FIX: The query performance is slow when you run a query that uses a user-defined scalar function against an instance of SQL Server 2005 May 9, 2007
9.00.3161 9.0.3161 2005.90.3161.0Q935356 KB935356 935356 Cumulative update package (CU1 build 3161) for SQL Server 2005 Service Pack 2 is available April 16, 2007 Downloadable
9.00.3159 9.0.3159 2005.90.3159.0Q934459 KB934459 934459 FIX: The Check Database Integrity task and the Execute T-SQL Statement task in a maintenance plan may lose database context in certain circumstances in SQL Server 2005 builds 3150 through 3158 April 3, 2007 Downloadable
9.00.3156 9.0.3156 2005.90.3156.0Q934226 KB934226 934226 FIX: Error message when you try to use Database Mail to send an e-mail message in SQL Server 2005: "profile name is not valid (Microsoft SQL Server, Error 14607)" April 25, 2007
9.00.3155 9.0.3155 2005.90.3155.0Q933808 KB933808 933808 FIX: Error message when you run a query that contains nested FOR XML clauses in SQL Server 2005: "The XML data type is damaged" June 13, 2007
9.00.3155 9.0.3155 2005.90.3155.0Q933499 KB933499 933499 FIX: Error message when you use transactional replication to replicate the execution of stored procedures to subscribers in SQL Server 2005: "Insufficient memory to run query" June 12, 2007
9.00.3155 9.0.3155 2005.90.3155.0Q933766 KB933766 933766 FIX: Failed assertion message in the Errorlog file when you perform various operations in SQL Server 2005: "Failed Assertion = 'fFalse' Attempt to access expired blob handle (3)" May 15, 2007
9.00.3155 9.0.3155 2005.90.3155.0Q933549 KB933549 933549 FIX: You may receive an access violation when you perform a bulk copy operation in SQL Server 2005 April 25, 2007
9.00.3154 9.0.3154 2005.90.3154.0Q934188 KB934188 934188 FIX: The Distribution Agent does not deliver commands to the Subscriber even if the Distribution Agent is running in SQL Server 2005 April 25, 2007
9.00.3154 9.0.3154 2005.90.3154.0Q934109 KB934109 934109 FIX: The Distribution Agent generates an access violation when you configure a transactional replication publication to run an additional script after the snapshot is applied at the subscriber in SQL Server 2005 April 25, 2007
9.00.3154 9.0.3154 2005.90.3154.0Q934106 KB934106 934106 FIX: SQL Server 2005 database engine generates failed assertion errors when you use the Replication Monitor to monitor the distribution database April 25, 2007
9.00.3153 9.0.3153 2005.90.3153.0Q933564 KB933564 933564 FIX: A gradual increase in memory consumption for the USERSTORE_TOKENPERM cache store occurs in SQL Server 2005 April 16, 2007
9.00.3152 9.0.3152 2005.90.3152.0Q933097 KB933097 933097 Cumulative hotfix package (build 3152) for SQL Server 2005 Service Pack 2 is available March 7, 2007 Downloadable
9.00.3080 9.0.3080 2005.90.3080.0Q970895 KB970895 970895 MS09-062: Description of the security update for GDI+ for SQL Server 2005 Service Pack 2 GDR: October 13, 2009 October 13, 2009 Downloadable
9.00.3077 9.0.3077 2005.90.3077.0Q960089 KB960089 960089 MS09-004: Description of the security update for SQL Server 2005 GDR: February 10, 2009 February 10, 2009 Downloadable
9.00.3073 9.0.3073 2005.90.3073.0Q954606 KB954606 954606 MS08-052: Description of the security update for GDI+ for SQL Server 2005 Service Pack 2 GDR: September 9, 2008 September 9, 2008 Downloadable
9.00.3068 9.0.3068 2005.90.3068.0Q941203 KB941203 941203 MS08-040: Vulnerabilities in Microsoft SQL Server could allow elevation of privilege August 5, 2008 Downloadable
9.00.3054 9.0.3054 2005.90.3054.0Q934458 KB934458 934458 FIX: The Check Database Integrity task and the Execute T-SQL Statement task in a maintenance plan may lose database context in certain circumstances in SQL Server 2005 builds 3042 through 3053 January 2, 2008 Downloadable
9.00.3050 9.0.3050 2005.90.3050.0Q933508 KB933508 933508 Microsoft SQL Server 2005 Service Pack 2 issue: Cleanup tasks run at different intervals than intended March 7, 2007 Downloadable
9.00.3042 9.0.3042 2005.90.3042.0SQL Server 2005 Service Pack 2 (SP2) February 19, 2007 Downloadable
9.00.3033 9.0.3033 2005.90.3033.0SQL Server 2005 Service Pack 2 (SP2) - CTP December 2006 December 19, 2006
9.00.3027 9.0.3027 2005.90.3027.0SQL Server 2005 Service Pack 2 (SP2) - CTP November 2006 November 6, 2006
9.00.3026 9.0.3026 2005.90.3026.0Q929376 KB929376 929376 FIX: A "17187" error message may be logged in the Errorlog file when an instance of SQL Server 2005 is under a heavy load February 14, 2007
9.00.2239 9.0.2239 2005.90.2239.0Q940961 KB940961 940961 FIX: Transactions that are being committed on the principal server may not be copied to the mirror server when a database mirroring failover occurs in SQL Server 2005 September 24, 2007
9.00.2237 9.0.2237 2005.90.2237.0Q940719 KB940719 940719 FIX: A memory leak occurs when you call the Initialize method and the Terminate method of the SQLDistribution object in a loop in an application that you develop by using Microsoft ActiveX replication controls in SQL Server 2005 September 24, 2007
9.00.2236 9.0.2236 2005.90.2236.0Q940287 KB940287 940287 FIX: Error message when you use Service Broker in SQL Server 2005: "An error occurred while receiving data: '64(The specified network name is no longer available.)'" July 29, 2007
9.00.2236 9.0.2236 2005.90.2236.0Q940286 KB940286 940286 FIX: A Service Broker endpoint stops passing messages in a database mirroring session of SQL Server 2005 July 26, 2007
9.00.2234 9.0.2234 2005.90.2234.0Q937343 KB937343 937343 FIX: SQL Server 2005 stops and then restarts unexpectedly and errors occur in the tempdb database June 20, 2007
9.00.2233 9.0.2233 2005.90.2233.0Q937545 KB937545 937545 FIX: Error message when you use the BULK INSERT statement to import a data file into a table in SQL Server 2005 with SP1: "The OLE DB provider "BULK" for linked server "(null)" reported an error" June 18, 2007
9.00.2233 9.0.2233 2005.90.2233.0Q933499 KB933499 933499 FIX: Error message when you use transactional replication to replicate the execution of stored procedures to subscribers in SQL Server 2005: "Insufficient memory to run query" June 12, 2007
9.00.2233 9.0.2233 2005.90.2233.0Q937544 KB937544 937544 FIX: You may receive error 3456 when you try to restore a transaction log for a SQL Server 2005 database June 5, 2007
9.00.2232 9.0.2232 2005.90.2232.0Q937277 KB937277 937277 FIX: A memory leak occurs when you use the sp_OAMethod stored procedure to call a method of a COM object in SQL Server 2005 June 19, 2007
9.00.2231 9.0.2231 2005.90.2231.0Q934812 KB934812 934812 FIX: You cannot bring the SQL Server group online in a cluster environment after you rename the virtual server name of the default instance of SQL Server 2005 November 6, 2007
9.00.2230 9.0.2230 2005.90.2230.0Q936179 KB936179 936179 FIX: Error message when you use SQL Native Client to connect to an instance of a principal server in a database mirroring session: "The connection attempted to fail over to a server that does not have a failover partner" September 20, 2007
9.00.2229 9.0.2229 2005.90.2229.0Q935446 KB935446 935446 FIX: You receive error messages when you use the BULK INSERT statement in SQL Server 2005 to import data in bulk June 11, 2007
9.00.2227 9.0.2227 2005.90.2227.0Q933265 KB933265 933265 FIX: You may receive error 1203 when you run an INSERT statement against a table that has an identity column in SQL Server 2005 June 26, 2007
9.00.2226 9.0.2226 2005.90.2226.0Q934065 KB934065 934065 FIX: Error message when the Replication Merge Agent runs to synchronize a merge replication subscription in SQL Server 2005: "The merge process failed to execute a query because the query timed out" June 22, 2007
9.00.2226 9.0.2226 2005.90.2226.0Q933762 KB933762 933762 FIX: You receive error 18815 when the Log Reader Agent runs for a transactional publication in SQL Server 2005 June 22, 2007
9.00.2223 9.0.2223 2005.90.2223.0Q932393 KB932393 932393 FIX: You may experience poor performance after you install SQL Server 2005 Service Pack 1 June 18, 2007
9.00.2221 9.0.2221 2005.90.2221.0Q931593 KB931593 931593 FIX: A script task or a script component may not run correctly when you run an SSIS package in SQL Server 2005 build 2153 and later builds July 11, 2007
9.00.2219 9.0.2219 2005.90.2219.0Q932115 KB932115 932115 FIX: The ghost row clean-up thread does not remove ghost rows on some data files of a database in SQL Server 2005 April 25, 2007
9.00.2218 9.0.2218 2005.90.2218.0Q931843 KB931843 931843 FIX: SQL Server 2005 does not reclaim the disk space that is allocated to the temporary table if the stored procedure is stopped April 25, 2007
9.00.2216 9.0.2216 2005.90.2216.0Q931821 KB931821 931821 FIX: High CPU utilization by SQL Server 2005 may occur when you use NUMA architecture on a computer that has an x64-based version of SQL Server 2005 installed May 15, 2007
9.00.2214 9.0.2214 2005.90.2214.0Q930505 KB930505 930505 FIX: Error message when you run DML statements against a table that is published for merge replication in SQL Server 2005: "Could not find stored procedure" February 19, 2007
9.00.2214 9.0.2214 2005.90.2214.0Q929240 KB929240 929240 FIX: I/O requests that are generated by the checkpoint process may cause I/O bottlenecks if the I/O subsystem is not fast enough to sustain the IO requests in SQL Server 2005 February 13, 2007
9.00.2211 9.0.2211 2005.90.2211.0Q930284 KB930284 930284 FIX: You receive error 1456 when you try to add a witness to a DBM session in SQL Server 2005 February 20, 2007
9.00.2211 9.0.2211 2005.90.2211.0Q930283 KB930283 930283 FIX: You receive error 1456 when you add a witness to a database mirroring session and the database name is the same as an existing database mirroring session in SQL Server 2005 February 14, 2007
9.00.2209 9.0.2209 2005.90.2209.0Q929278 KB929278 929278 FIX: SQL Server 2005 may not perform histogram amendments when you use trace flags 2389 and 2390 February 7, 2007
9.00.2208 9.0.2208 2005.90.2208.0Q929179 KB929179 929179 FIX: A memory leak may occur every time that you synchronize a SQL Server Mobile subscriber in SQL Server 2005 January 9, 2007
9.00.2207 9.0.2207 2005.90.2207.0Q928394 KB928394 928394 FIX: The changes are not reflected in the publication database after you reinitialize the subscriptions in SQL Server 2005 December 19, 2006
9.00.2207 9.0.2207 2005.90.2207.0Q928372 KB928372 928372 FIX: Error message when you use a synonym for a stored procedure in SQL Server 2005: "A severe error occurred on the current command" December 19, 2006
9.00.2207 9.0.2207 2005.90.2207.0Q928789 KB928789 928789 FIX: Error message in the database mail log when you try to use the sp_send_dbmail stored procedure to send an e-mail in SQL Server 2005: "Invalid XML message format received on the ExternalMailQueue" January 2, 2007
9.00.2206 9.0.2206 2005.90.2206.0Q928083 KB928083 928083 FIX: You may receive an error message when you run a CLR stored procedure or CLR function that uses a context connection in SQL Server 2005 February 1, 2007
9.00.2206 9.0.2206 2005.90.2206.0Q928537 KB928537 928537 FIX: The full-text index population for the indexed view is very slow in SQL Server 2005 January 12, 2007
9.00.2206 9.0.2206 2005.90.2206.0Q926493 KB926493 926493 FIX: Error message when you restore a transaction-log backup that is generated in SQL Server 2000 SP4 to an instance of SQL Server 2005: Msg 3456, Level 16, State 1, Line 1. Could not redo log record" January 2, 2007
9.00.2206 9.0.2206 2005.90.2206.0Q928539 KB928539 928539 FIX: An access violation is logged in the SQL Server Errorlog file when you run a query that uses a plan guide in SQL Server 2005 December 13, 2006
9.00.2202 9.0.2202 2005.90.2202.0Q927643 KB927643 927643 FIX: Some search results are missing when you perform a full-text search operation on a Windows SharePoint Services 2.0 site after you upgrade to SQL Server 2005 February 16, 2007
9.00.2201 9.0.2201 2005.90.2201.0Q927289 KB927289 927289 FIX: Updates to the SQL Server Mobile subscriber may not be reflected in the SQL Server 2005 merge publication January 10, 2007
9.00.2198 9.0.2198 2005.90.2198.0Q926613 KB926613 926613 FIX: You may receive incorrect results when you query a table that is published in a transactional replication in SQL Server 2005 February 21, 2007
9.00.2198 9.0.2198 2005.90.2198.0Q926106 KB926106 926106 FIX: You receive an error message when you use the Print Preview option on a large report in SQL Server 2005 Reporting Services February 20, 2007
9.00.2198 9.0.2198 2005.90.2198.0Q924807 KB924807 924807 FIX: The restore operation may take a long time to finish when you restore a database in SQL Server 2005 February 2, 2007
9.00.2198 9.0.2198 2005.90.2198.0Q924264 KB924264 924264 FIX: The metadata of the Description object of a Key Performance Indicator appears in the default language after you define a translation for the Description object in SQL Server 2005 Business Intelligence Development Studio December 13, 2006
9.00.2198 9.0.2198 2005.90.2198.0Q926612 KB926612 926612 FIX: SQL Server Agent does not send an alert quickly or does not send an alert when you use an alert of the SQL Server event alert type in SQL Server 2005 January 4, 2007
9.00.2198 9.0.2198 2005.90.2198.0Q926773 KB926773 926773 FIX: Error message when you run a query that uses a fast forward-only cursor in SQL Server 2005: "Query processor could not produce a query plan because of the hints defined in this query" November 16, 2006
9.00.2198 9.0.2198 2005.90.2198.0Q926611 KB926611 926611 FIX: SQL Server 2005 may not send a message notification that is based on the specific string in the forwarded event when a computer that is running SQL Server 2000 forwards an event to a computer that is running SQL Server 2005 November 28, 2006
9.00.2198 9.0.2198 2005.90.2198.0Q924808 KB924808 924808 FIX: You receive an error message, or you obtain an incorrect result when you query data in a partitioned table that does not have a clustered index in SQL Server 2005 December 13, 2006
9.00.2198 9.0.2198 2005.90.2198.0Q925277 KB925277 925277 FIX: You may experience very large growth increments of a principal database after you manually fail over a database mirroring session in SQL Server 2005 January 2, 2007
9.00.2196 9.0.2196 2005.90.2196.0Q926285 KB926285 926285 Fix: Error message when you convert a column from the varbinary(max) data type to the XML data type in SQL Server 2005: "Msg 6322, Level 16, State 1, Line 2 Too many attributes or namespace definitions" November 10, 2006
9.00.2196 9.0.2196 2005.90.2196.0Q926335 KB926335 926335 FIX: Error message when you trace the Audit Database Management event and you try to bring a database online in SQL Server 2005: “Msg 942, Level 14, State 4, Line 1” December 5, 2006
9.00.2195 9.0.2195 2005.90.2195.0Q926240 KB926240 926240 FIX: SQL Server 2005 may stop responding when you use the SqlBulkCopy class to import data from another data source December 19, 2006
9.00.2194 9.0.2194 2005.90.2194.0Q925744 KB925744 925744 FIX: Error message when you try to use a SQL Server authenticated login to log on to an instance of SQL Server 2005: "Logon error: 18456" October 20, 2006
9.00.2192 9.0.2192 2005.90.2192.0Q924954 KB924954 924954 FIX: Error message when you use a table-valued function (TVF) together with the CROSS APPLY operator in a query in SQL Server 2005: "There is insufficient system memory to run this query" September 29, 2006
9.00.2192 9.0.2192 2005.90.2192.0Q925335 KB925335 925335 FIX: Error message when you use a label after a Transact-SQL query in SQL Server 2005: "Incorrect syntax near 'X'" October 5, 2006
9.00.2191 9.0.2191 2005.90.2191.0Q925135 KB925135 925135 FIX: An empty string is replicated as a NULL value when you synchronize a table to a SQL Server 2005 Compact Edition subscriber December 6, 2006
9.00.2190 9.0.2190 2005.90.2190.0Q925227 KB925227 925227 FIX: Error message when you call the SQLTables function against an instance of SQL Server 2005: "Invalid cursor state (0)" October 16, 2006
9.00.2189 9.0.2189 2005.90.2189.0Q925153 KB925153 925153 FIX: You may receive different date values for each row when you use the getdate function within a case statement in SQL Server 2005 September 22, 2006
9.00.2187 9.0.2187 2005.90.2187.0Q923849 KB923849 923849 FIX: When you run a query that references a partitioned table in SQL Server 2005, query performance may decrease September 22, 2006
9.00.2181 9.0.2181 2005.90.2181.0Q923605 KB923605 923605 FIX: A deadlock occurs and a query never finishes when you run the query on a computer that is running SQL Server 2005 and has multiple processors February 19, 2007
9.00.2181 9.0.2181 2005.90.2181.0Q923624 KB923624 923624 FIX: Error message when you run an application against SQL Server 2005 that uses many unique user logins or performs many user login impersonations: "insufficient system memory to run this query" October 4, 2006
9.00.2176 9.0.2176 2005.90.2176.0Q922594 KB922594 922594 FIX: Error message when you use SQL Server 2005: "High priority system task thread Operating system error Exception 0xAE encountered" February 12, 2007
9.00.2176 9.0.2176 2005.90.2176.0Q923296 KB923296 923296 FIX: Log Reader Agent fails, and an assertion error message is logged when you use transactional replication in SQL Server 2005 September 6, 2006
9.00.2175 9.0.2175 2005.90.2175.0Q921395 KB921395 921395 FIX: The color and the background image may not appear when you try to display a report in HTML format in Report Manager in SQL Server 2005 Reporting Services August 8, 2006
9.00.2175 9.0.2175 2005.90.2175.0Q917905 KB917905 917905 FIX: SQL Server 2005 performance may be slower than SQL Server 2000 performance when you use an API server cursor August 14, 2006
9.00.2175 9.0.2175 2005.90.2175.0Q922578 KB922578 922578 FIX: In SQL Server 2005, the sp_altermessage stored procedure does not suppress system error messages that are logged in the SQL Server error log and in the Application log August 30, 2006
9.00.2175 9.0.2175 2005.90.2175.0Q922438 KB922438 922438 FIX: A query may take a long time to compile when the query contains several JOIN clauses against a SQL Server 2005 database December 14, 2006
9.00.2175 9.0.2175 2005.90.2175.0Q921536 KB921536 921536 FIX: A handled access violation may occur in the CValSwitch::GetDataX function when you run a complex query in SQL Server 2005 December 18, 2006
9.00.2174 9.0.2174 2005.90.2174.0Q922063 KB922063 922063 FIX: You may notice a large increase in compile time when you enable trace flags 2389 and 2390 in SQL Server 2005 Service Pack 1 July 25, 2006
9.00.2167 9.0.2167 2005.90.2167.0Q920974 KB920974 920974 FIX: SQL Server 2005 treats an identity column in a view as an ordinary int column when the compatibility level of the database is set to 80 August 9, 2006
9.00.2164 9.0.2164 2005.90.2164.0Q919243 KB919243 919243 FIX: Some rows in the Text Data column are always displayed for a trace that you create by using SQL Server Profiler in SQL Server 2005 February 8, 2007
9.00.2164 9.0.2164 2005.90.2164.0Q920346 KB920346 920346 FIX: SQL Server 2005 may overestimate the cardinality of the JOIN operator when a SQL Server 2005 query contains a join predicate that is a multicolumn predicate September 19, 2006
9.00.2164 9.0.2164 2005.90.2164.0Q920347 KB920347 920347 FIX: The SQL Server 2005 query optimizer may incorrectly estimate the cardinality for a query that has a predicate that contains an index union alternative September 19, 2006
9.00.2164 9.0.2164 2005.90.2164.0Q919929 KB919929 919929 FIX: Error message when the Replication Merge Agent runs in SQL Server 2005: "Source: MSSQL_REPL, Error number: MSSQL_REPL-2147199402" October 26, 2006
9.00.2164 9.0.2164 2005.90.2164.0Q921003 KB921003 921003 FIX: You may receive an error message when you manually define a Back Up Database task in SQL Server 2005 to back up the transaction log August 29, 2006
9.00.2164 9.0.2164 2005.90.2164.0Q920206 KB920206 920206 FIX: System performance may be slow when an application submits many queries against a SQL Server 2005 database that uses simple parameterization September 26, 2006
9.00.2164 9.0.2164 2005.90.2164.0Q918882 KB918882 918882 FIX: A query plan is not cached in SQL Server 2005 when the text of the hint is a large object September 6, 2006
9.00.2164 9.0.2164 2005.90.2164.0Q919636 KB919636 919636 FIX: Memory usage of the compiled query plan may unexpectedly increase in SQL Server 2005 July 26, 2006
9.00.2164 9.0.2164 2005.90.2164.0Q919775 KB919775 919775 FIX: The BULK INSERT statement may not return any errors when you try to import data from a text file to a table by using the BULK INSERT statement in Microsoft SQL Server 2005 August 9, 2006
9.00.2156 9.0.2156 2005.90.2156.0Q919611 KB919611 919611 FIX: The value of the automatic growth increment of a database file may be very large in SQL Server 2005 with Service Pack 1 July 26, 2006
9.00.2153 9.0.2153 2005.90.2153.0Q918222 KB918222 918222 Cumulative hotfix package (build 2153) for SQL Server 2005 is available September 14, 2006 Downloadable
9.00.2153 9.0.2153 2005.90.2153.0Q919224 KB919224 919224 FIX: You may receive an error message when you install the cumulative hotfix package (build 2153) for SQL Server 2005 May 23, 2006 Downloadable
9.00.2050 9.0.2050 2005.90.2050.0Q932555 KB932555 932555 FIX: A script task or a script component may not run correctly when you run an SSIS package in SQL Server 2005 build 2047 July 11, 2007
9.00.2047 9.0.2047 2005.90.2047.0SQL Server 2005 Service Pack 1 (SP1) April 18, 2006 Downloadable
9.00.2040 9.0.2040 2005.90.2040.0SQL Server 2005 Service Pack 1 (SP1) CTP March 2006 March 12, 2006
9.00.2029 9.0.2029 2005.90.2029.0SLQ Server 2005 Service Pack 1 (SP1) Beta
9.00.1561 9.0.1561 2005.90.1561.0Q932556 KB932556 932556 FIX: A script task or a script component may not run correctly when you run an SSIS package in SQL Server 2005 build 1500 and later builds July 11, 2007
9.00.1558 9.0.1558 2005.90.1558.0Q926493 KB926493 926493 FIX: Error message when you restore a transaction-log backup that is generated in SQL Server 2000 SP4 to an instance of SQL Server 2005: "Msg 3456, Level 16, State 1, Line 1. Could not redo log record" January 4, 2007
9.00.1554 9.0.1554 2005.90.1554.0Q926292 KB926292 926292 FIX: When you query through a view that uses the ORDER BY clause in SQL Server 2005, the result is still returned in random order June 26, 2007
9.00.1551 9.0.1551 2005.90.1551.0Q922527 KB922527 922527 FIX: Error message when you schedule some SQL Server 2005 Integration Services packages to run as jobs: "Package <PackageName> has been cancelled" January 22, 2007
9.00.1551 9.0.1551 2005.90.1551.0Q922804 KB922804 922804 FIX: After you detach a Microsoft SQL Server 2005 database that resides on network-attached storage, you cannot reattach the SQL Server database November 22, 2006
9.00.1550 9.0.1550 2005.90.1550.0Q917887 KB917887 917887 FIX: The value of the automatic growth increment of a database file may be very large in SQL Server 2005 July 26, 2006
9.00.1550 9.0.1550 2005.90.1550.0Q921106 KB921106 921106 FIX: You receive an error message when you try to create a differential database backup in SQL Server 2005 November 22, 2006
9.00.1547 9.0.1547 2005.90.1547.0Q918276 KB918276 918276 FIX: You notice additional random trailing character in values when you retrieve the values from a fixed-size character column or a fixed-size binary column of a table in SQL Server 2005 November 20, 2006
9.00.1545 9.0.1545 2005.90.1545.0Q917905 KB917905 917905 FIX: SQL Server 2005 performance may be slower than SQL Server 2000 performance when you use an API server cursor August 14, 2006
9.00.1541 9.0.1541 2005.90.1541.0Q917888 KB917888 917888 FIX: Error message when you use a server-side cursor to run a large complex query in SQL Server 2005: "Error: 8623, Severity: 16, State: 1 The query processor ran out of internal resources" November 22, 2006
9.00.1541 9.0.1541 2005.90.1541.0Q917971 KB917971 917971 FIX: You may receive more than 100,000 page faults when you try to back up a SQL Server 2005 database that contains hundreds of files and file groups November 22, 2006
9.00.1539 9.0.1539 2005.90.1539.0Q917738 KB917738 917738 FIX: SQL Server 2005 system performance may be slow when you use a keyset-driven cursor to execute a FETCH statement August 11, 2006
9.00.1538 9.0.1538 2005.90.1538.0Q917824 KB917824 917824 FIX: The SQL Server 2005 SqlCommandBuilder.DeriveParameters method returns an exception when the input parameter is a XML parameter that has an associated XSD from an SQL schema July 26, 2006
9.00.1536 9.0.1536 2005.90.1536.0Q917016 KB917016 917016 FIX: The monitor server does not monitor all primary servers and secondary servers when you configure log shipping in SQL Server 2005 July 26, 2006
9.00.1534 9.0.1534 2005.90.1534.0Q916706 KB916706 916706 FIX: When you run the "dbcc dbreindex" command or the "alter index" command, some transactions are not replicated to the subscribers in a transactional replication in SQL Server 2005 May 15, 2007
9.00.1533 9.0.1533 2005.90.1533.0Q916086 KB916086 916086 FIX: Errors may be generated in the tempdb database when you create and then drop many temporary tables in SQL Server 2005 July 26, 2006
9.00.1532 9.0.1532 2005.90.1532.0Q916046 KB916046 916046 FIX: Indexes may grow very large when you insert a row into a table and then update the same row in SQL Server 2005 January 9, 2007
9.00.1531 9.0.1531 2005.90.1531.0Q915918 KB915918 915918 FIX: The internal deadlock monitor may not detect a deadlock between two or more sessions in SQL Server 2005 July 26, 2006
9.00.1528 9.0.1528 2005.90.1528.0Q915309 KB915309 915309 FIX: When you start a merge agent, synchronization between the subscriber and the publisher takes a long time to be completed in SQL Server 2005 January 15, 2007
9.00.1528 9.0.1528 2005.90.1528.0Q915308 KB915308 915308 FIX: The CPU usage of the server reaches 100% when many DML activities occur in SQL Server 2005 January 4, 2007
9.00.1528 9.0.1528 2005.90.1528.0Q915307 KB915307 915307 FIX: You experience a slow uploading process if conflicts occur when many merge agents upload changes to the publishers at the same time in SQL Server 2005 January 11, 2007
9.00.1528 9.0.1528 2005.90.1528.0Q915306 KB915306 915306 FIX: The merge agent fails and a "permission denied" error message is logged when you synchronize a SQL Server 2005-based merge publication January 8, 2007
9.00.1528 9.0.1528 2005.90.1528.0Q915112 KB915112 915112 FIX: Error message when an ADO.NET-connected application tries to reuse a connection from the connection pool in SQL Server 2005: "The request failed to run because the batch is aborted" July 26, 2006
9.00.1519 9.0.1519 2005.90.1519.0Q913494 KB913494 913494 FIX: The merge agent does not use a specified custom user update to handle conflicting UPDATE statements in SQL Server 2005 January 20, 2007
9.00.1518 9.0.1518 2005.90.1518.0Q913941 KB913941 913941 FIX: A SQL Server login may have more permissions when you log on to an instance of SQL Server 2005 September 22, 2006
9.00.1518 9.0.1518 2005.90.1518.0Q912472 KB912472 912472 FIX: An incorrect result may appear in the subscribing database when you set database mirroring for a database and database failover occurs in SQL Server 2005 July 26, 2006
9.00.1518 9.0.1518 2005.90.1518.0Q913371 KB913371 913371 FIX: You may receive error messages when you use the sp_cursoropen statement to open a cursor on a user-defined stored procedure in SQL Server 2005 July 26, 2006
9.00.1514 9.0.1514 2005.90.1514.0Q912471 KB912471 912471 FIX: The replication on the server does not work any longer when you manually fail over databases in SQL Server 2005 July 26, 2006
9.00.1503 9.0.1503 2005.90.1503.0Q911662 KB911662 911662 FIX: You may receive an access violation error message when you run a SELECT query in SQL Server 2005 July 26, 2006
9.00.1502 9.0.1502 2005.90.1502.0Q915793 KB915793 915793 FIX: You cannot restore the log backups on the mirror server after you remove database mirroring for the mirror database in SQL Server 2005 July 26, 2006
9.00.1500 9.0.1500 2005.90.1500.0Q910416 KB910416 910416 FIX: Error message when you run certain queries or certain stored procedures in SQL Server 2005: "A severe error occurred on the current command" June 1, 2006
9.00.1406 9.0.1406 2005.90.1406.0Q932557 KB932557 932557 FIX: A script task or a script component may not run correctly when you run an SSIS package in SQL Server 2005 build 1399 July 11, 2007 Downloadable
9.00.1399 9.0.1399 2005.90.1399.0SQL Server 2005 RTM November 7, 2005