Follow SQLMaster on Twitter
Welcome to SqlServer-QA.net Sign in | Help

SQL Server Knowledge Base articles (SSQA.net)

Microsoft support engineers regularly document the solutions to problems that customers call in with, they are Knowledge Base articles or we call them as KBA.
SQL Server 2005 Enterprise & Standard Editions Knowledge Base Notifications

Source: Knowledge Base
Product: Microsoft SQL Server 2005 Enterprise Edition
Notification Contents: New

FIX: A SQL Server Agent job that creates a ServerXMLHTTP object by using an ActiveX script remains in the Executing status and is never completed in SQL Server 2005
http://support.microsoft.com/kb/958555/en-US
New 10/20/2008 8:16:00 PM GMT

FIX: Log Reader Agent fails with error code 18834 in SQL Server 2005
http://support.microsoft.com/kb/958684/en-US
New 10/20/2008 8:16:00 PM GMT

FIX: If you enter many rows into the Fuzzy Grouping transformation, you may obtain an incorrect result in SQL Server 2005 Integration Services
http://support.microsoft.com/kb/959030/en-US
New 10/20/2008 8:16:00 PM GMT

FIX: An access violation occurs when you display the execution plan for a query that selects a computed column from a remote table in SQL Server 2005
http://support.microsoft.com/kb/957756/en-US
New 10/20/2008 8:16:00 PM GMT

FIX: Error message when you restore a transaction log for a database by using the STANDBY option in SQL Server 2005: "The transaction log for database '<DatabaseName>' is full"
http://support.microsoft.com/kb/958554/en-US
New 10/20/2008 8:16:00 PM GMT

FIX: A memory leak occurs when you repeatedly invoke a trigger that contains the RAISERROR statement in SQL Server 2005
http://support.microsoft.com/kb/958573/en-US
New 10/20/2008 8:16:00 PM GMT

FIX: Error message when you run a query in SQL Server 2005 by using a linked server to SQL Server 2000 after you change the login password: "Communication link failure"
http://support.microsoft.com/kb/955971/en-US
New 10/20/2008 8:32:00 PM GMT

FIX: Error message when you run a full-text search query in SQL Server 2005: "Insufficient system resources exist to complete the requested service"
http://support.microsoft.com/kb/948452/en-US
New 10/20/2008 8:32:00 PM GMT

FIX: A time-out setting is not available for the Web Service task in a Microsoft SQL Server 2005 Integration Services (SSIS) package
http://support.microsoft.com/kb/956911/en-US
New 10/20/2008 8:32:00 PM GMT

FIX: When you run a query that contains a JOIN operation in SQL Server 2005, and the ON clause of the JOIN operator contains a LIKE predicate, the query runs slower than in SQL Server 2000
http://support.microsoft.com/kb/956686/en-US
New 10/20/2008 8:32:00 PM GMT

FIX: The file growth setting is incorrect after you restore a database from SQL Server 2000 in SQL Server 2005
http://support.microsoft.com/kb/958004/en-US
New 10/20/2008 8:32:00 PM GMT

FIX: A peer-to-peer transactional replication does not replicate rows if you rebuild the index for a published table at the same time as you insert data in the published table in SQL Server 2005
http://support.microsoft.com/kb/959032/en-US
New 10/20/2008 8:32:00 PM GMT

FIX: Error message when you run the snapshot agent on a replication of a stored procedure in SQL Server 2005: "The Name property cannot have a value of @param_name for this version of SQL Server"
http://support.microsoft.com/kb/956889/en-US
New 10/20/2008 8:32:00 PM GMT

FIX: The values of the datetime column are not same for the rows that are copied when you copy data to a table by using the GETDATE() function in Microsoft SQL Server 2005
http://support.microsoft.com/kb/958547/en-US
New 10/20/2008 8:18:00 PM GMT

FIX: The size of the SQL Server 2005 error log file grows very quickly when query notifications are created and destroyed in a high ratio
http://support.microsoft.com/kb/958006/en-US
New 10/20/2008 8:18:00 PM GMT

FIX: A query that performs multiple Clustered Index Seek operations or RID Lookup operations fails with an assertion in SQL Server 2005
http://support.microsoft.com/kb/958548/en-US
New 10/20/2008 8:18:00 PM GMT

FIX: Error message when you parse a query after you run the SET XACT_ABORT ON statement in SQL Server 2005: ".Net SqlClient Data Provider: A severe error occurred on the current command"
http://support.microsoft.com/kb/959028/en-US
New 10/20/2008 8:22:00 PM GMT

FIX: Data results are inconsistent when you run a search query that uses the NEAR operator against an XML type data that contains the xml:lang attribute
http://support.microsoft.com/kb/956574/en-US
New 10/20/2008 8:22:00 PM GMT

FIX: Error message when you try to expand the Catalogs node for a linked server that links to a Teradata Database in SQL Server 2005: "Cannot obtain the schema rowset DBSCHEMA_CATALOGS for OLE DB provider SQL Server for linked server (null)"
http://support.microsoft.com/kb/959031/en-US
New 10/20/2008 8:32:00 PM GMT

Posted: Tuesday, October 21, 2008 9:40 AM by SQL Master

Comments

Other SQL Server Blogs around the Web said:

Source: Knowledge Base Product: Microsoft SQL Server 2005 Enterprise Edition Notification Contents: New

# October 21, 2008 9:41 AM
Anonymous comments are disabled