[go: up one dir, main page]

 
 
ProfileSinco‘s SpacesPhotosBlogListsMore Tools Help
Sinco‘s Spaces
SAP ERP MES APS ORACLE JAVA RFC BAPI NET
No list items have been added yet.
Feed
The owner hasn't specified a feed for this module yet.
Custom HTML
No content has been added yet.
This person hasn't added any friends or is keeping their list private.
No list items have been added yet.
Feed
The owner hasn't specified a feed for this module yet.
No list items have been added yet.
Video
No content has been added yet.
No list items have been added yet.
August 11

SQL Server 2008 Download

We recommend you read the Release Notes and Readme before installing SQL Server Enterprise Evaluation.
SQL Server 2008 Enterprise Evaluation is available as an image file that contains X86, X64 and IA64 installable versions. You can use this image to burn your own DVD.

    Step 1: Click the following link to download the file.
    Step 2: Using your DVD-burning software, select the options to burn a DVD from an .ISO image. When you are prompted for a file to use, select the image file that you downloaded. After burning the DVD, locate and double-click Setup.exe on the DVD to begin the installation.
    Step 3: Follow the installation instructions provided in the Readme.
You may also download a self-extracting executable (EXE) that is specific for X86, X64 or IA64. These executables do not support X86 installations on 64-bit versions of Windows. Use the DVD image for X86 installations on 64-bit versions of Windows (IA64 is not supported).
August 02

OracleJOB时间间隔参考[Oracle]

ALTER SYSTEM SET JOB_QUEUE_PROCESSES = 0;

  每天午夜12点 'TRUNC(SYSDATE + 1)'

  每天早上8点30分 'TRUNC(SYSDATE + 1) + (8*60+30)/(24*60)'

  每星期二中午12点 'NEXT_DAY(TRUNC(SYSDATE ), ''TUESDAY'' ) + 12/24'

  每个月第一天的午夜12点 'TRUNC(LAST_DAY(SYSDATE ) + 1)'

  每个季度最后一天的晚上11点 'TRUNC(ADD_MONTHS(SYSDATE + 2/24, 3 ), 'Q' ) -1/24'

  每星期六和日早上6点10分 'TRUNC(LEAST(NEXT_DAY(SYSDATE, ''SATURDAY"), NEXT_DAY(SYSDATE, "SUNDAY"))) + (6*60+10)/(24*60)'

  其中li_jobno是它的ID,可以通过这个ID停掉这个任务,最后想说的是不要执行多次,你可以在里面管理起来,发现已经运行了就不SUBMIT

  每天运行一次 'SYSDATE + 1'

  每小时运行一次 'SYSDATE + 1/24'

  每10分钟运行一次 'SYSDATE + 10/(60*24)'

  每30秒运行一次 'SYSDATE + 30/(60*24*60)'

  每隔一星期运行一次 'SYSDATE + 7'

  不再运行该任务并删除它 NULL

  每年1月1号零时    trunc(last_day(to_date(extract(year from sysdate)||'12'||'01','yyyy-mm-dd'))+1)

July 29

SQL 2008 Server

Developer:  PTTFM-X467G-P7RH2-3Q6CG-4DMYB
Enterprise: JD8Y6-HQG69-P9H84-XDTPG-34MBB

Microsoft SQL Server 2008 Feature Pack, August 2008

http://www.microsoft.com/downloads/details.aspx?displaylang=en&FamilyID=c6c3e9ef-ba29-4a43-8d69-a2bed18fe73c
Instructions
    Download the appropriate file by clicking one of the links below, then run the downloaded file to install that package.
    Each package indicates the audience(s) for which it was intended, as follows:
      Customer: An individual may want to install this for additional licensed functionality such as interoperability.
      Partner: An ISV may want to ship this as a redistributable component as part of their application.
      Developer: A programmer may want to install this to support application development.
    Note: To archive a copy of the license terms, prior to accepting them copy and paste the terms to a word processing program, and print or save to your favorite directory.
    Microsoft SQL Server 2008 Analysis Services 10.0 OLE DB Provider
      The Analysis Services 10.0 OLE DB Provider is a COM component that software developers can use to create client-side applications that browse metadata and query data stored in Microsoft SQL Server 2008 Analysis Services. This provider implements both the OLE DB specification and the specification’s extensions for online analytical processing (OLAP) and data mining.
      Note: Microsoft SQL Server 2008 Analysis Services 10.0 OLE DB Provider requires Microsoft Core XML Services (MSXML) 6.0, also available on this page.
      Audience(s): Customer, Partner, Developer

    Microsoft SQL Server 2005 Backward Compatibility Components
      The SQL Server Backward Compatibility package includes the latest versions of Data Transformation Services 2000 runtime (DTS), SQL Distributed Management Objects (SQL-DMO), Decision Support Objects (DSO), and SQL Virtual Device Interface (SQLVDI). These versions have been updated for compatibility with both SQL Server 2005 and SQL Server 2008 and include all fixes shipped through SQL Server 2000 SP4 and SQL Server 2005 SP2.
      Audience(s): Customer, Partner, Developer

    Microsoft SQL Server 2008 Command Line Utilities
      The SQLCMD utility allows users to connect, send Transact-SQL batches, and output rowset information from SQL Server 7.0, SQL Server 2000, SQL Server 2005, and SQL Server 2008 instances. The bcp utility bulk copies data between an instance of Microsoft SQL Server 2008 and a data file in a user-specified format. The bcp utility can be used to import large numbers of new rows into SQL Server tables or to export data out of tables into data files.
      Note: This component also requires both Windows Installer 4.5 and Microsoft SQL Server Native Client (which is another component available from this page).
      Audience(s): Customer, Partner, Developer

    SQL Server Compact 3.5 SP1
      SQL Server Compact is a free, easy-to-use embedded database engine that lets developers build robust Windows Desktop and mobile applications that run on all Windows platforms including Windows XP, Vista, Pocket PC, and Smartphone. Run the Microsoft Windows installer file (MSI) to install the product. The single setup program will install the provider and tools on x86 and x64 computers. The package includes product updates in the form of an integrated Service Pack 1. Read the installation guide and Readme for more information.
      Audience(s): Customer, Partner, Developer

    Microsoft SQL Server 2008 Data Mining Add-ins for Microsoft Office 2007
      Microsoft SQL Server 2008 Data Mining Add-ins for Microsoft Office 2007 enables you to take advantage of SQL Server 2008 predictive analytics in Office Excel 2007 and Office Visio 2007. The download includes the following components:
      • Table Analysis Tools for Excel: This add-in provides easy-to-use tools that leverage SQL Server 2008 data mining features to perform powerful analytics on your spreadsheet data. Two new tools have been added for this release: Prediction Calculator and Shopping Basket Analysis.
      • Data Mining Client for Excel: This add-in enables you to go through the full data mining model development lifecycle within Excel 2007 using your spreadsheet data or external data accessible through your SQL Server 2008 Analysis Services instance. This release adds support for new SQL Server 2008 data mining features including holdout and cross-validation, a new Document Model wizard, and improvements to existing wizards.
      • Data Mining Templates for Visio: This add-in enables you to render and share your mining models as annotatable Visio 2007 drawings.
      Audience(s): Customer, Partner, Developer

    Microsoft SQL Server 2005 Driver for PHP
      The SQL Server 2005 Driver for PHP is a PHP 5 extension that allows for accessing data in all Editions of SQL Server 2005 and SQL Server 2008 (including Express Editions) from within PHP scripts. The driver provides a procedural interface for accessing data and makes use of PHP features, including PHP streams to read and write large objects. With this release, the source code for the driver is available here: http://go.microsoft.com/fwlink/?LinkID=123842&clcid=0x409 . The SQL Server 2005 Driver for PHP relies on the Microsoft SQL Server Native Client to communicate with SQL Server. For more information about SQL Server Native Client, visit the SQL Server Native Client page on MSDN.
      Audience(s): Developer, DBA

    Microsoft Core XML Services (MSXML) 6.0
      Microsoft Core XML Services (MSXML) 6.0 is the latest version of the native XML processing stack. MSXML 6.0 provides standards-conformant implementations of XML 1.0, XML Schema (XSD) 1.0, XPath 1.0, and XSLT 1.0. In addition, it offers 64-bit support, increased security for working with untrusted XML data, and improved reliability over previous versions of MSXML.
      Audience(s): Partner, Developer

    Microsoft SQL Server 2005 JDBC Driver 1.2
      In its continued commitment to interoperability, Microsoft has released a Java Database Connectivity (JDBC) driver for SQL Server. The SQL Server 2005 JDBC Driver v1.2 download is available to all SQL Server users at no additional charge, and provides access to SQL Server 2000, SQL Server 2005, and SQL Server 2008 from any Java application, application server, or Java-enabled applet. This is a Type 4 JDBC driver that provides database connectivity through the standard JDBC application program interfaces (APIs) available in J2EE (Java2 Enterprise Edition).
      Audience(s): Partner, Developer

    Microsoft SQL Server 2008 Management Objects
      The SQL Server Management Objects (SMO) is a .NET Framework object model that enables software developers to create client-side applications to manage and administer SQL Server objects and services. This object model will work with SQL Server 2000, SQL Server 2005 and SQL Server 2008.
      Note: Microsoft SQL Server 2008 Management Objects Collection requires Microsoft Core XML Services (MSXML) 6.0 , Microsoft SQL Server Native Client, and Microsoft SQL Server System CLR Types. These are available on this page.
      Audience(s): Customer, Partner, Developer

    Microsoft OLEDB Provider for DB2
      The Microsoft OLE DB Provider for DB2 Version 2.0 is a COM component for integrating vital data stored in IBM DB2 databases with new solutions based on Microsoft SQL Server 2008 Enterprise Edition and Developer Edition. SQL Server developers and administrators can use the provider with Integration Services, Analysis Services, Replication, Reporting Services, and Distributed Query Processor. Run the self-extracting download package to create an installation folder. The single setup program will install the Version 2.0 provider and tools on x86, x64, and IA64 computers. Read the installation guide and Readme for more information.
      Audience(s): Customer, Developer

    SQL Server Remote Blob Store
      The SQL Server Remote Blob Store is a method for storing blobs of unstructured data in an external Content Addressable data store. The component consists of a client-side DLL which is linked into a user application, as well as a set of stored procedures to be installed on the SQL Server. Run the self-extracting download package to create an installation folder. The setup program contained there will install RBS on X86, X64, and IA64 computers.
      Audience(s): Developer, DBA

    Microsoft SQL Server 2008 Native Client
      Microsoft SQL Server 2008 Native Client (SQL Native Client) is a single dynamic-link library (DLL) containing both the SQL OLE DB provider and SQL ODBC driver. It contains run-time support for applications using native-code APIs (ODBC, OLE DB and ADO) to connect to Microsoft SQL Server 2000, 2005, or 2008. SQL Native Client should be used to create new applications or enhance existing applications that need to take advantage of new SQL Server 2008 features. This redistributable installer for SQL Native Client installs the client components needed during run time to take advantage of new SQL Server 2008 features, and optionally installs the header files needed to develop an application that uses the SQL Native Client API.
      Audience(s): Customer, Partner, Developer

    Microsoft SQL Server 2008 Policies
      Microsoft SQL Server 2008 Policies are examples of how you can take advantage of Policy Based Management. These policies will help you follow some of the SQL Server best practices and avoid common pitfalls. For more information, please see Administering Servers by Using Policy Based Management in SQL Server 2008 Books Online.
      Note: This component also requires Windows Installer 4.5.
      Audience(s): Customer, Partner, Developer
        Package (SQLServerBestPracticesPolicies.msi) -1343 KB

    Microsoft SQL Server 2008 Reporting Services Add-in for Microsoft SharePoint Technologies
      Microsoft SQL Server 2008 Reporting Services Add-in for SharePoint Technologies allows you to take advantage of SQL Server 2008 report processing and management capabilities in SharePoint integrated mode. This version also includes data-driven subscriptions. The download provides a Report Viewer Web part, Web application pages, and support for using standard Windows SharePoint Services or Microsoft Office SharePoint Services.
      Audience(s): Customer, Partner, Developer

    Microsoft SQL Server System CLR Types
      The SQL Server System CLR Types package contains the components implementing the new geometry, geography, and hierarchyid types in SQL Server 2008. This component can be installed separately from the server to allow client applications to use these types outside of the server.
      Note: This component also requires Windows Installer 4.5.
      Audience(s): Customer, Partner, Developer

    Microsoft Sync Framework
      Microsoft Sync Framework is a comprehensive synchronization platform that enables collaboration and offline access for applications, services and devices. Using Microsoft Sync Framework runtime, developers can build sync ecosystems that integrate any application, with any data from any store using any protocol over any network. Sync Services for ADO.NET is a part of the Microsoft Sync Framework (MSF). Sync Services for ADO.NET enables synchronization between ADO.NET enabled databases. Because Sync Services for ADO.NET is part of the MSF, any database that uses Sync Services for ADO.NET can then also exchange information with other data sources that are supported by MSF, such as web services, file systems or custom data stores. For more information about the Microsoft Sync Framework, please go to Microsoft Sync Framework Developer Center.
      Audience(s): Customer, Developer

    Microsoft SQL Server 2008 Upgrade Advisor
      Microsoft SQL Server 2008 Upgrade Advisor analyzes instances of SQL Server 2000 and SQL Server 2005 in preparation for upgrading to SQL Server 2008. Upgrade Advisor identifies feature and configuration changes that might affect your upgrade, and it provides links to documentation that describes each identified issue and how to resolve it.
      Note: This component also requires Windows Installer 4.5.
      Audience(s): Customer, Partner, Developer

Feature Pack for Microsoft SQL Server 2005 - November 2005

    单击下列其中一个链接,下载相应的文件,然后运行下载的文件来安装该包。
    每个包均指示了其适用的用户,如下所示:
      客户:个人可能需要安装此包,以获取其他许可功能,如互操作性。
      伙伴:ISV 可能需要将此包作为可再分发的组件,作为其应用程序的一部分提供。
      开发人员:程序员可能需要安装此包以支持应用程序开发。

    Microsoft Core XML Services (MSXML) 6.0
      Microsoft Core XML Services (MSXML) 6.0 是本机 XML 处理堆栈的最新版本。MSXML 6.0 提供了符合标准实现的 XML 1.0、XML Schema (XSD) 1.0、XPath 1.0 和 XSLT 1.0。此外,它还提供了 64 位支持,增强了使用不可信 XML 数据时的安全性,并且与以前的 MSXML 版本相比可靠性得到了提高。
      用户:伙伴、开发人员

    Microsoft OLEDB Provider for DB2
      Microsoft OLE DB Provider for DB2 是一个 COM 组件,它可基于 Microsoft SQL Server 2005 Enterprise Edition 和 Developer Edition 将 IBM DB2 数据库中存储的关键数据与新的解决方案集成在一起。SQL Server 开发人员和管理员可以将此提供程序与 SQL Server Integration Services、SQL Server Analysis Services、复制和分布式查询处理器结合使用。运行自解压缩下载包以创建安装文件夹。该单个安装程序将在 x86 和 x64 计算机中安装提供程序和工具。有关更多信息,请阅读安装指南和自述文件。
      用户:客户、开发人员

    针对 Microsoft SQL Server 2005 的 Microsoft Operations Manager 2005 Management Pack
      通过 Microsoft SQL Server Management Pack 可以在企业环境中监视 SQL Server 2005 和 SQL Server 2000。使用包含的企业级功能可以监视资源可用性和配置,收集性能数据和测试默认阈值。检查本地和远程的连接将有助于确保数据库的可用性。
      借助 SQL Server Management Pack 中嵌入的专业技术,可以在问题变得严重之前确定和管理这些问题。此管理包可提高 SQL Server 基础结构的安全性、可用性以及性能。
      其中包含的 Microsoft SQL Server Management Pack Guide 描述了该管理包的内容及其部署方式。
      用户:客户

    Microsoft SQL Server 2000 PivotTable Services
      PivotTable Services 8.0 是 SQL Server 2000 Analysis Services 的 OLE DB 提供程序,用于连接 Analysis Services 2000 server。PivotTable Services 不能与 SQL Server 2005 Analysis Services 结合使用。因此,需要连接到 SQL Server 2000 和 SQL Sever 2005 中 Analysis Services 的客户端应用程序将需要在并行配置中安装 PivotTable Services 8.0 和 Analysis Services 9.0 OLE DB。
      用户:客户、伙伴、开发人员

    Microsoft SQL Server 2000 DTS 设计器组件
      Microsoft SQL Server 2000 Data Transformation Services (DTS) 包设计器是一种设计工具,在以 SQL Server 2005 Integration Services 包格式升级或重新创建 DTS 包之前,SQL Server 2005 服务器的开发人员和管理员可以使用该设计工具编辑和维护现有的 DTS 包。安装此下载后,SQL Server 2005 用户无需重新安装 SQL Server 2000 工具即可继续对来自 SQL Server 2005 Management Studio 中 Object Explorer 以及 Business Intelligence Development Studio 中 Execute DTS 2000 Package Task Editor 的现有 DTS 包进行编辑和维护。此下载中的 DTS 包设计器以前是通过 SQL Server 2000 Enterprise Manager 中的 Data Transformation Services 节点访问的。
      用户:客户、开发人员

    Microsoft SQL Server Native Client
      Microsoft SQL Server Native Client (SQL Native Client) 是单一动态链接库 (DLL),包含 SQL OLE DB 提供程序和 SQL ODBC 提供程序。它还对使用本机代码 API(ODBC、OLE DB 和 ADO)的应用程序提供运行时支持,以与 Microsoft SQL Server 7.0、2000 或 2005 连接。应使用 SQL 本机客户端创建新的应用程序,或增强需利用 SQL Server 2005 新增功能的现有应用程序。SQL 本机客户端的这个可再分发安装程序将安装运行时所需的客户端组件,以利用 SQL Server 2005 的新增功能,或者安装使用 SQL Native Client API 开发应用程序所需的头文件。
      用户:伙伴、开发人员

    Microsoft SQL Server 2005 Analysis Services 9.0 OLE DB Provider
      Analysis Services 9.0 OLE DB Provider 是一种 COM 组件,软件开发人员可使用该组件创建客户端应用程序,以用于浏览元数据和查询存储在 Microsoft SQL Server 2005 Analysis Services 中的数据。此提供程序还可为联机分析处理 (OLAP) 和数据挖掘实现 OLE DB 规范及规范的扩展。
      注意:Microsoft SQL Server 2005 Analysis Services 9.0 OLE DB Provider 需要安装 Microsoft Core XML Services (MSXML) 6.0,可以在此页面中找到该程序。
      用户:客户、伙伴、开发人员

    Microsoft SQL Server 2005 Backward Compatibility Components
      SQL Server Backward Compatibility 包中包含最新版本的 Data Transformation Services 2000 运行时 (DTS)、SQL 分布式管理对象 (SQL-DMO)、决策支持对象 (DSO) 和 SQL 虚拟设备接口 (SQLVDI)。为了与 SQL Server 2005 兼容,这些版本已进行了更新,并且包含 SQL Server 2000 SP4 提供的所有修复程序。
      用户:客户、伙伴、开发人员

    Microsoft SQL Server 2005 Command Line Query Utility
      用户使用 SQLCMD 实用工具可以连接和发送 Transact-SQL 批以及 SQL Server 7.0、SQL Server 2000 和 SQL Server 2005 实例中的输出行集信息。SQLCMD 可以替换 ISQL 和 OSQL,但也可以与安装了 ISQL 或 OSQL 的安装并存。
      注意:Microsoft SQL Server 2005 Command Line Query Utility 需要安装 Microsoft SQL Server Native Client,可以在此页面中找到该程序。
      用户:客户、伙伴、开发人员

    Microsoft SQL Server 2005 Datamining Viewer Controls
      Data Mining Web Controls Library 是一组 Microsoft Windows Forms 控件,软件开发人员通过它可以显示在其客户端应用程序中使用 Microsoft SQL Server 2005 Analysis Services 创建的数据挖掘模型。此库中的控件将显示 Analysis Services 挖掘模型中包含的模式。
      注意:Microsoft SQL Server 2005 Datamining Viewer Controls 需要安装 Microsoft SQL Server 2005 Analysis Services 9.0 OLE DB Provider,可以在此页面中找到该程序。
      用户:伙伴、开发人员

    Microsoft SQL Server 2005 JDBC Driver
      由于对互操作性的连续承诺,Microsoft 将发布和支持用于 SQL Server 2005 的新 Java 数据库连接 (JDBC) 驱动程序。所有 SQL Server 用户可以免费下载 SQL Server 2005 JDBC Driver,并可以从任何 Java 应用程序、应用程序服务器或支持 Java 的小程序访问 SQL Server 2000 和 SQL Server 2005。这是一个 Type 4 JDBC 驱动程序,它在 J2EE (Java2 Enterprise Edition) 的标准 JDBC 应用程序编程接口 (API) 中提供了 de-facto 数据库连接。
      用户:伙伴、开发人员

    Microsoft SQL Server 2005 Management Objects Collection
      该管理对象集合包中包含了 SQL Server 2005 管理 API 的多个关键元素:分析管理对象 (AMO)、复制管理对象 (RMO) 和 SQL Server 管理对象 (SMO)。开发人员和 DBA 可以使用这些组件通过编程方式管理 SQL Server 2005。
      注意:Microsoft SQL Server 2005 Management Objects Collection 需要安装 Microsoft Core XML Services (MSXML) 6.0Microsoft SQL Server Native Client,可以在此页面中找到这两个程序。
      用户:客户、伙伴、开发人员

    Microsoft SQL Server 2005 Mobile Edition
      使用 SQL Server 2005 Mobile Edition (SQL Server Mobile) 可以快速开发将企业数据管理功能扩展到移动设备的应用程序。若要获得最新版的 SQL Server Mobile 外接程序、更新、工具和组件,请访问 SQL Server Mobile Download 站点
      用户:客户、伙伴、开发人员

    Microsoft SQL Server 2005 Notification Services Client Components
      SQL Server 2005 Notification Services Client Components 包提供了客户端 API,用于在包含 SQL Server 2005 Notification Services 功能的自定义应用程序中启用订阅管理和事件提交。开发人员通过订阅管理 API 可以创建订阅和订阅服务器,以及管理订阅服务器设备。用户通过事件提交 API 可以使用事件 API 或存储过程来指定事件。
      用户:伙伴

    Microsoft SQL Server 2005 Upgrade Advisor
      升级顾问可对 SQL Server 7.0 和 SQL Server 2000 的实例进行分析,以为升级到 SQL Server 2005 做准备。升级顾问还可确定可能会影响升级的不推荐使用的功能和配置更改,并提供了描述每个确定问题和解决方法的文档的链接。
      用户:客户、开发人员

    Microsoft .NET Data Provider for mySAP Business Suite,预览版
      SQL Server 2005 支持使用 Microsoft .NET Data Provider for mySAP Business Suite 访问 SAP 数据。通过此提供程序可以创建可与 mySAP Business Suite 解决方案连接的 Integration Services 包,然后执行可通过支持界面访问数据的命令。还可以基于运行 mySAP Business Suite 的服务器创建 Reporting Services 报表。
      您可以在 SQL Server 导入和导出向导以及各种 Integration Services 功能(包括 Script 任务、DataReader Source 组件和 Script 组件)中使用 Microsoft .NET Data Provider for mySAP Business Suite,而且可在 Reporting Services 中使用数据处理扩展。
      SQL Server 2005 中不包括 Microsoft .NET Data Provider for mySAP Business Suite。该预览版已经根据许可条款被授权为预发行软件。有关使用 Microsoft .NET Data Provider for mySAP Business Suite 的前提条件的信息,请参见下载中包含的自述文件。
      用户:客户、伙伴、开发人员

    Reporting Add-In for Microsoft Visual Web Developer 2005 Express
      Reporting Add-In for Microsoft Visual Web Developer 2005 Express 包括一个 ReportViewer 控件、一个集成报表设计器和一个允许您自定义运行时功能的综合 API。可以使用该控件向 ASP.NET Web 应用程序中添加交互式实时数据报表。这些报表可以使用任何 ADO.NET DataTable 或自定义业务对象中的数据。您可以使用自由格式或传统报表布局创建包含表格、矩阵和可视化数据的报表。还可以将集成的报表设计器包括在内,以便可以创建与该控件绑定的自定义报表。
      该报告外接程序作为报告组件与其他 Visual Studio 版本中的报告组件相同,但它不支持 Windows Forms 应用程序。有关产品文档和示例的更多信息,请参阅 MSDN 中的
      ReportViewer Controls (Visual Studio) 主题。
      用户:开发人员

返回页首

此下载中包括的文件
Instructions
    Download the appropriate file by clicking one of the links below, then run the downloaded file to install that package.
    Each package indicates the audience(s) for which it was intended, as follows:
      Customer: An individual may want to install this for additional licensed functionality such as interoperability.
      Partner: An ISV may want to ship this as a redistributable component as part of their application.
      Developer: A programmer may want to install this to support application development.

    Microsoft ADOMD.NET
      ADOMD.NET is a Microsoft .NET Framework object model that enables software developers to create client-side applications that browse metadata and query data stored in Microsoft SQL Server 2005 Analysis Services. ADOMD.NET is a Microsoft ADO.NET provider with enhancements for online analytical processing (OLAP) and data mining.
      Audience(s): Customer, Partner, Developer

    Microsoft Core XML Services (MSXML) 6.0
      Microsoft Core XML Services (MSXML) 6.0 is the latest version of the native XML processing stack. MSXML 6.0 provides standards-conformant implementations of XML 1.0, XML Schema (XSD) 1.0, XPath 1.0, and XSLT 1.0. In addition, it offers 64-bit support, increased security for working with untrusted XML data, and improved reliability over previous versions of MSXML.
      Audience(s): Partner, Developer

    Microsoft OLEDB Provider for DB2
      The Microsoft OLE DB Provider for DB2 is a COM component for integrating vital data stored in IBM DB2 databases with new solutions based on Microsoft SQL Server 2005 Enterprise Edition and Developer Edition. SQL Server developers and administrators can use the provider with SQL Server Integration Services, SQL Server Analysis Services, Replication, and Distributed Query Processor. Run the self-extracting download package to create an installation folder. The single setup program will install the provider and tools on both x86 and x64 computers. Read the installation guide and Readme for more information.
      Audience(s): Customer, Developer

    Microsoft SQL Server Management Pack for MOM 2005
      The Microsoft SQL Server Management Pack enables you to monitor SQL Server 2005 and SQL Server 2000 in an enterprise environment. Included are enterprise-level capabilities to monitor resource availability and configuration, collect performance data, and test default thresholds. Local and remote connectivity checks help ensure database availability.
      With the embedded expertise in the SQL Server Management Pack, you can identify issues and manage issues before they become critical. This Management Pack increases the security, availability, and performance of your SQL Server infrastructure.
      The Microsoft SQL Server Management Pack Guide that is included describes the content of the management pack and how to deploy it.
      Audience(s): Customer

    Microsoft SQL Server 2000 PivotTable Services
      PivotTable Services 8.0 is the OLE DB provider for SQL Server 2000 Analysis Services and is used to connect with an Analysis Services 2000 server. PivotTable Services does not work with SQL Server 2005 Analysis Services. Therefore, client applications that need connect to Analysis Services in both SQL Server 2000 and SQL Sever 2005 will need to install both PivotTable Services 8.0 and Analysis Services 9.0 OLE DB Provider in a side-by-side configuration.
      Audience(s): Customer, Partner, Developer

    Microsoft SQL Server 2000 DTS Designer Components
      The Microsoft SQL Server 2000 Data Transformation Services (DTS) package designer is a design tool used by developers and administrators of SQL Server 2005 servers to edit and maintain existing DTS packages until they can be upgraded or recreated in the SQL Server 2005 Integration Services package format. After installing this download, SQL Server 2005 users can continue to edit and maintain existing DTS packages from the Object Explorer in SQL Server 2005 Management Studio and from the Execute DTS 2000 Package Task Editor in Business Intelligence Development Studio, without needing to reinstall the SQL Server 2000 tools. The DTS package designer in this download was formerly accessed from the Data Transformation Services node in SQL Server 2000 Enterprise Manager.
      Audience(s): Customer, Developer

    Microsoft SQL Server Native Client
      Microsoft SQL Server Native Client (SQL Native Client) is a single dynamic-link library (DLL) containing both the SQL OLE DB provider and SQL ODBC driver. It contains run-time support for applications using native-code APIs (ODBC, OLE DB and ADO) to connect to Microsoft SQL Server 7.0, 2000 or 2005. SQL Native Client should be used to create new applications or enhance existing applications that need to take advantage of new SQL Server 2005 features. This redistributable installer for SQL Native Client installs the client components needed during run time to take advantage of new SQL Server 2005 features, and optionally installs the header files needed to develop an application that uses the SQL Native Client API.
      Audience(s): Partner, Developer

    Microsoft SQL Server 2005 Analysis Services 9.0 OLE DB Provider
      The Analysis Services 9.0 OLE DB Provider is a COM component that software developers can use to create client-side applications that browse metadata and query data stored in Microsoft SQL Server 2005 Analysis Services. This provider implements both the OLE DB specification and the specification’s extensions for online analytical processing (OLAP) and data mining.
      Note: Microsoft SQL Server 2005 Analysis Services 9.0 OLE DB Provider requires Microsoft Core XML Services (MSXML) 6.0, also available on this page.
      Audience(s): Customer, Partner, Developer

    Microsoft SQL Server 2005 Backward Compatibility Components
      The SQL Server Backward Compatibility package includes the latest versions of Data Transformation Services 2000 runtime (DTS), SQL Distributed Management Objects (SQL-DMO), Decision Support Objects (DSO), and SQL Virtual Device Interface (SQLVDI). These versions have been updated for compatibility with SQL Server 2005 and include all fixes shipped through SQL Server 2000 SP4.
      Audience(s): Customer, Partner, Developer

    Microsoft SQL Server 2005 Command Line Query Utility
      The SQLCMD utility allows users to connect, send Transact-SQL batches, and output rowset information from SQL Server 7.0, SQL Server 2000, and SQL Server 2005 instances. SQLCMD is a replacement for ISQL and OSQL, but can coexist with installations that have ISQL or OSQL installed.
      Note: Microsoft SQL Server 2005 Command Line Query Utility requires Microsoft SQL Server Native Client, also available on this page.
      Audience(s): Customer, Partner, Developer

    Microsoft SQL Server 2005 Datamining Viewer Controls
      The Data Mining Web Controls Library is a set of Microsoft Windows Forms controls that enable software developers to display data mining models created using Microsoft SQL Server 2005 Analysis Services in their client-side applications. The controls in this library display the patterns that are contained in Analysis Services mining models.
      Note: Microsoft SQL Server 2005 Datamining Viewer Controls requires Microsoft SQL Server 2005 Analysis Services 9.0 OLE DB Provider, also available on this page.
      Audience(s): Partner, Developer

    Microsoft SQL Server 2005 JDBC Driver
      In its continued commitment to interoperability, Microsoft has released and supports a new Java Database Connectivity (JDBC) driver for SQL Server 2005. The SQL Server 2005 JDBC Driver download is available to all SQL Server users at no additional charge and provides access to SQL Server 2000 and SQL Server 2005 from any Java application, application server, or Java-enabled applet. This is a Type 4 JDBC driver that provides database connectivity through the standard JDBC application programming interfaces (APIs) available in J2EE (Java2 Enterprise Edition).
      Audience(s): Partner, Developer

    Microsoft SQL Server 2005 Management Objects Collection
      The Management Objects Collection package includes several key elements of the SQL Server 2005 management API, including Analysis Management Objects (AMO), Replication Management Objects (RMO), and SQL Server Management Objects (SMO). Developers and DBAs can use these components to programmatically manage SQL Server 2005.
      Note: Microsoft SQL Server 2005 Management Objects Collection requires Microsoft Core XML Services (MSXML) 6.0 and Microsoft SQL Server Native Client, also available on this page.
      Audience(s): Customer, Partner, Developer

    Microsoft SQL Server 2005 Mobile Edition
      Use SQL Server 2005 Mobile Edition (SQL Server Mobile) to rapidly develop applications that extend enterprise data management capabilities to mobile devices. For the latest SQL Server Mobile add-ins, updates, tools, and components, visit the SQL Server Mobile Download site.
      Audience(s): Customer, Partner, Developer

    Microsoft SQL Server 2005 Notification Services Client Components
      The SQL Server 2005 Notification Services Client Components package provides client APIs that enable subscription management and event submission within custom applications that include SQL Server 2005 Notification Services functionality. The subscription management APIs allow developers to create subscriptions and subscribers, and manage subscriber devices. The event submission APIs allow users to specify events using the event APIs or stored procedures.
      Audience(s): Partner

    Microsoft SQL Server 2005 Upgrade Advisor
      Upgrade Advisor analyzes instances of SQL Server 7.0 and SQL Server 2000 in preparation for upgrading to SQL Server 2005. Upgrade Advisor identifies deprecated features and configuration changes that might affect your upgrade, and it provides links to documentation that describes each identified issue and how to resolve it.
      Audience(s): Customer, Developer

    Microsoft .NET Data Provider for mySAP Business Suite, Preview Version
      SQL Server 2005 includes support for accessing SAP data by using the Microsoft .NET Data Provider for mySAP Business Suite. This provider lets you create an Integration Services package that can connect to a mySAP Business Suite solution and then execute commands to access data via supported interfaces. You can also create Reporting Services reports against a server running the mySAP Business Suite.
      You can use the Microsoft .NET Data Provider for mySAP Business Suite in the SQL Server Import and Export Wizard and in various Integration Services features (including the Script task, the DataReader Source component, and the Script component), as well as the data processing extensions in Reporting Services.
      The Microsoft .NET Data Provider for mySAP Business Suite is not included in SQL Server 2005. The preview version is licensed as pre-release software as outlined in the License Terms. See the Readme included with the download for information on the prerequisites for using the Microsoft .NET Data Provider for mySAP Business Suite.
      Audience(s): Customer, Partner, Developer

    Reporting Add-In for Microsoft Visual Web Developer 2005 Express
      The Reporting Add-In for Microsoft Visual Web Developer 2005 Express includes a ReportViewer control, an integrated report designer, and a comprehensive API that lets you customize run-time functionality. You can use the control to add interactive real-time data reports to your ASP.NET Web applications. Reports can use data from any ADO.NET DataTable or custom Business object. You can create reports that combine tabular, matrix, and visual data in free-form or traditional report layouts. An integrated report designer is included so that you can create the custom reports that bind to the control.
      The Reporting Add-In is the same reporting component that is included with other editions of Visual Studio, but without support for Windows Forms applications. For more information including product documentation and samples, see the
      ReportViewer Controls (Visual Studio) topic on MSDN.
      Audience(s): Developer

July 21

32位XP或32位win7系统下硬盘安装64位win7方法[WIN7]

1、首先C盘名称清空,本地磁盘就ok。
2、解压Windows7 64位版到非系统盘,此处以D:\W7为例
3、复制c:\boot\bootsect.exe至C盘根目录(此bootsect.exe为32位)没有的话,直接百度上输bootsect.exe,下一个就ok!
4、复制D:\W7中boot文件夹、efi文件夹、bootmgr及bootmgr.efi至C盘根目录。
5、在C盘根目录下新建sources文件夹,将D:\W7\Sources\boot.wim复制过来。
6、运行cmd,输入命令c:\bootsect /nt60 c:(注意中间有空格哟!)
7、重启电脑,出现“开始安装界面”,(要注意了,不点击“现在安装”)点左下角“修复计算机”(repair you computer),进入"系统恢复选择",选择最后一项"命令提示符"(command prompt),进入DOS窗口。
     输入:xcopy   D:\W7\boot   C:\boot
     再输入:xcopy   D:\W7\boot\bootsect.exe   C:   (此bootsect.exe为64位)
8、重启电脑,出现“开始安装界面”,(要注意了,不点击“现在安装”)点左下角“修复计算机”(repair you computer),进入"系统恢复选择",选择最后一项"命令提示符"(command prompt),进入DOS窗口。
先格式化C盘:执行格式化命令format c:/q(注:如C盘是FAT32格式,想转NTFS格式的话,执行format c:/fs:ntfs)。
输入:D:\W7\sources\setup.exe  开始安装!!!