Browse Site by Tags - MSMVPS.COM

You may receive an error message when a SQL Server 2005 client requests encryption and connects to 127.0.0.1 on a Windows XP-based computer

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 You may receive an error message when a SQL Server...

Posted to SQLServer-QA.net - Knowledge Sharing Network (SSQA.net) (Weblog) by Anonymous on 11-20-2007
Filed under: sql server, kba, enterprise, encryption, client, x64, xp, 127.0.0.1

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"

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 message when you run a stored procedure...

Posted to SQLServer-QA.net - Knowledge Sharing Network (SSQA.net) (Weblog) by Anonymous on 08-23-2007
Filed under: sql server, kba, transaction, enterprise, x64, stored procedure, tsql

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

KBA: A list of the bugs that have been fixed in SQL Server 2005 Service Pack 1

Source: Knowledge Base Product: Microsoft SQL Server 2005 Enterprise X64 Edition, SQL Server 2005 Reporting Services & SQL Server 2005 Standard Edition Notification Contents: New and All Modifications A list of the bugs that have been fixed in SQL Server 2005 Service Pack 1 http://support.microsoft...

Posted to SQLServer-QA.net - Knowledge Sharing Network (SSQA.net) (Weblog) by Anonymous on 06-27-2007
Filed under: sql server, kba, standard, enterprise, x64, sp1

FIX: You may receive error 1203 when you run an INSERT statement against a table that has an identity column in 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: You may receive error 1203 when you run an INSERT statement against a table that has an identity...

Posted to SQLServer-QA.net - Knowledge Sharing Network (SSQA.net) (Weblog) by Anonymous on 06-27-2007
Filed under: sql server, kba, standard, edition, enterprise, x64, insert

Recently modified Knowledge Base Articles for SQL Server Enterprise Edition (32 & 64 bit)

Source: Knowledge Base Product: Microsoft SQL Server 2005 Enterprise Edition The SQL Server 2005 builds that were released after SQL Server 2005 Service Pack 2 was released http://support.microsoft.com/kb/937137/en-US FIX: Error messages when you run a query that references a view in SQL Server 2005...

Posted to SQLServer-QA.net - Knowledge Sharing Network (SSQA.net) (Weblog) by Anonymous on 06-21-2007
Filed under: sql server, kba, standard, enterprise, x64

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

Source: Knowledge Base Product: Microsoft SQL Server 2005 Enterprise Edition 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 http://support.microsoft.com/kb/937745/en-US...( read more )

Posted to SQLServer-QA.net - Knowledge Sharing Network (SSQA.net) (Weblog) by Anonymous on 06-04-2007
Filed under: sql server, kba, enterprise, concurrent, connections