Browse Site by Tags - MSMVPS.COM

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"

The following pages were recently modified. 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 messages when you delete some records of...

Posted to SQLServer-QA.net - Knowledge Sharing Network (SSQA.net) (Weblog) by Anonymous on 01-11-2008
Filed under: sql server, kba, transaction, maintenance, errorr, 3314, 9001, 9002

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

On a computer that has a 64-bit processor, you receive an error message in SQL Server Management Studio when you connect to SQL Server 2005 Integration Services or when you create or edit a maintenance plan

The following pages were recently modified. 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 On a computer that has a 64-bit processor, you receive...

Posted to SQLServer-QA.net - Knowledge Sharing Network (SSQA.net) (Weblog) by Anonymous on 08-23-2007
Filed under: sql server, integration, ssis, ssms, services, plan, kba, maintenance

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

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.microsoft.com/kb/938085/en-US...( read more...

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