January 2008 - Technical Rollup Mail - SQL
News
Customers Choose SQL Server to Run Their SAP® Solutions
Microsoft highlighted the benefits customers have realized by migrating their data platform to Microsoft SQL Server 2005 to run their SAP® applications: enterprise-calibre reliability coupled with significant cost savings. Customers have experienced over 35 percent cost-efficiencies by selecting SQL Server 2005 to run their SAP solutions. These customers represent a growing number of organizations that have committed to SQL Server to support their most essential systems at a low total cost of ownership.
https://www.microsoft.com/Presspass/press/2007/dec07/12-05SAPSQLSystemsPR.mspx
Microsoft Is Positioned in Leaders Quadrant of Latest Magic Quadrant for Data Warehousing – SQL Server Closes the Distance
Microsoft® SQL Server™ 2005 has been positioned in the Leaders quadrant of the Gartner Magic Quadrant for Data Warehouse Database Management Systems, 2007. Customers rely on SQL Server 2005’s comprehensive, integrated data management and analysis software to manage mission-critical information and run today’s complex business applications.
https://www.microsoft.com/presspass/press/2007/oct07/10-12DWMQPR.mspx
https://redmondmag.com/features/article.asp?editorialsid=2382
Evaluate Microsoft SQL Server 2008 today
SQL Server 2008, the next release of Microsoft SQL Server, will provide a comprehensive data platform that is more secure, reliable, manageable and scalable for your mission critical applications, while enabling developers to create new applications that can store and consume any type of data on any device, and enabling all your users to make informed decisions with relevant insights. And when you download the latest software, you're automatically registered to access valuable resources assembled in one convenient location.
https://msdn2.microsoft.com/en-us/sqlserver/bb851668.aspx
https://connect.microsoft.com/SQLServer/content/content.aspx?ContentID=5395
RML Utilities for Microsoft SQL Server Released
The Microsoft SQL Server support team uses several internally-written utilities to make it easier to work on a typical customer support case. These utilities may also be useful to database developers and system administrators who work with Microsoft SQL Server 2000 and Microsoft SQL Server 2005. The utilities are collectively called the RML Utilities for SQL Server.
https://blogs.msdn.com/psssql/archive/2007/12/18/rml-utilities-for-microsoft-sql-server-released.aspx
Documents
Business Intelligence in SQL Server 2008
Microsoft SQL Server 2008 makes business intelligence (BI) available to everyone through deep integration with Microsoft Office, providing the right tool, to the right user, at the right price. The result is that employees at all levels of an organization can see and help to influence the performance of the business by working with tools that are both easy to use and powerful. Integration with the 2007 Microsoft Office System enables users to view business performance in a way that they understand and which feels comfortable; and the introduction of PerformancePoint Server 2007, helps customers to gain actionable insight into the entire organization so they can monitor, analyze, and plan their businesses, as well as drive alignment, accountability, and actionable insight across the entire organization.
https://www.microsoft.com/sql/techinfo/whitepapers/sql_2008_bi.mspx
An Introduction to SQL Server 2008 Integration Services
This paper discusses the challenges that face businesses that rely on data integration technologies to provide meaningful, reliable information to maintain a competitive advantage in today’s business world. It discusses how SQL Server 2008 Integration Services (SSIS) can help Information Technology departments meet data integration requirements in their companies. Real-world scenarios are included.
https://www.microsoft.com/sql/techinfo/whitepapers/SSIS2008_Intro.mspx
SQL Server 2008 Product Overview
For organizations to be successful and thrive in today’s world of data, they need a vision that addresses key data trends. The data platform vision of Microsoft helps organizations meet these data explosion needs and the next generation of data-driven applications. Microsoft will continue to invest in and evolve the following key areas to support their data platform vision: mission-critical enterprise data platform, dynamic development, relational data, and business intelligence. Read this paper to learn about the Microsoft Data Platform Vision and how SQL Server 2008 meets the needs of the next generation of data-driven applications.
https://www.microsoft.com/sql/techinfo/whitepapers/sql2008Overview.mspx
Microsoft SQL Server 2008 and Microsoft Data Platform Development
Microsoft SQL Server 2008 and the Microsoft data platform provide developers with a comprehensive programming framework in which to create data centric solutions that target mobile devices, desktops, Web servers, and enterprise servers. This data programming environment improves developer productivity by integrating data access and management into the business logic of an application. It provides a comprehensive platform for data access and management from disparate data sources and a scalable solution for data storage and applications.
https://www.microsoft.com/sql/techinfo/whitepapers/sql_2008_dp.mspx
SQL Server 2008 Performance and Scale
Microsoft® SQL Server™ 2008 incorporates the tools and technologies that are necessary to implement relational databases, reporting systems, and data warehouses of enterprise scale, and provides optimal performance and responsiveness. With SQL Server 2008, you can take advantage of the latest hardware technologies while scaling up your servers to support server consolidation. SQL Server 2008 also enables you to scale out your largest data solutions.
https://www.microsoft.com/sql/techinfo/whitepapers/sql_2008_perfandscale.mspx
Downloads
SQL Server 2000/2005 Management Pack
The SQL Server Management Pack monitors the availability and performance of SQL Server 2000 and 2005 and can issue alerts for configuration problems. Availability and performance monitoring is done using synthetic transactions. In addition, the Management Pack collects Event Log alerts and provides associated knowledge articles with additional user details, possible causes, and suggested resolutions. The Management Pack discovers Database Engines, Database Instances, and Databases and can optionally discover Database File and Database File Group objects.
https://www.microsoft.com/downloads/info.aspx?na=22&p=1&srcdisplaylang=en&srccategoryid=&srcfamilyid=&u=%2fdownloads%2fdetails.aspx%3ffamilyid%3d8c0f970e-c653-4c15-9e51-6a6cadfca363%26displaylang%3den
Office Accounting Document: Installing and Configuring Office Accounting for Use with Windows Small Business Server 2003 R2 and SQL Server 2005
Microsoft Office Accounting is a complete accounting solution that helps small businesses save time managing everyday financial tasks, get organized, and grow their business online. With its familiar Microsoft Office interface, this program is easy to learn, so you can be productive right away. Smooth integration with other Microsoft Office programs makes information sharing simple and helps boost productivity. You can install Office Accounting on a standalone computer, or on a peer-to-peer network environment for multiple users. If you centralize the database to run on Windows Small Business Server 2003 R2, multiple people can use Office Accounting at all times, they can remotely access Office Accounting, and backups are performed automatically. To properly install and configure Office Accounting on a computer running Windows Small Business Server 2003 R2 and SQL Server 2005, follow the steps in this document.
https://www.microsoft.com/downloads/info.aspx?na=22&p=2&srcdisplaylang=en&srccategoryid=&srcfamilyid=&u=%2fdownloads%2fdetails.aspx%3ffamilyid%3d1193e3f3-b626-4264-af3e-8c4f190caa69%26displaylang%3den
TechNet Security Series Seminar (13th Dec 2007) - SQL Server 2008 Overview
Presentation Materials for TechNet Security Series Seminar (13th Dec 2007)
https://www.microsoft.com/downloads/info.aspx?na=22&p=3&srcdisplaylang=en&srccategoryid=&srcfamilyid=&u=%2fdownloads%2fdetails.aspx%3ffamilyid%3dbf2b7bf4-d61b-4695-b049-b1c093d4aed6%26displaylang%3den
RML Utilities for SQL Server (x64)
Tools to help database administrators manage the performance of Microsoft SQL Server.
https://www.microsoft.com/downloads/info.aspx?na=22&p=4&srcdisplaylang=en&srccategoryid=&srcfamilyid=&u=%2fdownloads%2fdetails.aspx%3ffamilyid%3db60cdfa3-732e-4347-9c06-2d1f1f84c342%26displaylang%3den
RML Utilities for SQL Server (x86)
Tools to help database administrators manage the performance of Microsoft SQL Server.
https://www.microsoft.com/downloads/info.aspx?na=22&p=5&srcdisplaylang=en&srccategoryid=&srcfamilyid=&u=%2fdownloads%2fdetails.aspx%3ffamilyid%3d7edfa95a-a32f-440f-a3a8-5160c8dbe926%26displaylang%3den
SQLRAP Datasheet
Used to evaluate customers’ production SQL Server implementations to ensure productive use. Includes a review, a hands-on knowledge transfer and a report that details health along with findings and recommendations.
https://www.microsoft.com/downloads/info.aspx?na=22&p=6&srcdisplaylang=en&srccategoryid=&srcfamilyid=&u=%2fdownloads%2fdetails.aspx%3ffamilyid%3d016c91a7-5b9f-4bdd-8897-70703a6e832f%26displaylang%3den
Notification Workflow Solution Accelerator
The Notification Workflow Solution Accelerator is a Microsoft SQL Server™ Notification Services-based application that can be used to extend notification functionalities of Microsoft Operations Manager (MOM) 2005. It allows a user to subscribe to and be notified when alerts associated with specific applications or Microsoft Windows® services are generated. Whenever an alert occurs, an alert notification is sent to the subscriber in the form of an e-mail. The notifications can be sent to the user based on schedules, schedule overrides, and extended MOM alert properties based on user selection when subscribing. The alert properties available for selection include computer name, alert source, alert severity, Management Pack name, computer group name, device, and alert description. The latest release, version 2.1, allows the solution to be utilized in distributed MOM deployments. The solution accelerator includes an Installation Guide, User Guide, Test Plan, Test Case Details, and executable.
https://www.microsoft.com/downloads/info.aspx?na=22&p=7&srcdisplaylang=en&srccategoryid=&srcfamilyid=&u=%2fdownloads%2fdetails.aspx%3ffamilyid%3d8d25c80d-c978-4b23-825a-7ae7b4775b0f%26displaylang%3den
System Center Operations Manager 2007 Documentation
This download contains documentation for System Center Operations Manager 2007.
https://www.microsoft.com/downloads/info.aspx?na=22&p=8&srcdisplaylang=en&srccategoryid=&srcfamilyid=&u=%2fdownloads%2fdetails.aspx%3ffamilyid%3dd826b836-59e5-4628-939e-2b852ed79859%26displaylang%3den
SQL Server White Papers: Migration from Oracle, Sybase, or Microsoft Access to Microsoft SQL Server
Read these white papers to understand how to use SQL Server Migration Assistant (SSMA) to migrate to SQL Server 2005 from other database platforms.
https://www.microsoft.com/downloads/info.aspx?na=22&p=9&srcdisplaylang=en&srccategoryid=&srcfamilyid=&u=%2fdownloads%2fdetails.aspx%3ffamilyid%3d3f0f2a3f-dff9-49cd-8ea7-581aa7a303a4%26displaylang%3den
Sync Services for ADO.NET
Microsoft Synchronization Services for ADO.NET provides the ability to synchronize data from disparate sources over two-tier, N-tier, and service-based architectures. Rather than simply replicating a database and its schema, the Synchronization Services application programming interface (API) provides a set of components to synchronize data between data services and a local store. Applications are increasingly used on mobile clients, such as laptops and devices, that do not have a consistent or reliable network connection to a central server. It is crucial for these applications to work against a local copy of data on the client. Equally important is the need to synchronize the local copy of the data with a central server when a network connection is available. The Synchronization Services API, which is modeled after the ADO.NET data access APIs, gives you an intuitive way to synchronize data. It makes building applications for occasionally connected environments a logical extension of building applications where you can count on a consistent network connection.
https://www.microsoft.com/downloads/info.aspx?na=22&p=10&srcdisplaylang=en&srccategoryid=&srcfamilyid=&u=%2fdownloads%2fdetails.aspx%3ffamilyid%3d147c41a9-69f0-496e-b095-dbc5cffd6285%26displaylang%3den
Line of Business Client Application Compatibility Testing at Microsoft
Provides an overview of the Microsoft IT Application Compatibility Testing Program, which enables Microsoft to smoothly upgrade desktop software and operating systems in its business units and to provide product development teams with feedback from real-world application compatibility testing.
https://www.microsoft.com/downloads/info.aspx?na=22&p=11&srcdisplaylang=en&srccategoryid=&srcfamilyid=&u=%2fdownloads%2fdetails.aspx%3ffamilyid%3da24c396c-69ec-45ca-aed6-d5ec038dfd76%26displaylang%3den
Microsoft SQL Server 2008 CTP (November 2007) VHD
SQL Server 2008, the next release of Microsoft SQL Server, will provide a comprehensive data platform that is more secure, reliable, manageable and scalable for your mission critical applications, while enabling developers to create new applications that can store and consume any type of data on any device, and enabling all your users to make informed decisions with relevant insights.
https://www.microsoft.com/downloads/info.aspx?na=22&p=12&srcdisplaylang=en&srccategoryid=&srcfamilyid=&u=%2fdownloads%2fdetails.aspx%3ffamilyid%3d6a39affa-db6e-48a9-82e4-4efd6705f4a6%26displaylang%3den
Visual Basic LINQ Hands On Labs for Visual Studio 2008
These Visual Basic LINQ Hands-on Labs provide an introduction to the LINQ Project. Learn basic LINQ features, including the Standard Query Operators, and see how these features can be used against in-memory collections, connected databases, and XML documents. The labs also provide a clear picture of the relational data access support provided by the LINQ Project, referred to as LINQ to SQL. The language integrated query framework for .NET (codenamed “LINQ”) is a set of language extensions to C# and Visual Basic and a unified programming model that extends the .NET Framework to offer integrated querying for objects, databases and XML.
https://www.microsoft.com/downloads/info.aspx?na=22&p=13&srcdisplaylang=en&srccategoryid=&srcfamilyid=&u=%2fdownloads%2fdetails.aspx%3ffamilyid%3de7fa5e3a-f8b2-4f77-bbcd-b5b978402dd1%26displaylang%3den
SQL Server 2005 Books Online (September 2007)
Download an updated version of the documentation and tutorials for Microsoft SQL Server 2005. See the "Additional Information" section for an update on SQL Server Express Books Online.
https://www.microsoft.com/downloads/info.aspx?na=22&p=14&srcdisplaylang=en&srccategoryid=&srcfamilyid=&u=%2fdownloads%2fdetails.aspx%3ffamilyid%3dbe6a2c5d-00df-4220-b133-29c1e0b6585f%26displaylang%3den
Search Server 2008 Sample: Federated Search Connector Sample
This code sample shows you how to create a connector to a Microsoft SQL Server 2005 database for federated search in Microsoft Search Server 2008.
https://www.microsoft.com/downloads/info.aspx?na=22&p=15&srcdisplaylang=en&srccategoryid=&srcfamilyid=&u=%2fdownloads%2fdetails.aspx%3ffamilyid%3db59ea8c3-76e8-45df-947f-32a69c56b5cd%26displaylang%3den
SQL Server Compact 3.5 Server Tools
SQL Server Compact 3.5 is a small footprint, in-process database engine that allows developers to build robust applications for Windows Desktops and Mobile Devices. SQL Server Compact 3.5 Server Tools installs DLL's on the IIS server enabling replication of data with SQL Server 2005
https://www.microsoft.com/downloads/info.aspx?na=22&p=16&srcdisplaylang=en&srccategoryid=&srcfamilyid=&u=%2fdownloads%2fdetails.aspx%3ffamilyid%3db18327f3-96e1-415d-b037-9e0c46d49956%26displaylang%3den
Microsoft Online Services Customer Story: InSinkErator
Microsoft Online Services Customer Story: InSinkErator
https://www.microsoft.com/downloads/info.aspx?na=22&p=17&srcdisplaylang=en&srccategoryid=&srcfamilyid=&u=%2fdownloads%2fdetails.aspx%3ffamilyid%3de73d3264-c15d-46d9-bf13-a22c55a43b7a%26displaylang%3den
ReportViewer Samples for Microsoft Visual Studio 2008
This release provides developer sample applications in Microsoft Visual Basic and Microsoft Visual C# that use the ReportViewer controls for Microsoft Visual Studio 2008.
https://www.microsoft.com/downloads/info.aspx?na=22&p=18&srcdisplaylang=en&srccategoryid=&srcfamilyid=&u=%2fdownloads%2fdetails.aspx%3ffamilyid%3d8af004bd-ee06-43fa-a5b6-955689a66c84%26displaylang%3den
Events / Webcasts
SQL 2005 Webcasts and Virtual Labs
SQL Server 2005 is data management and analysis software that delivers enhanced security, availability, and scalability to mission-critical data applications—while making them easier to develop, deploy, and manage. Choose from a wide range of live and on-demand webcasts. Or take part in a virtual lab, which allows you to cut your teeth on the new platform by experimenting with its different capabilities.
SQL Server 2005 Webcasts
Momentum Webcast: Unlock the Business Intelligence Capabilities of SQL Server (Level 100) – Wednesday, January 09, 2008 11:00 AM Pacific Time (US & Canada)
In an environment where you are constantly challenged to do more with less, it is important to make sure you get as much value as possible out of your existing investments in technology infrastructure. While Microsoft SQL Server is present in most IT shops as a data base platform or application data base, the powerful business intelligence (BI) capabilities provided as part of SQL Server are frequently overlooked. Join our webcast to learn more about how to unlock the BI capabilities that are available in your existing SQL Server environment.
Momentum Webcast: Unlock the Business Intelligence Capabilities of SQL Server (Level 100)
MSDN Webcast: MSDN geekSpeak: SQL Server 2008 Programming for Application Developers (Level 300) – Wednesday, January 09, 2008 12:00 PM Pacific Time (US & Canada)
In this installment of MSDN geekSpeak, Kevin Goff answers your questions about best practices for Microsoft SQL Server 2008 (formerly code-named Katmai) as a data platform for your applications. If you have a question or comment you would like us to address during the webcast, visit the geekSpeak blog and submit it now.
MSDN Webcast: MSDN geekSpeak: SQL Server 2008 Programming for Application Developers (Level 300)
TechNet Webcast: Preparing Data for Use with SQL Server Data Mining (Level 200) – Thursday, January 10, 2008 8:00 AM Pacific Time (US & Canada)
Many users who struggle with data mining do not realize that their problems start with badly prepared data. This webcast is a very practical introduction to some of the important topics that you should understand when preparing your data for a data mining project with Microsoft SQL Server . Issues include finding the right data, handling missing values, identifying and fixing overloaded fields, and deriving useful variables.
TechNet Webcast: Preparing Data for Use with SQL Server Data Mining (Level 200)
Upgrade SQL Now - Live Meeting Series – Tuesday, January 15, 2008 12:00 PM Eastern Time (US & Canada)
These sessions will cover the issues around upgrading SQL including features and tips. Feel free to register for all any number of the offered. Session will run from December 2007 through May 2008. SQL Server Integration Services has been called the next version of DTS. It really isn't as this feature has been totally rewritten for SQL Server 2005. Join us to discuss the performance benefits as well as some tricks and tips when dealing with SSIS.
Upgrade SQL Now - Live Meeting Series
MSDN Webcast: Introducing SQL Server Compact 3.5 (Level 200) – Wednesday, January 16, 2008 9:00 AM Pacific Time (US & Canada)
With Microsoft SQL Server Compact 3.5 and Microsoft Visual Studio 2008, developers have an easy-to-deploy solution for local data. Ranging from caching reference data to full offline scenarios, developers can use a single engine for their Windows Mobile-powered devices, or their full desktop clients–benefiting from the power of SQL Server in a compact footprint. Using Visual Studio 2008, we show how SQL Server Compact can be transparently deployed with unique features including updatable result sets and a custom document format, and how to manage the creation and maintenance of your local data. This session is packed with demonstrations that can get you started today.
MSDN Webcast: Introducing SQL Server Compact 3.5 (Level 200)
TechNet Webcast: Mining for Quality: Apply Adaptive Data Quality with SQL Server Data Mining (Level 200) – Thursday, January 17, 2008 8:00 AM Pacific Time (US & Canada)
Good quality data is essential to a successful business intelligence application. You are probably aware that Microsoft SQL Server includes some useful data quality tools such as Fuzzy Grouping or Fuzzy Lookup. However, there is one tool you may have overlooked—SQL Server Data Mining. When used operationally, SQL Server Data Mining is extremely useful for finding data that lies outside the boundaries of known good data, and it finds these outliers inductively rather than relying on exhaustively hard-coded rules. In this webcast, we introduce this new, adaptive approach to data quality and we show how adaptive quality can be applied at many phases of the business intelligence project—whether data entry, during warehouse loading, or during analysis.
TechNet Webcast: Mining for Quality: Apply Adaptive Data Quality with SQL Server Data Mining (Level 200)
TechNet Webcast: Microsoft SQL Server and FileMaker Pro 9 Interoperability (Level 200) – Monday, January 21, 2008 1:00 PM Pacific Time (US & Canada)
Microsoft SQL Server works seamlessly with FileMaker Pro version 9. FileMaker is more than database software; it is a rapid-application development environment that anyone can use to quickly create solutions for collecting, managing, and reporting data. Join this webcast to understand how developers can benefit from connecting FileMaker Pro 9 and Microsoft SQL Server. We also show a technology demonstration of FileMaker Pro 9 connecting with Microsoft SQL Server.
TechNet Webcast: Microsoft SQL Server and FileMaker Pro 9 Interoperability (Level 200)
TechNet Webcast: Mastering Time Series Prediction with SQL Server 2008 Data Mining (Level 300) – Thursday, January 24, 2008 8:00 AM Pacific Time (US & Canada)
Time series data is one of the most useful sources for data mining. Whether it be estimating future gasoline prices or understanding the relationship between the weather and sales, there is a role for time series analysis. In the new release of Microsoft SQL Server 2008 Data Mining, Microsoft has introduced some important enhancements to our support in this area, making powerful analysis both more effective and easier to use. In this webcast, we not only introduce these new features, but we also cover many of the business scenarios for which time series prediction is invaluable.
TechNet Webcast: Mastering Time Series Prediction with SQL Server 2008 Data Mining (Level 300)
MSDN Webcast: Optimizing Online, Enabling Offline with SQL Server Compact and Sync Services for ADO.NET (Level 200) – Thursday, January 24, 2008 10:00 AM Pacific Time (US & Canada)
With Microsoft SQL Server Compact, developers can now easily cache data on the client in a compact, yet capable, transactional, queryable document-like database format. To maintain the cache, Sync Services for ADO.NET enables developers to easily cache data directly or over services using Windows Communication Foundation (WCF). Microsoft Visual Studio 2008 delivers new integrated, developer-oriented sync designers making caching an easy task to increase user productivity, decrease the server workload, and simplify data access. Using Sync Services for ADO.NET, developers can enable full offline scenarios as well. Join this webcast to find out what SQL Server Compact and Sync Services for ADO.NET have to offer for the "edge of the network" clients.
MSDN Webcast: Optimizing Online, Enabling Offline with SQL Server Compact and Sync Services for ADO.NET (Level 200)
MSDN Webcast: New T-SQL and Engine Features, New Data Types for SQL Server Programmability (Level 200) – Wednesday, January 30, 2008 8:30 AM Pacific Time (US & Canada)
With Microsoft SQL Server Compact 3.5 and Visual Studio 2008, developers have an easy-to-deploy solution for local data. Ranging from caching reference data to full offline scenarios, developers can use a single engine for their Windows Mobile devices to their full desktop client computers, benefiting from the power of SQL Server. In this session, we give an overview of the major programmability enhancements in the SQL Server 2008 Database Engine. We cover the new data types, table-valued parameters, and other new capabilities, like the ability to define sparse columns and filtered indexes.
MSDN Webcast: New T-SQL and Engine Features, New Data Types for SQL Server Programmability (Level 200)
Further on-demand webcasts are available here: https://www.microsoft.com/events/series/technetsqlserver2005.mspx
New KB's
SQL Server 2005 Standard Edition
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
https://support.microsoft.com/?kbid=944678
FIX: The logins are incorrectly deleted when you run a SQL Server 2005 Integration Services package that contains a Transfer SQL Server Objects task
https://support.microsoft.com/?kbid=945323
FIX: Error message when you execute a maintenance plan that contains a Rebuild Index task in SQL Server 2005 Service Pack 2: "The Execute method on the task returned error code 0x8007000E (Exception of type 'System.OutOfMemoryException' was thrown)"
https://support.microsoft.com/?kbid=938910
SQL Server 2005 does not validate all articles in a transactional publication when you run the sp_publication_validation stored procedure to validate the articles
https://support.microsoft.com/?kbid=945066
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>'"
https://support.microsoft.com/?kbid=945465
SQL Server 2005 cannot index some 2007 Office document formats
https://support.microsoft.com/?kbid=945539
The SQL Server 2005 Setup program generates an incorrect error message when you install a SQL Server 2005 failover cluster and the Setup program cannot access the cluster resource
https://support.microsoft.com/?kbid=945937
The DHCP support is not available when you install SQL Server 2005 on a Windows Server 2008 failover cluster
https://support.microsoft.com/?kbid=945936
FIX: The CREATE PROCEDURE statement does not run when you try to run the statement to create a stored procedure that contains a very large amount of text in SQL Server 2005
https://support.microsoft.com/?kbid=942680
FIX: Error message when an application that is running as a Windows service calls some SSIS packages: "A variable may only be added once to either the read lock list or the write lock list"
https://support.microsoft.com/?kbid=945914
FIX: A query returns the incorrect result when you run a query that uses the USE PLAN query hint in SQL Server 2005
https://support.microsoft.com/?kbid=946031
FIX: The Processors page in the Server Properties dialog box in SQL Server Management Studio does not correctly report the processor affinity for an instance of SQL Server 2005 on a computer that has more than 32 processors
https://support.microsoft.com/?kbid=946037
FIX: Error message when you run the sp_dbmmonitorresults stored procedure in SQL Server 2005: "An internal error has occurred in the database mirroring monitor"
https://support.microsoft.com/?kbid=946038
FIX: Error message when you run a complex query in SQL Server 2005: "The query processor ran out of stack space during query optimization"
https://support.microsoft.com/?kbid=945896
You cannot compile a SQL Server Compact-based OLE DB application for Windows Mobile 5.0, and the Transact.h file cannot be found
https://support.microsoft.com/?kbid=945374
FIX: You must restart the SQL Server service on the principal server after you resume the SQL Server service process from a debug tool in SQL Server 2005
https://support.microsoft.com/?kbid=943389
FIX: The witness server crashes and a minidump file is generated in the SQL Server 2005 log folder when you manually failover database mirroring in SQL Server 2005 build 2239
https://support.microsoft.com/?kbid=943388
FIX: A minidump file is generated, and an error message is logged in the SQL Server error log when you run the DBCC MEMORYSTATUS statement in SQL Server 2005
https://support.microsoft.com/?kbid=944968
FIX: The setMaxRows method unexpectedly applies to DELETE statements when you use the SQL Server 2005 JDBC Driver version 1.2 to connect to a database
https://support.microsoft.com/?kbid=945842
FIX: Conflicts are not logged when you use the Microsoft SQL Server Subscriber Always Wins Conflict Resolver for an article in a merge replication in Microsoft SQL Server 2005
https://support.microsoft.com/?kbid=944677
FIX: The DBCC CHECKDB statement takes longer to run on an x64-based computer than the statement takes to run on a 32-bit computer when you run the statement against a database in SQL Server 2005
https://support.microsoft.com/?kbid=945770
FIX: You have to enter the old password of a SQL Server login when you try to change the password of the login by using SQL Server Management Studio in SQL Server 2005
https://support.microsoft.com/?kbid=942657
Some visual elements in SQL Server Management Studio lose functionality when you register many instances of SQL Server
https://support.microsoft.com/?kbid=945068
Error message when you run a maintenance plan after you set the "allow updates" option to 1 in SQL Server 2005: "Alter failed for server"
https://support.microsoft.com/?kbid=945067
FIX: Error message when you jump to another report that uses a shared data source in SQL Server 2005 Reporting Services: "One or more data sources is missing credentials"
https://support.microsoft.com/?kbid=946023
How to register Microsoft Filter Pack IFilters with SQL Server 2005 and with SQL Server 2008
https://support.microsoft.com/?kbid=945934
FIX: The data on the publisher does not match the data on the subscriber when you synchronize a SQL Server 2005 Mobile Edition subscriber with a SQL Server 2000 "merge replication" publisher
https://support.microsoft.com/?kbid=944985
FIX: You may still experience the performance issue that is described in KB article 940945 after you install Cumulative Update 3 for SQL Server 2005 Service Pack 2
https://support.microsoft.com/?kbid=945127
FIX: You can run the ALTER ASYMMETRIC KEY statement or the ALTER CERTIFICATE statement by using a SQL Server login that does not have permissions to run these statements in Microsoft SQL Server 2005
https://support.microsoft.com/?kbid=945054
FIX: You may experience problems when you use SQL Server Management Studio in SQL Server 2005 to connect to an instance of SQL Server 2008
https://support.microsoft.com/?kbid=946127
FIX: You may receive incorrect data when you run a query against a database that has the PARAMETERIZATION database option set to FORCED in SQL Server 2005
https://support.microsoft.com/?kbid=945308
Error message when you use the updateRow method in the SQL Server 2005 JDBC Driver to update a result set in SQL Server 2000: "Result set is not updatable" or "The cursor is READ ONLY"
https://support.microsoft.com/?kbid=945738
Cumulative update package 6 for SQL Server 2005 Service Pack 2
https://support.microsoft.com/?kbid=946608
FIX: Error messages when you run the database mirroring monitoring job by using the sp_dbmmonitorupdate stored procedure in SQL Server 2005: "Error: 102, Severity: 15, State: 1" and "Error: 319, Severity: 15, State: 1"
https://support.microsoft.com/?kbid=945907
SQL Server 2005 Analysis Services
FIX: A Multidimensional Expressions (MDX) query takes a long time to finish in Microsoft SQL Server 2005 Analysis Services
https://support.microsoft.com/?kbid=944152
FIX: A prediction operation takes a long time to execute when you have a mining model that uses the Microsoft Neural Network algorithm in SQL Server 2005 Analysis Services
https://support.microsoft.com/?kbid=945894
FIX: HTTP access to a SQL Server 2005 Analysis Services instance fails if you use a proxy server that requires authentication
https://support.microsoft.com/?kbid=946025
FIX: Some user-defined hierarchies are missing when you view the local cube if you filter some dimensions of the source cube in SQL Server 2005 Analysis Services
https://support.microsoft.com/?kbid=945891
When you request a large MDSCHEMA_MEMBERS schema rowset from a client application, the request takes a long time to respond and the client application uses lots of virtual memory in SQL Server 2005 Analysis Services
https://support.microsoft.com/?kbid=945685
FIX: The prediction process may take a long time when you use a mining model to generate predictions in SQL Server 2005 Analysis Services
https://support.microsoft.com/?kbid=946000
FIX: An MDX query that uses the NonEmptyCrossjoin function on more than one measure group does not return all records after you install SQL Server 2005 Service Pack 2
https://support.microsoft.com/?kbid=946028
FIX: An MDX query that uses subqueries may return incorrect data after you install SQL Server 2005 Service Pack 2
https://support.microsoft.com/?kbid=946027
FIX: A Multidimensional Expressions (MDX) query that references a named set may return incorrect data after you install SQL Server 2005 Service Pack 2
https://support.microsoft.com/?kbid=946024
FIX: Unexpected results may be returned when you discontinuously run MDX queries that cross both hierarchies against the dimension in SQL Server 2005 Analysis Services
https://support.microsoft.com/?kbid=944001
SQL Server 2000 Reporting Services
FIX: Error message when you display a SQL Server 2000 Reporting Services report in an ASP.NET application: "System.Net.WebException: The operation has timed-out"
https://support.microsoft.com/?kbid=942713
SQL Server 2005 Reporting Services
FIX: You receive an exception error message when you try to display a Reporting Services report on a server that uses the AMD Cool'n'Quiet technology
https://support.microsoft.com/?kbid=945600
FIX: Error message when you jump to another report that uses a shared data source in SQL Server 2005 Reporting Services: "One or more data sources is missing credentials"
https://support.microsoft.com/?kbid=946023
FIX: Error message when you display a SQL Server 2005 Reporting Services report on a computer that has multiple processors: "An internal error occurred on the report server"
https://support.microsoft.com/?kbid=946082
FIX: You cannot export a SQL Server 2005 Reporting Services report from a report server to an Excel format file on a computer that has FIPS-compliant algorithms enabled
https://support.microsoft.com/?kbid=946029
FIX: Error message when you try to save a SQL Server 2005 Reporting Services report in Report Builder: "An error occured while saving your report"
https://support.microsoft.com/?kbid=946035
FIX: The InScope function returns incorrect data when you use the function for a static column or for a subtotal column in a matrix data region in a SQL Server 2005 Reporting Services report
https://support.microsoft.com/?kbid=945910
SQL Server 2005 Reporting Services e-mail subscriptions do not work in Windows Vista and in Windows Server 2008 if you use aliases as e-mail addresses
https://support.microsoft.com/?kbid=945601