SQL Server 2005 articles, fixes and updates - letter Y

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

• 954835 You cannot install SQL Server 2005 on a server when the number of processors of the server is not a power of 2 Q954835 KB954835 July 8, 2008
• 954784 You obtain no result when you use an aggregate in a filter in Report Builder of SQL Server 2005 Reporting Services Q954784 KB954784 June 30, 2008
• 953201 You receive a "Creating the partitioned snapshot" message when you create a pull subscription that is configured to receive the precomputed partition of a merge publication in SQL Server 2005 Q953201 KB953201 June 26, 2008
• 954467 You do not receive an error message when you run the DBCC CHECKDB statement against a database in SQL Server, but an access violation occurs when you run a query on a table in the database Q954467 KB954467 June 25, 2008
• 917828 You may experience a decrease in query performance after you perform certain database maintenance operations or regular transaction operations in SQL Server 2005 Q917828 KB917828 April 28, 2008
• 912434 You cannot open the SQL Server Mobile Setup Help file in the SQL Server Mobile Server Tools installation wizard Q912434 KB912434 March 27, 2008
• 912432 You receive a compiler error message when you call the Dispose(BooleanParameter) method of the SqlCeDataReader object in a SQL Server 2005 Compact Edition project or in a SQL Server 2005 Mobile Edition project Q912432 KB912432 March 27, 2008
• 948907 You receive error messages after you uninstall SQL Native Client from a server that is running SQL Server 2005 Q948907 KB948907 February 28, 2008
• 947988 You cannot install SQL Server 2005 Service Pack 1 on a SQL Server 2005 failover cluster if the failover cluster is behind a firewall Q947988 KB947988 February 13, 2008
• 947509 You may obtain an incorrect result when you run an MDX query against an instance of SQL Server 2005 Analysis Services if the WHERE clause contains a set Q947509 KB947509 February 13, 2008
• 947989 You cannot install SQL Server 2005 Service Pack 2 when the database file of the Resource database is not in the same folder as the log file of the Resource database Q947989 KB947989 February 4, 2008
• 947512 You cannot connect to SQL Server 2000 Analysis Services on a server that is running a 64-bit instance of SQL Server 2005 and a 64-bit instance of SQL Server 2005 Analysis Services Q947512 KB947512 January 30, 2008
• 943525 You cannot start the SQL Server Agent service of a failover cluster of SQL Server 2005 if the build of SQL Server is 3179 or a later build Q943525 KB943525 January 23, 2008
• 918040 You may receive an error message when you try to run an existing CLR object or create an assembly that has the external_access or unsafe permission set on a database that is attached or restored from a different server Q918040 KB918040 January 11, 2008
• 946089 You encounter a problem with a subscription that uses the file share delivery extension in SQL Server 2005 Reporting Services or in SQL Server 2008 Reporting Services after you upgrade Windows Server 2003 to Windows Server 2008 Q946089 KB946089 December 27, 2007
• 945374 You cannot compile a SQL Server Compact-based OLE DB application for Windows Mobile 5.0, and the Transact.h file cannot be found Q945374 KB945374 December 13, 2007
• 938608 You receive an error message after you install SQL Server 2005 Service Pack 2 when you try to edit a Script component that is inside an SSIS package and the SSIS package was created in an earlier version of SQL Server 2005 Q938608 KB938608 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
• 935563 You receive syntax error messages when you use transactional replication in SQL Server 2005 Q935563 KB935563 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
• 931846 You may be unable to execute SQL Server 2005 Integration Services packages that contain script tasks or script components Q931846 KB931846 November 20, 2007
• 929152 You cannot connect to a local instance of SQL Server on a Windows XP-based computer or on a Windows 2000-based computer when you use "localhost" in the pipe name Q929152 KB929152 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
• 928317 You must perform a full database backup before you back up the transaction log for a database in SQL Server 2005 and in SQL Server 2000 Q928317 KB928317 November 20, 2007
• 927797 You cannot specify a USB-based tape drive as a backup device in SQL Server 2005 and in SQL Server 2000 Q927797 KB927797 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
• 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
• 922121 You may experience decreased performance in some features of SQL Server 2005 when you use EFS to encrypt database files Q922121 KB922121 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
• 917135 You receive an access violation error message when you use the Microsoft Application Verifier to monitor the Sqlservr.exe program for SQL Server 2005 Q917135 KB917135 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
• 915850 You may experience a 45-second delay when you run a full-text query in an instance of SQL Server 2005 that is running on a server without Internet access Q915850 KB915850 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
• 911003 You may receive an error message when you try to export a table by using the SQL Server Import and Export Wizard Q911003 KB911003 November 20, 2007
• 906954 You may receive an error message when you try to run distributed queries from a 64-bit SQL Server 2005 client to a linked 32-bit SQL Server 2000 server or to a linked SQL Server 7.0 server Q906954 KB906954 November 20, 2007
• 906892 You may experience slow performance when you run 32-bit SQL Server tools on 64-bit operating systems Q906892 KB906892 November 20, 2007
• 906549 You may receive a "Permission denied" error message when an application role-based application tries to select records from any one of the system tables in a SQL Server 2005 master database Q906549 KB906549 November 20, 2007
• 944527 You obtain no result set when you run an MDX query against an instance of SQL Server 2005 Analysis Services Q944527 KB944527 November 19, 2007
• 910851 You receive error messages when you try to set up a clustered instance of SQL Server 2005 Q910851 KB910851 November 10, 2007
• 930410 You may unexpectedly receive a NULL value when you run a Multidimensional Expressions (MDX) query in SQL Server 2005 Analysis Services Q930410 KB930410 November 4, 2007
• 913854 You receive an error message when you try to switch to the Neural Network mining model in SQL Server 2005 Analysis Services Q913854 KB913854 November 4, 2007
• 303411 You receive a "Warning SuperSocket Info" warning information when a SQL Server service account is a domain user Q303411 KB303411 November 2, 2007
• 943635 You cannot rebuild system databases if you run the Setup command from a location that is not the original installation location of SQL Server 2005 Q943635 KB943635 October 31, 2007
• 929907 You may be unable to perform most database operations after you log on to an instance of SQL Server 2005 Express Edition Service Pack 1 on a Windows Vista-based computer Q929907 KB929907 September 24, 2007
• 909678 You may receive the "System.OutOfMemoryException" error message when you use SQL Server Reporting Services Q909678 KB909678 May 13, 2007
• 934652 You cannot install SQL Server 2005 Service Pack 2 on a computer that is running SQL Server 2005 Reporting Services after you install the .NET Framework 2.0 Q934652 KB934652 April 9, 2007
• 932897 You cannot find SQL Server cluster resources in Failover Cluster Manager after you install a SQL Server 2005 failover cluster on a computer that is running Windows Server 2008 Q932897 KB932897 March 26, 2007
• 839405 You may receive an access violation exception when you try to use SQL Mail on a multiprocessor computer Q839405 KB839405 March 19, 2007
• 920201 You receive a warning message on the System Configuration Check page of the SQL Server 2005 Setup program on a computer that is running Windows Vista or a Server Core installation of Windows Server 2008 Q920201 KB920201 March 14, 2007
• 889615 You may receive a "Not associated with a trusted SQL Server connection" error message when you try to connect to SQL Server 2000 or SQL Server 2005 Q889615 KB889615 March 13, 2007
• 926629 You cannot connect to an instance of SQL Server 2005 Integration Services by using SQL Server Management Studio after you install an SSIS hotfix on a computer that has a 64-bit processor Q926629 KB926629 March 6, 2007
• 918695 You may experience a failure when you install SQL Server 2005 Service Pack 1 on an instance of SQL Server 2005 Q918695 KB918695 February 26, 2007
• 264474 You cannot restore system database backups to a different build of SQL Server Q264474 KB264474 February 22, 2007
• 264154 You must start an instance of SQL Server in single-user mode when you use DBCC CHECKDB/CHECKTABLE with REPAIR options Q264154 KB264154 February 22, 2007
• 259561 You receive a "Cannot open user default database <ID>. Using master database instead." error message when you connect to a SQL Server database Q259561 KB259561 February 22, 2007
• 239530 You must precede all Unicode strings with a prefix N when you deal with Unicode string constants in SQL Server Q239530 KB239530 February 22, 2007
• 235880 You receive an "Error 605" error message when you run a query with the optimizer hint NOLOCK or you set the transaction isolation level to READ UNCOMMITTED in SQL Server Q235880 KB235880 February 22, 2007
• 234748 You cannot correctly translate character data from a client to a server by using the SQL Server ODBC driver if the client code page differs from the server code page Q234748 KB234748 February 22, 2007
• 931292 You may experience decreased performance when you run queries against a cube that contains linked dimensions in SQL Server 2005 Analysis Services Q931292 KB931292 February 2, 2007
• 907739 You cannot modify a SQL Server Agent job for an instance of SQL Server 2000 in SQL Server Management Studio when you connect to the instance by using an account that is not a member of the SQL Server sysadmin fixed server role Q907739 KB907739 January 31, 2007
• 839569 You may not be able to connect to an instance of SQL Server by using an anonymous login Q839569 KB839569 January 25, 2007
• 919131 You may experience problems when you try to run a SQL Server 2000 DTS package after you upgrade all the instances of SQL Server 2000 to SQL Server 2005 Q919131 KB919131 January 15, 2007
• 923317 You obtain incorrect results when you run a full-text search query that uses a thesaurus file in SQL Server 2005 Q923317 KB923317 September 22, 2006
• 914158 You receive an error message when you try to upgrade an expired installation of SQL Server 2005 Evaluation Edition to a retail version of SQL Server 2005 Q914158 KB914158 September 22, 2006
• 913817 You receive an error message when you use Business Intelligence Development Studio to build a SQL Server 2005 Integration Services package Q913817 KB913817 July 14, 2006
• 908038 You may receive an error message when you try to add a user control to a Windows Forms-based application if the user control contains a data-binding object that uses an attached local database file in Visual Studio 2005 Q908038 KB908038 June 12, 2006
• 904800 You receive an "Error loading" error message when you try to run an SQL Server 2005 Integration Services package in SQL Server 2005 Q904800 KB904800 May 10, 2006
• 918038 You receive an error message when you try to load an SSIS package that contains a DateTime type variable in SQL Server 2005 Q918038 KB918038 April 28, 2006
• 918325 You cannot install SQL Server 2005 Service Pack 1 if sufficient disk space is unavailable Q918325 KB918325 April 25, 2006
• 915854 You receive an error message when you try to uninstall the second named instance of SQL Server 2005 Q915854 KB915854 April 18, 2006
• 914779 You may receive error messages when you use the Configure Distribution Wizard in SQL Server 2005 Q914779 KB914779 April 18, 2006
• 914638 You receive a NULL value when you use XQuery to retrieve the value of an XML element in SQL Server 2005 Q914638 KB914638 April 6, 2006
• 888228 You receive a "SQL Server does not exist or access denied" error message when you try to connect to a SQL Server named instance in a cluster by using TCP/IP sockets Q888228 KB888228 April 6, 2006
• 912136 You may experience problems after you run the Business Intelligence Wizard to add time calculations in SQL Server 2005 Analysis Services Q912136 KB912136 April 5, 2006
• 915180 You can no longer enlist the target server into the master server after you change the service account for the SQL Server Agent service Q915180 KB915180 April 4, 2006
• 915848 You obtain inconsistent version information after you install SQL Server 2005 Service Pack 1 Q915848 KB915848 April 1, 2006
• 298147 You receive an "Invalid Class String" error when SQL Server connects to a Cluster Server through the Cluster Administrator Q298147 KB298147 March 18, 2006
• 907267 You may not be able to access Reporting Services after you create an application pool that runs under the LocalSystem account Q907267 KB907267 March 11, 2006
• 904796 You cannot run or schedule various packages that require SQL Server 2000 Meta Data Services files after you upgrade to SQL Server 2005 Q904796 KB904796 March 11, 2006
• 900487 You cannot connect to a default instance of SQL Server 2005 through a firewall by using the SQL Server networking interface (SNI) Q900487 KB900487 March 11, 2006
• 905618 You may receive a connection error message when you try to connect to an instance of SQL Server 2000 or of SQL Server 7.0 that was installed after you installed SQL Server 2005 Q905618 KB905618 March 10, 2006
• 913423 You cannot run a statement or a module that includes the EXECUTE AS clause after you restore a database in SQL Server 2005 Q913423 KB913423 February 14, 2006
• 217395 You receive an "Error 18482" error message when you try to make a remote procedure call (RPC) from one server to another in SQL Server Q217395 KB217395 December 15, 2005
• 839269 You may not be able to connect to an instance of SQL Server that is configured to use the Named Pipes server network library on a computer that is running Windows XP Service Pack 2 Q839269 KB839269 December 9, 2005
• 818182 You receive an "Unspecified error" error message when SQL Server accesses a linked server that uses Microsoft OLE DB provider for Jet 4.0 Q818182 KB818182 December 9, 2005
• 207187 You cannot back up databases to a network drive if your account have not sufficient permissions to access the network drive Q207187 KB207187 December 2, 2005
• 841394 You may not be able to connect to an instance of SQL Server that is configured to use the TCP/IP server network library on a computer that is running Windows XP Service Pack 2 Q841394 KB841394 December 1, 2005
• 302223 You receive an "Error 14114: (NULL) is not configured as a distributor" error message when you try to set up a SQL Server server as a distributor for replication Q302223 KB302223 November 30, 2005
• 908711 You receive an “Explicit value must be specified for identity column” error message when you use the replication feature to run an INSERT statement on a table in SQL Server 2005 Q908711 KB908711 November 19, 2005
• 908454 You cannot upgrade a named instance of SQL Server 2000 to SQL Server 2005 on a computer that is running the Itanium-based operating system Q908454 KB908454 November 1, 2005