Browse Site by Tags - MSMVPS.COM

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

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 increase in memory consumption for the USERSTORE_TOKENPERM...

Posted to SQLServer-QA.net - Knowledge Sharing Network (SSQA.net) (Weblog) by Anonymous on 11-16-2007
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'"

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 FIX: Error message when you run the DBCC CHECKTABLE...

Posted to SQLServer-QA.net - Knowledge Sharing Network (SSQA.net) (Weblog) by Anonymous on 10-26-2007
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"

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 of many databases at the same time in SQL Server...

Posted to SQLServer-QA.net - Knowledge Sharing Network (SSQA.net) (Weblog) by Anonymous on 10-21-2007
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

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 location by using Detach and Attach functions in...

Posted to SQLServer-QA.net - Knowledge Sharing Network (SSQA.net) (Weblog) by Anonymous on 10-05-2007
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

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: In a maintenance plan, the databases that you selected...

Posted to SQLServer-QA.net - Knowledge Sharing Network (SSQA.net) (Weblog) by Anonymous on 09-19-2007
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

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 a database in SQL Server 2005 http://support.microsoft...

Posted to SQLServer-QA.net - Knowledge Sharing Network (SSQA.net) (Weblog) by Anonymous on 09-12-2007
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

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 running SQL Server http://support.microsoft.com/kb...

Posted to SQLServer-QA.net - Knowledge Sharing Network (SSQA.net) (Weblog) by Anonymous on 09-05-2007
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

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 The auto update statistics option, the auto create...

Posted to SQLServer-QA.net - Knowledge Sharing Network (SSQA.net) (Weblog) by Anonymous on 08-23-2007
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

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 Wizard to move a database from SQL Server...

Posted to SQLServer-QA.net - Knowledge Sharing Network (SSQA.net) (Weblog) by Anonymous on 08-20-2007
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"

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 that references tables after you upgrade a database...

Posted to SQLServer-QA.net - Knowledge Sharing Network (SSQA.net) (Weblog) by Anonymous on 08-19-2007
Filed under: sql server, database, upgrade, kba, timeout