SQL Server 2005 articles, fixes and updates - November 2007

This list contains all of the known Microsoft Knowledge Base articles, howtos, fixes, hotfixes, webcasts and updates of Microsoft SQL Server 2005 that have been released in November 2007. The list is daily updated.

• 945465 FIX: Error message when you synchronize the subscription of a transactional replication from SQL Server 2000 to SQL Server 2005: "Property AnsiNullsStatus is not available for UserDefinedFunction '<Function_Name>'" Q945465 KB945465 November 30, 2007
• 944678 FIX: SSIS stops responding when you run an SSIS package that uses a Flat File source in a Data Flow task after you install cumulative update package 2 for SQL Server 2005 Service Pack 2 Q944678 KB944678 November 30, 2007
• 940232 Error message when you use SQL Server Management Studio to connect to SQL Server 2005 Integration Services from a client computer: "Connect to SSIS Service on machine '<SSISServer>' failed Access is denied" Q940232 KB940232 November 27, 2007
• 914596 The incorrect type for the union element is returned when you run XQuery against XML data that contains the union element in SQL Server 2005 Q914596 KB914596 November 22, 2007
• 912912 Component releases and component versions for SQL Server 2005 Mobile Edition and for SQL Server 2005 Compact Edition Q912912 KB912912 November 22, 2007
• 944517 FIX: Error message when you create a WMI event alert by using the sp_add_alert stored procedure in SQL Server 2005: "The @wmi_query could not be executed in the @wmi_namespace provided" Q944517 KB944517 November 20, 2007
• 943284 FIX: Only the import operation of the first batch is minimally logged when you import the data in multiple batches in SQL Server 2005 Q943284 KB943284 November 20, 2007
• 943060 FIX: A query that has many outer joins takes a long time to compile in SQL Server 2005 Q943060 KB943060 November 20, 2007
• 942714 FIX: Error message when you use the "bcp_sendrow" function in a SQL Server 2005-based application that uses a SQL Native Client provider: "For BCP, all variable-length data must have either a length-prefix or a terminator specified" Q942714 KB942714 November 20, 2007
• 942668 FIX: High CPU usage occurs periodically on a subscriber when you synchronize a merge publication in SQL Server 2005 Q942668 KB942668 November 20, 2007
• 942656 FIX: Error message when you set up a snapshot publication on a database in SQL Server 2005: "Error 137, Must declare the scalar variable <VariableName>" Q942656 KB942656 November 20, 2007
• 942087 FIX: An access violation may occur intermittently in the DTSPipeline.dll file when you run an Integration Services package that contains a Data Flow task in SQL Server 2005 Q942087 KB942087 November 20, 2007
• 941689 FIX: You cannot connect to an instance of SQL Server 2005, and an error message is logged in the SQL Server error log Q941689 KB941689 November 20, 2007
• 941539 FIX: SQL Server 2005 may send error information for the same problem many times when a fatal error occurs Q941539 KB941539 November 20, 2007
• 940941 FIX: Some events are not logged correctly when you enable SQL Server event forwarding on a SQL Server Agent of SQL Server 2000 to forward events to SQL Server 2005 Q940941 KB940941 November 20, 2007
• 940933 FIX: Some changes from subscribers who use SQL Server 2005 Compact Edition or Web synchronization are not uploaded to the publisher when you use the republishing model in a merge publication in Microsoft SQL Server 2005 Q940933 KB940933 November 20, 2007
• 938825 FIX: A foreign key constraint that you drop on a table at the publisher is not dropped on the table at the subscriber in a SQL Server 2005 merge replication Q938825 KB938825 November 20, 2007
• 938050 FIX: Error message when you try to synchronize a SQL Server 2005 Compact Edition subscription again: "The common generation watermark is invalid at this replica since it does not exist" Q938050 KB938050 November 20, 2007
• 937950 Explanation of error 3928 in SQL Server 2005 and in SQL Server 2000 Q937950 KB937950 November 20, 2007
• 937684 You may be prompted to restart the computer after you install the 64-bit version of SQL Server 2005 Service Pack 2 even if the Setup program does not report that some components are locked Q937684 KB937684 November 20, 2007
• 936894 FIX: Indexes that are rebuilt after you run a maintenance plan that contains the Rebuild Index task have the same Ignore Duplicate Key setting as the Ignore Duplicate Key setting of the Rebuild Index task Q936894 KB936894 November 20, 2007
• 936891 A memory leak may occur when the Merge Replication Agent retries a connection in SQL Server 2005 Q936891 KB936891 November 20, 2007
• 936492 How to use Windows Management Instrumentation in SQL Server 2005 to change the account of the SQL Server service or the password of the SQL Server service programmatically Q936492 KB936492 November 20, 2007
• 935997 A user who is not a member of a required role can still connect to a SQL Server 2005 database after you set the user access option for the database to RESTRICTED_USER Q935997 KB935997 November 20, 2007
• 935297 SQL Server Setup fails unexpectedly when you try to install SQL Server 2005 Service Pack 2 Q935297 KB935297 November 20, 2007
• 934812 FIX: You cannot bring the SQL Server group online in a cluster environment after you rename the virtual server name of the default instance of SQL Server 2005 Q934812 KB934812 November 20, 2007
• 933838 Additional updates and additional inserts may be performed during synchronization when the merge publication contains join filters in SQL Server 2005 Q933838 KB933838 November 20, 2007
• 933248 All conditional and branching statements are ignored when you try to execute a batch of Transact-SQL statements that have the FTMONLY option set to ON in SQL Server 2005 Q933248 KB933248 November 20, 2007
• 932557 FIX: A script task or a script component may not run correctly when you run an SSIS package in SQL Server 2005 build 1399 Q932557 KB932557 November 20, 2007
• 932288 Error message when you use a number that is more than 28 in the common language runtime for SQL Server 2005: "System.OverflowException: Conversion overflows" Q932288 KB932288 November 20, 2007
• 931976 You may be prompted to enter the old password when you try to reset the password of a SQL Server login by using a SQL Server login that is a member of the securityadmin fixed server role in SQL Server 2005 Q931976 KB931976 November 20, 2007
• 931640 Error message when you try to upgrade a SQL Server 2000 database to a SQL Server 2005 database: "Database '<DatabaseName>' cannot be upgraded because it is read-only or has read-only files" Q931640 KB931640 November 20, 2007
• 931291 BUG: You may receive incorrect results when you run a query against the target partitioned table after you insert data from a partitioned table to another partitioned table in SQL Server 2005 Q931291 KB931291 November 20, 2007
• 931175 BUG: Error message when you use Database Mail in SQL Server 2005: "Error 14667, Severity 16, State 1" Q931175 KB931175 November 20, 2007
• 930048 A query notification dependency between an application and a SQL Server 2005 database does not detect the changes in the database after a database mirroring failover Q930048 KB930048 November 20, 2007
• 929666 The value of the Collation registry entry is changed to the SQL_Latin1_General_CP1_CI_AS value after you install SQL Server 2005 Service Pack 2 Community Technology Preview or SQL Server 2005 Service Pack 1 Q929666 KB929666 November 20, 2007
• 929150 Error message when you install or uninstall Microsoft SQL Server 2005 or SQL Server 2005 with Service Pack 2 or later versions on a Windows Vista-based or Windows Server 2008-based computer Q929150 KB929150 November 20, 2007
• 928956 Error message when you try to upgrade from SQL Server 2000 to SQL Server 2005: "Cannot insert duplicate key row in object 'dbo.syscategories' with unique index 'clust'" Q928956 KB928956 November 20, 2007
• 928907 How to improve concurrency in a SQL Server 2005 application by using built-in functions Q928907 KB928907 November 20, 2007
• 928320 You cannot use existing tables on a heterogeneous subscriber database when you configure a push subscription to a heterogeneous subscriber in SQL Server 2005 Q928320 KB928320 November 20, 2007
• 928319 FIX: Error message when you run a .NET Framework 1.0 or .NET Framework 1.1 application on a computer that has SQL Server 2005 installed Q928319 KB928319 November 20, 2007
• 926900 The SQL Trace entries may be incorrect when you trace an instance of SQL Server 2005 that is configured to use database mirroring Q926900 KB926900 November 20, 2007
• 926899 When you use SQL Profiler to create a trace in SQL Server 2005, the Existing Connection event appears after other events that are logged for the same session ID Q926899 KB926899 November 20, 2007
• 926626 The list of product codes that depend on SQL Native Client may be lost after you upgrade to SQL Server 2005 Service Pack 1 on a computer that is running Windows Vista Release Candidate 1 Q926626 KB926626 November 20, 2007
• 926613 FIX: You may receive inconsistent results when you query a table that is published in a transactional replication in SQL Server 2005 Q926613 KB926613 November 20, 2007
• 926106 FIX: You receive an error message when you use the Print Preview option on a large report in SQL Server 2005 Reporting Services Q926106 KB926106 November 20, 2007
• 922767 Subscription distribution may fail after you synchronize a subscription in SQL Server 2005 Q922767 KB922767 November 20, 2007
• 922658 SQL Server 2000 or SQL Server 2005 may temporarily stop responding on a Windows Server 2003 Service Pack 1-based computer Q922658 KB922658 November 20, 2007
• 922647 You cannot debug assemblies that are referenced in the Script task code by using Visual Studio for Applications in SSIS Q922647 KB922647 November 20, 2007
• 922549 The SQL Server login name is not updated in the sys.syslogins catalog compatibility view after you change the computer name Q922549 KB922549 November 20, 2007
• 922548 Error message when you run a Visual C++ application that connects to SQL Server 2005 by using ODBC: "[Microsoft][ODBC SQL Server Driver][SQL Server] Could not find stored procedure 'sp_fallback_MS_sel_fb_svr'" Q922548 KB922548 November 20, 2007
• 922546 You receive a "No description found" error message when you create an SSIS package or a SQL Server maintenance plan in SQL Server 2005 Q922546 KB922546 November 20, 2007
• 922214 Error message when you start SQL Server Management Studio in SQL Server 2005: "Unable to cast object of type 'Microsoft.SqlServer.Management.UI.ConnectionDlg.Personalization' to type 'Microsoft.SqlServer.Management.UI.ConnectionDlg.Personalization'" Q922214 KB922214 November 20, 2007
• 922209 The SQL Server 2005 Setup program does not remove all IP address cluster resources when you uninstall SQL Server 2005 Q922209 KB922209 November 20, 2007
• 922123 BUG: The value of the UserModeTime element is displayed as the value of the KernelModeTime element in the XML output of the record column in SQL Server 2005 Q922123 KB922123 November 20, 2007
• 922118 BUG: The User connections counter of the SQLServer:General Statistics performance object is not decremented when a Service Broker activation task is ended in SQL Server 2005 Q922118 KB922118 November 20, 2007
• 921929 BUG: When you click "Build Query" in the "Execute SQL Task Properties" dialog box of the SQL Server 2000 DTS package designer, SQL Server 2005 Management Studio unexpectedly closes Q921929 KB921929 November 20, 2007
• 921902 You receive a "Sample database 'Adventureworks' already exists in SQL instance specified" error message when you use Add or Remove Programs to install the AdventureworksDW Sample Data Warehouse sample database in SQL Server 2005 Q921902 KB921902 November 20, 2007
• 920272 Error message when you call the Pull method of an RDA object: "duplicate value cannot be inserted into a unique index. [Table name = __sysRDASubscriptions, Constraint name = c_LocalTableName]" Q920272 KB920272 November 20, 2007
• 919398 Error message when you try to install SQL Server 2005: "Could not find a package to install on the installation media" Q919398 KB919398 November 20, 2007
• 919395 BUG: The SQL Server service shuts down and an assertion error is logged in the CXteIndexSort::CXteIndexSort function in the SQL Server error log file when you start the SQL Server service in SQL Server 2005 Q919395 KB919395 November 20, 2007
• 919394 Error message when you install SQL Server 2005: "Beta components detected" Q919394 KB919394 November 20, 2007
• 917420 BUG: You receive an error message when you use the Package Migration Wizard to migrate a DTS package Q917420 KB917420 November 20, 2007
• 917419 BUG: The datetime data type and the smalldatetime data type are always evaluated by using the us_english language environment when you use the CREATE PARTITION FUNCTION statement in SQL Server 2005 Q917419 KB917419 November 20, 2007
• 917410 BUG: The cluster setup may fail when you try to upgrade SQL Server 2005 to SQL Server 2005 Service Pack 1 Q917410 KB917410 November 20, 2007
• 916782 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 Q916782 KB916782 November 20, 2007
• 915385 A snapshot-based database backup restore process may fail, and you may receive an error message in SQL Server 2005 Q915385 KB915385 November 20, 2007
• 912430 You cannot replicate data from SQL Server 2005 to SQL Server Mobile Edition by using the 64-bit version of IIS Q912430 KB912430 November 20, 2007
• 912428 Error message when you try to replicate a table from SQL Server 2005 to SQL Server 2005 Mobile Edition: "HRESULT 0x80004005 (0)" Q912428 KB912428 November 20, 2007
• 908500 BUG: SQL Server 2005 Analysis Services performance monitor counters do not report values Q908500 KB908500 November 20, 2007
• 907888 Error message when you install the SQL Server 2000 DTS Designer components on a computer that is running Windows 2000: "dtsui.dll failed to register HRESULT -2147024770" Q907888 KB907888 November 20, 2007
• 907261 BUG: Installation may fail, and you may receive an error message when you try to install SQL Server 2005 64-bit on a 64-bit server Q907261 KB907261 November 20, 2007
• 907256 BUG: The full-text search service incorrectly installs under the LocalSystem account on an SQL Server 2005 CTP-based computer Q907256 KB907256 November 20, 2007
• 906773 Getting ready for SQL Server 2005 Q906773 KB906773 November 20, 2007
• 906649 Unsupported tuning options for some editions of SQL Server 2000 and of SQL Server 2005 Q906649 KB906649 November 20, 2007
• 906161 The 32-bit version of the SQL Server 2005 Analysis Services Instance Rename tool (ASInstanceRename.exe) does not work correctly on a 64-bit computer Q906161 KB906161 November 20, 2007
• 905693 Additions to the Readme file for the SQL Server 2005 Upgrade Advisor tool Q905693 KB905693 November 20, 2007
• 905617 SQL Server 2005 full-text search includes improved and updated noise word files Q905617 KB905617 November 20, 2007
• 894711 Description of SOAP interoperability issues that may occur when you use the Systinet Web Application Services Platform (WASP) 4.6 development toolset together with native HTTP SOAP support in SQL Server 2005 Q894711 KB894711 November 20, 2007
• 894710 List of SOAP interoperability issues that may occur when you work with the Generic Language Universal Environment (Glue) Technology 5.0.1 in SQL Server 2005 Q894710 KB894710 November 20, 2007
• 894709 List of SOAP interoperability issues that you may experience when you use the JBuilder client to develop and maintain SOAP client applications in SQL Server 2005 Q894709 KB894709 November 20, 2007
• 827968 How to estimate the size of a SQL Server CE or SQL Server 2005 Mobile Edition database Q827968 KB827968 November 20, 2007
• 329526 File allocation extension in SQL Server 2000 (64-bit) and SQL Server 2005 Q329526 KB329526 November 20, 2007
• 936262 FIX: When you run an MDX query for the second time, the query does not run faster than the first time that you ran the query in SQL Server 2005 Analysis Services Q936262 KB936262 November 16, 2007
• 942904 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'" Q942904 KB942904 November 14, 2007
• 824462 SqlCeCommand objects are not automatically disposed if you use a SqlCeDataAdapter object Q824462 KB824462 November 14, 2007
• 942662 FIX: Message when you click the Back button in Internet Explorer 7 to return to a SQL Server 2005 Reporting Services report that contains one or more DateTime parameters: "Report is being generated" Q942662 KB942662 November 13, 2007
• 935831 FIX: The operation takes a long time to be completed when you process a partition that has proactive caching enabled in SQL Server 2005 Analysis Services Q935831 KB935831 November 8, 2007
• 936487 FIX: Managed applications that use SQL Server 2005 Compact Edition 3.1 may stop unexpectedly on Windows Mobile 5.0 ARMV4i-compatible devices if the location of the SQL Server Compact Edition DLLs changes Q936487 KB936487 November 4, 2007
• 932106 FIX: Error message when you run a DMX query that uses a linked server to query data from a Microsoft SQL Server 2005 Analysis Services server: "The following system error occurred: Logon failure: unknown user name or bad password" Q932106 KB932106 November 4, 2007
• 925843 FIX: Error message when you use the SQL Server Native Client provider to run queries between two linked servers in SQL Server 2005 Service Pack 1: "Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'" Q925843 KB925843 November 4, 2007
• 928324 Error message when you use the dtsrun command prompt utility (Dtsrun.exe) to run a DTS package in SQL Server 2005 Integration Services: "This application has failed to start because SQLResourceLoader.dll was not found" Q928324 KB928324 November 2, 2007
• 911851 Error message when you run the sp_helpfile stored procedure in SQL Server 2005 or in SQL Server 2000: "Arithmetic overflow error converting expression to data type int" Q911851 KB911851 November 2, 2007
• 910401 How to use Microsoft System Center Data Protection Manager 2006 to help protect a SQL Server database Q910401 KB910401 November 2, 2007
• 943285 After you install Cumulative Update Package 4 for SQL Server 2005 SP2, time stamp information that is related to the RSPrintClient ActiveX control is logged in the report server log file Q943285 KB943285 November 1, 2007