Browse by Tags

List of modified Knowledge Base articles in SQL Server 2005 Enterprise X64 Edition

Published 16 November 7 5:14 PM | SSQA.net

The following pages were recently modified, rather than posting each as a blog post I have included them here: Source: Knowledge Base Product: Microsoft SQL Server 2005 Enterprise X64 Edition Notification Contents: New and All Modifications FIX: A gradual...

Filed under: sql server, restore, database, kba, service pack2, x64, backups, modified

FIX: Error message when you run the DBCC CHECKTABLE statement or the DBCC CHECKDB statement in Microsoft SQL Server 2005: "Column '<ColumnName>' value is out of range for data type 'float'"

Published 26 October 7 2:40 PM | SSQA.net

The following pages were recently modified. Source: Knowledge Base Product: Microsoft SQL Server 2005 Enterprise Edition, SQL Server 2005 Standard Edition & SQLL Server 2005 Enterpris X64 Edition Notification Contents: New and Major Modifications...

Filed under: sql server, database, kba, datatype, column, dbcc checktable, float, dbcc checkdb

Error message when you create a snapshot backup of many databases at the same time in SQL Server 2005: "ERROR Selected writer 'Microsoft Writer (Service State)' is in failed state"

Published 21 October 7 12:57 PM | SSQA.net

The following pages were recently modified. Source: Knowledge Base Product: Microsoft SQL Server 2005 Standard Edition & SQL Server 2005 Enterprise Edition Notification Contents: New and All Modifications Error message when you create a snapshot backup...

Filed under: sql server, database, error, kba, snapshot, service state, writer

How to move SQL Server databases to a new location by using Detach and Attach functions in SQL Server

Published 5 October 7 7:29 AM | SSQA.net

The following pages were recently modified. Source: Knowledge Base Product: Microsoft SQL Server 2005 Enterprise Edition & SQL Server 2005 Standard Edition Notification Contents: New and Major Modifications How to move SQL Server databases to a new...

Filed under: sql server, database, kba, disaster recovery, move, detach, attach

FIX: In a maintenance plan, the databases that you selected are no longer selected when you edit a Back Up Database task in SQL Server 2005 Service Pack 2

Published 19 September 7 5:23 PM | SSQA.net

The following pages were recently modified. Source: Knowledge Base Product: Microsoft SQL Server 2005 Standard Edition, SQL Server 2005 Enterprise X64 Edition & SQL Server 2005 Enterprise Edition Notification Contents: New and All Modifications FIX...

Filed under: sql server, database, plan, kba, maintenance, service pack2, backups

FIX: The ghost row clean-up thread does not remove ghost rows on some data files of a database in SQL Server 2005

Published 12 September 7 12:48 PM | SSQA.net

The following pages were recently modified. Source: Knowledge Base Product: Microsoft SQL Server 2005 Standard Edition Notification Contents: New and All Modifications FIX: The ghost row clean-up thread does not remove ghost rows on some data files of...

Filed under: sql server, database, kba, data files, ghost, rows, cleanup

How to resolve permission issues when you move a database between servers that are running SQL Server

Published 5 September 7 11:41 AM | SSQA.net

The following pages were recently modified. Source: Knowledge Base Product: Microsoft SQL Server 2005 Standard Edition Notification Contents: New and All Modifications How to resolve permission issues when you move a database between servers that are...

Filed under: sql server, database, kba, permission, move, servers

The auto update statistics option, the auto create statistics option, and the Parallelism setting are turned off in the SQL Server 2000 or SQL Server 2005 database instance that hosts the BizTalk Server 2004 or BizTalk Server 2006 BizTalkMsgBoxDB database

Published 23 August 7 6:24 AM | SSQA.net

The following pages were recently modified. Source: Knowledge Base Product: Microsoft SQL Server 2005 Enterprise Edition, SQL Server 2005 Enterprise X64 Edition & SQL Server 2005 Standard Edition Notification Contents: New and Major Modifications...

Filed under: sql server, database, kba, enterprise, x64, statistics, parallelism, biztalk, auto

FIX: Error message when you use the Copy Database Wizard to move a database from SQL Server 2000 to SQL Server 2005

Published 20 August 7 3:33 PM | SSQA.net

Source: Knowledge Base Product: Microsoft SQL Server 2005 Enterprise Edition, SQL Server 2005 Standard Edition & SQL Server 2005 Enterprise X64 Edition Notification , Contents: New and Major Modifications FIX: Error message when you use the Copy Database...

Filed under: sql server, database, error, kba, copy, wizard

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"

Published 19 August 7 4:44 PM | SSQA.net

Source: Knowledge Base Product: Microsoft SQL Server 2005 Standard Edition, SQL Server 2005 Enterprise X64 Edition & SQL Server 2005 Enterprise Edition Notification Contents: New and All Modifications FIX: Error message when you run a stored procedure...

Filed under: sql server, database, upgrade, kba, timeout

Modified KBA - How to transfer a database from one collation to another collation in SQL Server

Published 16 August 7 3:37 PM | SSQA.net

Source: Knowledge Base Product: Microsoft SQL Server 2005 Enterprise Edition & SQL Server 2005 Standard Edition Notification Contents: New and Major Modifications How to transfer a database from one collation to another collation in SQL Server http...

Filed under: sql server, database, kba, collation, transfer

FIX: The performance of insert operations against a table that contains an identity column may be slow in SQL Server 2005

Published 11 August 7 5:15 AM | SSQA.net

Source: Knowledge Base Product: Microsoft SQL Server 2005 Standard Edition & SQL Server 2005 Enterprise Edition Notification Contents: New and All Modifications FIX: The performance of insert operations against a table that contains an identity column...

Filed under: sql server, performance, database, kba, insert

FIX: You may receive an access violation or error 942 when you drop a database in SQL Server 2005

Published 10 July 7 4:49 PM | SSQA.net

Source: Knowledge Base Product: Microsoft SQL Server 2005 Standard Edition, SQL Server 2005 Enterprise X64 Edition & SQL Server 2005 Enterprise Edition Notification Contents: New and All Modifications FIX: You may receive an access violation or error...

Filed under: sql server, database, kba, violation, access, drop

FIX: A database is marked as suspect when you update a table that contains a nonclustered index in SQL Server 2005

Published 8 July 7 7:14 AM | SSQA.net

Source: Knowledge Base Product: Microsoft SQL Server 2005 Enterprise Edition, SQL Server 2005 Standard Edition & SQL Server 2005 Enterprise x64 Edition Notification Contents: New and Major Modifications FIX: A database is marked as suspect when you...

Filed under: sql server, database, kba, index, suspect

FIX: Error message when you use the Playback Capture Wizard (PCW) to capture a backup of a database that is larger than 2 terabytes: "Unable to obtain required information about the server"

Published 28 June 7 12:42 PM | SSQA.net

Source: Knowledge Base Product: Microsoft SQL Server 2005 Standard Edition & SQL Server 2005 Enterprise X64 Edition Notification Contents: New and All Modifications FIX: Error message when you use the Playback Capture Wizard (PCW) to capture a backup...

Filed under: sql server, backup, database, kba, storage

FIX: Error message when you run the CHECKPOINT statement after you restore a database that has a read-only user-defined filegroup in SQL Server 2005: "The operating system returned error 5(Access is denied.) to SQL Server

Published 27 June 7 11:42 AM | SSQA.net

Source: Knowledge Base Product: Microsoft SQL Server 2005 Standard Edition & SQL Server 2005 Enterprise X64 Edition Notification Contents: New and All Modifications FIX: Error message when you run the CHECKPOINT statement after you restore a database...

Filed under: sql server, restore, database, kba, access, checkpoint, denied

SQL Server 2005 unable to shrink the transaction log, help? (peculiar issue)

Published 15 June 7 5:19 PM | SSQA.net

On one of the archive database (using SQL 2005) we have a monthly task to shrink the transaction log during every 1st week of the month, this is required due to clear up the space on one of the drives where the additional transaction log file located...

Filed under: sql server, performance, database, transaction log, kba, article, shrink

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

Published 13 June 7 12:48 PM | SSQA.net

Source: Knowledge Base Product: Microsoft SQL Server 2005 Enterprise Edition & Standard Edition Notification Contents: New and Major Modifications FIX: When you query through a view that uses the ORDER BY clause in SQL Server 2005, the result is still...

Filed under: sql server, database, kba, random, order

Modified: A clean-up task does not delete database maintenance plan reports after you install SQL Server 2005 Service Pack 2

Published 8 June 7 2:24 PM | SSQA.net

Source: Knowledge Base Product: Microsoft SQL Server 2005 Enterprise Edition Notification Contents: New and Major Modifications A clean-up task does not delete database maintenance plan reports after you install SQL Server 2005 Service Pack 2 http://support...

Filed under: sql server, database, sp2, kba, maintenance

SQL Server 2005 Service Pack 2: "Piecemeal restore is not supported when an upgrade is involved"

Published 4 June 7 7:24 PM | SSQA.net

Source: Knowledge Base Product: Microsoft SQL Server 2005 Enterprise Edition 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...

Filed under: sql server, database, kba, mirroring