|
|
August 11 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). Self-extracting executables: August 02 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 Developer: PTTFM-X467G-P7RH2-3Q6CG-4DMYB
Enterprise: JD8Y6-HQG69-P9H84-XDTPG-34MBB 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 单击下列其中一个链接，下载相应的文件，然后运行下载的文件来安装该包。
每个包均指示了其适用的用户，如下所示： 客户：个人可能需要安装此包，以获取其他许可功能，如互操作性。
伙伴：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.0 和 Microsoft 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 VS2010 RTM VS2010 CD-KEY YCFHQ-9DWCY-DKV88-T2TMH-G7BHP July 21 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 开始安装！！！ July 16 一. SAP进程概览: 说明： - Dispatcher在分配进程前，用户的请求将放置在RequestQueues中等待；
- 每个实例的Dispatcher由中心实例的Message Server统一调配；
- 每个Dialog请求尽可能地被分配给空闲的工作进程；
- 如果一个事务调用一个以上的屏幕，系统dialogsteps将指派给不同的工作进程；
- 工作进程本身不执行数据库的操作，所有数据库的操作将由特定的DB接口由数据库进程实现。
二. SAP进程类型和监视: 说明： - 工作进程的类型：DIA = Dialog, UPD = Update, ENQ = Enqueue, BGD= Background, UP2= Update V2, SPO = Spool；
- 执行事务代码RZ10可以调整工作进程的数量，例如:
- rdisp/wp_no_dia = 7
rdisp/wp_no_vb = 2
rdisp/wp_no_vb2 = 1
rdisp/wp_no_enq = 1
rdisp/wp_no_btc = 3
rdisp/wp_no_spo = 1 - 执行事务代码SM50可以监视工作进程的ID，状态，关联的动作，程序等等。
三. SAP应用服务器的进程优化： 说明： - 前提条件：调优后的进程数量，能够满足现有SAP业务的需求；
- 根据客户当前的应用服务器的数量，进行工作进程数量的调优。例如，每个应用服务器负责打印处理的工作进程SPO由以前的5减少为3；
- 满足现有业务需求的条件下：在服务器硬件资源没有更新、升级的情况下，工作进程总数的减少，意味着能够更节约现有的硬件资源，或者说，单进程可支配资源(利用率)的提升。
四. 结论 - 除了分析和调优内存来实现SAP系统的性能调优，工作进程的优化往往被忽视，工作进程的优化需要足够的经验和进行频繁的监视。如果因减少工作进程的数量而无法满足现有的业务需求，将导致不可估量的损失和失败；
科学的配置和使用操作模式(OperationMode)也是作为工作进程优化的一种进阶方法。 June 26 Tutorial: Building a Run-Time Image for the EmulatorThis guide helps you become familiar with Platform Builder and the new functionality of the Windows CE operating system (OS). It provides a step-by-step tutorial for creating and debugging a custom run-time image and a simple application that runs in the Emulator. In this tutorial you create an Enterprise Web Pad running the Hello World application that runs in the Emulator. This tutorial makes the following assumptions: - You have installed Platform Builder and Windows CE as described in the installation instructions.
- You have selected the Emulator as one of the installed CPUs.
- You are familiar with the terms defined in Terminology.
This tutorial takes approximately 50 minutes to complete. In this tutorial, you complete the following steps: Tutorial Step 1: Creating a Custom OS Design for the Emulator In this step, you use the New Platform Wizard to create a custom OS design. To create a custom OS design for the Emulator - On the development workstation, launch the Platform Builder application.
- From the File menu, choose New Platform, and when the New Platform Wizard appears, choose Next.
- In the Name box, enter MyOSDesign as the name for your OS design.
- In the Path box, enter or select the path to the root directory where you want your OS design to be located; then choose Next.
For this tutorial, accept the default location, which is %_WINCEROOT%\PBWorkspaces\MyOSDesign. - From the list of available board support packages (BSPs) installed on your development workstation, select EMULATOR: X86 and choose Next.
- From the list of available OS design templates, select Enterprise Web Pad and choose Next.
- Accept the default selections for Applications & Media by choosing Next.
- Accept the default selections for Networking & Communications by choosing Next.
- Acknowledge the Special Notifications by choosing Next.
- Save your settings and close the New Platform Wizard by choosing Finish.
Platform Builder creates two configurations for your OS design: - A Debug configuration
- A Release configuration
After these files are created, you now build a custom run-time image. Tutorial Step 2: Building the Custom Run-Time Image for the Emulator After you create an OS design, you can build a run-time image based on that OS design. In this step, you build a custom run-time image from the OS design you created in Tutorial Step 1. For this tutorial, when you build the custom run-time image, choose a Debug configuration for your OS design. By building a run-time image based on the default Debug configuration, you can later debug your run-time image on the target device from Platform Builder. In addition, because the size of a run-time image based on a Debug configuration is greater than the size of a run-time image based on a Release configuration, you must also change the value of an environment variable to accommodate a larger run-time image. To build the custom run-time image for the Emulator - From the Platform Builder Build OS menu, choose Set Active Configuration.
- From the list of configurations, select EMULATOR: X86_Debug and choose OK.
Platform Builder updates the list of Catalog items in your OS design. - From the Platform menu, choose Settings.
- In the Configuration list, be sure EMULATOR: x86_Debug is selected.
- Choose the Build Options tab and verify that the following check boxes are selected:
- Close the Platform Settings dialog box and save your changes by choosing OK.
- Choose the Build OS menu and verify that the following are selected:
- Copy Files to Release Directory after Build
- Make Run-Time Image After Build
By default, these are selected when you create a workspace in Platform Builder. - To build a run-time image based on your OS design, from the Build OS menu, choose Build and Sysgen.
For information about other build options you can choose, see Build OS Menu Options. The time required by Platform Builder to build the run-time image depends on the number of Catalog items in the OS design. In this example, you are building a run-time image based on a large OS design that contains many items, so it can take up to 20 minutes to build the OS image. - Observe the build process in Platform Builder by viewing the output on the Build tab of the Output window.
When the build is complete, you see the following message: MyOSDesign - 0 error(s), XX warning(s). You can now set up a connection to the Emulator and download the run-time image. Tutorial Step 3: Setting Up a Connection to the Emulator and Downloading the Run-Time Image In this step, you set up and configure a connection to the Emulator; then you download the custom run-time image to the Emulator. To set up a connection to the Emulator and download the run-time image - From the Target menu, choose Connectivity Options.
- Under Service Configuration, choose Kernel Service Map.
- From the Download list box, choose Emulator.
- Choose the associated Settings button.
- Be sure the settings for Display are set to 640x480x16; otherwise, the Emulator window might not appear properly on your display.
- In the Memory (MB) box, be sure memory is set to 64 and then choose OK.
- From the Transport list box, select Emulator.
- From the Debugger list box, be sure KdStub is selected.
- Under Service Configuration, choose Core Service Settings.
- Under Download Image, verify that Always is selected.
- Under KITL Settings, verify that the following check boxes are selected:
- Enable KITL on device boot
- Clear memory on soft reset
- Enable access to desktop files
- To save your changes and close the dialog box, choose Close.
- or - To save your changes and keep the dialog box open, choose Apply. You have configured the services that allow you to connect to the Emulator. Now you can establish a connection to the Emulator and download the run-time image. - From the Target menu, choose Attach Device.
A window appears, displaying the progress of the download to the Emulator. Then the MyOSDesign - Emulator for Windows CE window appears. - Wait until the OS appears in the MyOSDesign - Emulator for Windows CE window.
The length of time required to display the OS depends on the size of the run-time image being downloaded. For this tutorial, the OS appears in about a minute. While the run-time image is being downloaded, in Platform Builder, you can see intermittent activity in the Debug tab of the Output window. When the OS boots successfully, the Windows CE OS appears in the MyOSDesign - Emulator for Windows CE window. You can now debug the OS. Tutorial Step 4: Debugging the OS on the Emulator Using the Kernel Debugger After you download and boot the run-time image in the Emulator, you can debug the OS. By default, when the OS boots, Platform Builder starts the kernel debugger and displays the Debug toolbar. To debug the run-time image, you must halt the running OS, because breakpoints cannot be set while the OS is running. You then use the kernel debugger to debug your custom OS. To debug the OS on the Emulator using the kernel debugger - From the Platform Builder Debug menu, choose Break.
This halts the running OS on the Emulator, which does not respond to user input while in this state. - From the File menu, choose Open.
- Browse to %_WINCEROOT%\Platform\Emulator\Src\Drivers\Kbdmouse\Emulkbms, select ps2mouse.cpp, and then choose Open.
You have opened the Ps2mouse.cpp file, which contains source code for the mouse driver. - From the Edit menu, choose Find.
- In the Find what box, type _move and choose Find Next.
You jump to a section of code in the Ps2mouse.cpp file that handles a mouse move event. - Set a breakpoint in the source code at the mouse move event by pressing the F9 key.
A red dot in the margin shows that the breakpoint has been set. - From the Debug menu, choose Go.
- In the MyOSDesign - Emulator for Windows CE window, move the cursor over the window.
The breakpoint activates. - Switch to the Platform Builder window.
A yellow instruction point or current instruction arrow on the breakpoint symbol appears in the source code. - Remove the breakpoint you set by doing one of the following:
- From the Debug toolbar, choose Breakpoints and then choose Clear All Breakpoints.
- In the source code, right-click the line where you set the breakpoint; then from the context menu, choose Remove Breakpoint.
- Use the ALT+9 keyboard shortcut to access the Breakpoint List window; then choose Clear All Breakpoints.
- From the Debug menu, choose Go.
You have successfully halted the OS, set and activated a breakpoint in one of the drivers, and then removed the breakpoint. Follow the remaining steps to stop debugging the OS. - From the Debug menu, choose Stop Debugging.
- From the Target menu, choose Detach Device.
- Shut down the Emulator by accessing the window for the Emulator; then from the Emulator menu, choose Shut Down.
The Emulator window closes. After you finish debugging, you can localize your run-time image. Tutorial Step 5: Localizing the Run-Time Image for the Emulator Windows CE offers the ability to localize a run-time image into several languages. In this step, you localize the custom Enterprise Web Pad OS design into German for the locale of Germany. To localize the OS design for the Emulator - From the Platform Builder Platform menu, choose Settings.
- In the Configuration box, select EMULATOR: x86_Release.
- Choose the Locale tab.
- From the Default Language list, select German (Germany); then verify that the Localize the build check box is selected.
- Close the Platform Settings dialog box by choosing OK.
- From the Build OS menu, verify that the following options are selected:
- Copy Files to Release Directory After Build
- Make Run-Time Image After Build
- From the Build OS menu, choose Build and Sysgen.
It can take up to 20 minutes to rebuild the run-time image with the changed build options you selected. When the build process is complete, you see the following message: MyOSDesign - 0 error(s), XX warning(s). - From the Target menu, choose Attach Device.
In approximately one minute, the localized run-time image finishes downloading to the Emulator. - In the MyOSDesign - Emulator for Windows CE window, verify that the icons in the displayed OS are labeled in German.
- From the Platform Builder Target menu, choose Detach Device and then choose OK.
- In the window for the Emulator, from the Emulator menu, choose Shut Down.
You have created, built, and downloaded a localized run-time image. You can now create and build an application based on your run-time image. Tutorial Step 6: Creating and Building an Application for the Emulator In this step, you create and build a simple application using Platform Builder. To create and build an application for the Emulator - From the Platform Builder File menu, choose New Project or File.
- Choose the Projects tab and select WCE Application.
- In the Project name box, type Hello, verify that Workspace project is selected, and choose OK.
- In the Feature name box, for the purposes of this tutorial, name your application Hello and choose Next.
This name is used in the Readme.txt file that Platform Builder creates, and is optional. - Choose A typical "Hello World!" application and then choose Finish.
- In the Workspace window, select the FileView tab; then from the Projects node, select your application.
- From the Build Project menu, select the following:
- Clean Before Building
- Make Run-Time Image After Build
- Build the application by choosing Build Current Project from the Build Project menu.
When the build is complete, in the Build window, you see the following message: Hello.exe - 0 error(s), 0 warning(s). To see this message, you might need to jump to the end of the output by pressing the CTRL and END keys simultaneously. You have created an application. You can now run the application in the Emulator. Tutorial Step 7: Running the Application in the Emulator on the Custom Run-Time Image In this step, you run the newly created Hello.exe application in the Emulator. By default, Hello.exe is not included in the run-time image. It is downloaded to the target device from the development workstation at run time. This allows you to further develop the application without rebuilding the run-time image after each change you make to the application. To run the application in the Emulator on the custom run-time image - From the Platform Builder Target menu, choose Attach Device.
In approximately two minutes, your localized OS appears in the MyOSDesign - Emulator for Windows CE window. - From the Target menu, choose Run Programs.
- In the Available Programs list, select Hello.exe and choose Run.
The Hello.exe application downloads from the development workstation to the Emulator. The application then runs in the Emulator. - In the MyOSDesign - Emulator for Windows CE window, verify that the Hello.exe application has run successfully..
You have run a custom application on the Emulator. - Shut down the Emulator so you can create and export a software development kit (SDK):
- From the Platform Builder Target menu, choose Detach Device.
- In the window for the Emulator, from the Emulator menu, choose Shut Down.
You can now create and export an SDK. Tutorial Step 8: Creating an SDK for eMbedded Visual C++ After you customize your OS design and boot and debug the run-time image, you can use Platform Builder to create, configure, and build an SDK for the run-time image. Developers can use this SDK to create applications based on the run-time image you created. In this step, you create an SDK for Microsoft® eMbedded Visual C++®. To create and build an SDK for eMbedded Visual C++ - From the Platform Builder Platform menu, choose SDK and then choose New SDK.
- When the SDK Wizard appears, choose Next.
- In the Product name that is displayed when .msi file runs box, type MyOSDesignSDK.
- In the Manufacturer name box, type MyCompany, and then choose Next.
- Verify that the eMbedded Visual C++ 4.0 support check box is selected, and then choose Next.
- On the final page, choose Close this wizard and continue configuring your SDK.
The wizard closes and the SDK Settings dialog box opens. - In the SDK Settings dialog box, choose the EULA/Readme tab and select the Include custom end-user license agreement check box.
- In the End-user license agreement path box, enter the location and name of a file as a Rich Text Format (.rtf) file that you want to use as a sample custom End User License Agreement (EULA).
- or - Choose Browse, select an .rtf file that you want to use as a sample EULA, and then choose Open. The custom EULA you include is displayed in a separate dialog box when the SDK is installed. - Choose the Emulation tab, and then, in the Configuration field, verify that you have selected a build configuration for your SDK.
For this tutorial, select a Debug configuration. Selecting a Debug configuration may help prevent errors from occurring when you build your SDK. - Choose OK to close the window and apply the settings to your SDK.
- From the Platform menu, choose SDK and then choose Build SDK.
The SDK Wizard dialog box displays information while the SDK is being built. - When the build is complete, to close the dialog box, choose Done.
Your SDK is in the MyOSDesign_SDK.msi file in the %_WINCEROOT%\PBWorkspaces\MyOSDesign\SDK directory. You have completed this tutorial and successfully created and debugged a custom run-time image and a simple application that runs in the Emulator. You have also successfully created an SDK for your run-time image. 1、安装Microsoft Visual Studio 2005
VS2005大家应该都比较容易从网上下载到正式的版本
安装过程如下：如果机器提示缺少什么软件未检测到，去下载个就OK.
2、安装Microsoft Visual Studio 2005 Service Pack 1
微软官方网站下载地址（注意语言要和VS2005的语言一致，我这里都是英文版本） :
英文：
http://www.microsoft.com/downloads/details.aspx?displaylang=en&FamilyID=bb4a75ab-e2d4-4c96-b39d-37baf6b5b1dc
如果是Vista操作系统,在安装完成VS2005 SP1之后,还需要安装Microsoft Visual Studio 2005 Service Pack 1 Update For Windows Vista,在SP1的基础上增加对Vista的支持:
微软官方网站下载地址:
http://www.microsoft.com/downloads/details.aspx?displaylang=en&FamilyID=90e2942d-3ad1-4873-a2ee-4acc0aace5b6
安装好后要配置一下安全配置:
1. 单击 开始单击 运行 ， 键入 控件 secpol.msc , 然后单击 确定 。
2. 双击 本地安全策略。
3. 单击软件限制策略。如果没有软件限制策略，右键单击软件限制策略,然后单击新建策略。
4. 在 对象类型 , 双击 强制 。
5. 单击 除本地管理员以外的所有用户 , 并单击确定 。
6. 重新启动
这样你再打开VS2005你就可以看到asp.net web application了。
3、安装WinCE Platform Builder 6.0
WinCE Platform Builder 6.0 是以VS2005的插件形式安装集成的。 Platform Builder正版是需要向微软或者其代理机构购买的，官方只有评估版本的下载。微软官方网站下载地址：
http://www.microsoft.com/downloads/details.aspx?displaylang=en&FamilyID=7e286847-6e06-4a0c-8cac-ca7d4c09cb56
Your product key(s) for installation are:
* Windows Embedded CE 6.0 (plug-in for Visual Studio 2005):
H8RQR-MMKRP-XFRFC-9HKGJ-82R6J
* If you are also evaluating Visual Studio 2005, Visual Studio 2005 Professional Edition Trial:
M3C9X-9K3Q9-DC8PX-B3YR3-BKQR8
* Other recommended downloads:
Visual Studio 2005 Service Pack 1 Beta
4、安装WinCE Platform Builder 6.0 Service Pack 1
微软官方网站下载地址（56.3MB） ：
http://www.microsoft.com/downloads/details.aspx?FamilyId=BF0DC0E3-8575-4860-A8E3-290ADF242678&displaylang=en
安装完成以上步骤以后，打开VS2k5, 启动界面上我们可以看到Installed Products中增加了一个Platform Builder for CE6.0，说明CE6已经安装成功了，CE6是以add-on的方式安装在VS2k5中的。
安装WinCE 6.0 R2
微软官方网站下载地址：
http://www.microsoft.com/downloads/details.aspx?familyid=F41FC7C1-F0F4-4FD6-9366-B61E0AB59565&displaylang=en
6、安装WinCE 6.0 R3
微软官方网站下载地址：
http://www.microsoft.com/downloads/details.aspx?displaylang=en&FamilyID=bc247d88-ddb6-4d4a-a595-8eee3556fe46
7、安装Microsoft Device Emulator 2.0，
官方下载地址为：http://www.microsoft.com/downloads/details.aspx?FamilyID=dd567053-f231-4a64-a648-fea5e7061303&displaylang=en，2.0版本的模拟器是对VS2k5中默认安装的1.0版本的升级。
8、安装Virtual Machine Network Driver for Microsoft Device Emulator，这个组件保证模拟器的正常运行，如果不安装的话模拟器启动以后是黑屏，
官方下载地址为：http://www.microsoft.com/downloads/details.aspx?FamilyID=dc8332d6-565f-4a57-be8c-1d4718d3af65&DisplayLang=en，这个下载已经被微软关掉了，推荐下载Microsoft Virtual PC 2007，官方下载地址为：http://www.microsoft.com/downloads/details.aspx?FamilyID=04d26402-3199-48a3-afa2-2dc0b40a73b6&DisplayLang=en，但是这里有一个问题，VPC2007能在Windows XP / Vista / Windows Server 2003 Standard上安装而无法在Enterprise上安装，Enterprise上只能装更为高级的Virtual Server 2005。所以在选择操作系统的时候要有所注意。因为我使用的Windows XP操作系认，所以这里直接安装了Virtual PC 2007。
9、接下来要用刚刚安装好的PB定制一个Windows CE 6.0系统，系统定制完成后可以加载到设备模拟器上，以便我们针对这个系统进行开发和测试。打开VS2k5，选择新建一个新安装的OS Design项目模板创建，进入向导页面。
在Board Support Packages中推荐选择Device Emulator: ARMV4I。这是很重要的一步，同时这里要提到一点，设备模拟器是ARM架构的，也就是说x86架构的CE系统是不能在模拟器上运行的，用CEPC: x86定制了一个系统，编译完成后附加到设备模拟器的时候报出错误: Invalid or missing ROM image. 不过选错了也没有关系，在用模板创建完成后仍然可以修改这些选项。
PB提供了一系列可供选择的设计模板，我选择的是PDA Device -> Mobile Handheld，然后一路下一步就可以完成创建，创建的最后一步确定后会弹出一个Catalog Item Notification的对话框，点击Acknolwlege确定，完成创建。Windows CE系统定制的话题会在以后的心得文章中介绍。在Vs2k5菜单中，选择Tools->Device Emulator Manager, 打开设备模拟器管理窗口，里面列出了现在可用的所有虚拟机，例如Pocket PC 2003, Smartphone 2003等，但是我们现在还找不到WINCE6_EMU的模拟器，接下来我们要对定制好的系统进行编译并生成SDK。
9、编译之前要提到一点就是取消KITL（no IMGNOKITL=1），如果不取消这一选项的话在非Debug模式下模拟器是不能启动的。右单击项目名称，选择Properties，在Build options中取消对"Enable KITL(no IMGKITL=1)"的选中。然后就可以进行编译了，编译的时间会相对长一些，取决于定制功能的多少。
编译成功之后，在RelDir对应的目录下生成了一个名为NK.bin的文件，这个文件就是给虚拟机使用的运行时镜像，解下来我们要把编译完成的系统附加到设备。在此之前要对连接属性进行一些设置。打开Vs2k5菜单，选择Target -> Connectivity options, 打开目标设备连接属性对话框，Target Device选择CE Device, Download和Transport都选择Device Emulator (DMA)，Debugger选择None。针对模拟器运行参数的其他设置，比如屏幕尺寸，内存大小等等，都是要在这个对话框中进行设置的.
修改完配置后点击Apply并关闭窗口，在Vs2k5中选择Target->Attach device开始附加到设备，这个时间也会有几分钟，Output窗口中会显示添加的状态，如果输出窗口卡在某一个位置上，模拟器还是黑屏的话，有可能是前面的某一步配置出现问题。需要回过头来检查，模拟器正常启动后，就可以看到一个Windows CE系统的模拟器窗口。
接下来我们要创建并安装SDK，安装SDK的目的是在Vs2k5中提供对目标设备的开发支持，例如类库，模拟器等。在Vs2k5菜单中选择Project -> Add new SDK, 打开SDK属性页。在Emulator中，将Configuration修改为Device Emulator ARMV4I Debug，填写必要的信息后点击确定，然后在项目窗口中右单击刚才创建的SDK，选择编译。编译完成后生成一个msi安装文件，位于OSDesign项目文件夹下，SDKS\<SDKname>目录中。关闭Vs2k5,并击运行这个SDK并安装。
安装完成后，打开Vs2k5，选择菜单Tools -> Device Emulator Manager, 打开设备模拟器管理窗口，我们可以看到WINCE6_EMU下已经添加了我们刚才创建的系统，右单击这个项目选择Connect, 弹出模拟器窗口，CE系统启动成功。
至此已经完成了由PB定制CE6操作系统，生成SDK并安装到开发环境的整个步骤。安装完成后我们便可以在这个定制的CE6平台上开发调试相关的应用程序了。
June 02 在执行下列任一基于服务器的任务时，可能收到“RPC server is unavailable（RPC服务器不可用）”错误信息： • 复制 • Winlogon • 启用受信任的关系 • 连接到域控制器 • 连接到受信任的域 • 用户身份验证 注意：在成员服务器上运行 Dcpromo 时也可能出现“RPC server is unavailable”错误。如果只有一台 DC，并且该 DC 的网卡上没有启用文件和打印机共享，则会发生此问题。原因下列任一原因均可导致发生此问题： • 可能未启动 RPC 服务。 • 无法解析 DNS 或 NetBIOS 名称。 • 无法建立 RPC 通道。 解决方案要解决此问题，请按照下列步骤操作： 1. 单击开始，单击运行，在打开框中键入以下命令行，然后单击确定： net start rpcss 进行测试，查看这是否解决了问题。如果仍然出现此问题，则继续执行下一步。 2. 单击开始，指向程序，指向附件，然后单击命令提示符。 3. 在命令提示符处，键入 ping servername，其中 servername 是要测试其连接的服务器、NetBIOS、DNS 或 GUID 名称。 如果其中的一台计算机存在连接问题，请与网络管理员联系以解决问题。如果仍然出现此问题，则继续执行下一步。 4. 使用 Microsoft Windows 支持工具（包含在 Windows CD-ROM 上）中包含的 Netdiag 工具确定域控制器是否正常工作。可以使用 MSRPC、DNS、NBT、LDAP 或 TCP 协议执行网络跟踪。 如果域控制器存在问题，请与网络管理员联系以解决问题。如果仍然出现此问题，则继续执行下一步。 5. 使用 Windows 支持工具中包含的 Netdom 工具验证网络信任关系，然后重置或建立到服务器的连接。 August 31 <Query>
<Method Namespace="http://tempuri.org" Name="Get_MB52_DATA_XML_01" >
<Parameters>
<Parameter Name="strMaterial_l">
<DefaultValue>FEE1246</DefaultValue>
</Parameter>
<Parameter Name="strMaterial_h">
<DefaultValue>FEE1246</DefaultValue>
</Parameter>
<Parameter Name="strPlant_l">
<DefaultValue>3200</DefaultValue>
</Parameter>
<Parameter Name="strPlant_h">
<DefaultValue>3200</DefaultValue>
</Parameter>
<Parameter Name="strSloc_l">
<DefaultValue>6001</DefaultValue>
</Parameter>
<Parameter Name="strSloc_h">
<DefaultValue>6001</DefaultValue>
</Parameter>
</Parameters>
</Method>
<SoapAction>http://tempuri.org/Get_MB52_DATA_XML_01</SoapAction> </Query> @echo off
tasklist |find /i "saplogon.exe" >check_sap.txt
IF errorlevel 1 ((del /q check_sap.txt)&(echo SAP未執行,準備開啟中...)&(goto end))
IF errorlevel 0 ((del /q check_sap.txt)&(echo SAP已經執行,請不要重復執行)&pause&exit)
:end
"C:\Program Files\SAP\SapSetup\setup\SAL\SapLogon.s8l" August 30 set /p n=firefox set /p t=1 set /a t1=%t%*60 :do tasklist|find /i "%n%" &&goto loop||start "" "d:\a.txt" goto end :loop ping 127.1 -n %t1% >nul goto do :end July 27 Download Speed: 827 kbps (103.4 KB/sec transfer rate)
Upload Speed: 27 kbps (3.4 KB/sec transfer rate)
2009年7月24日 21:08:06 Download Speed: 766 kbps (95.8 KB/sec transfer rate)
Upload Speed: 29 kbps (3.6 KB/sec transfer rate)
2009年7月24日 21:10:40 Download Speed: 635 kbps (79.4 KB/sec transfer rate)
Upload Speed: 18 kbps (2.3 KB/sec transfer rate)
2009年7月24日 21:12:51 Download Speed: 242 kbps (30.3 KB/sec transfer rate)
Upload Speed: 129 kbps (16.1 KB/sec transfer rate)
2009年7月24日 23:15:43 Download Speed: 301 kbps (37.6 KB/sec transfer rate)
Upload Speed: 144 kbps (18 KB/sec transfer rate)
2009年7月24日 23:17:58 Download Speed: 611 kbps (76.4 KB/sec transfer rate)
Upload Speed: 242 kbps (30.3 KB/sec transfer rate)
2009年7月25日 1:04:08 Download Speed: 9615 kbps (1201.9 KB/sec transfer rate)
Upload Speed: 448 kbps (56 KB/sec transfer rate)
2009年7月25日 8:39:35 Download Speed: 686 kbps (85.8 KB/sec transfer rate)
Upload Speed: 419 kbps (52.4 KB/sec transfer rate)
2009年7月25日 8:43:12 Download Speed: 728 kbps (91 KB/sec transfer rate)
Upload Speed: 421 kbps (52.6 KB/sec transfer rate)
2009年7月25日 8:43:54 Download Speed: 614 kbps (76.8 KB/sec transfer rate)
Upload Speed: 249 kbps (31.1 KB/sec transfer rate)
2009年7月25日 8:45:26 Download Speed: 695 kbps (86.9 KB/sec transfer rate)
Upload Speed: 266 kbps (33.3 KB/sec transfer rate)
2009年7月25日 8:46:19 Download Speed: 1665 kbps (208.1 KB/sec transfer rate)
Upload Speed: 315 kbps (39.4 KB/sec transfer rate)
2009年7月26日 23:56:20 Download Speed: 397 kbps (49.6 KB/sec transfer rate)
Upload Speed: 163 kbps (20.4 KB/sec transfer rate)
2009年7月26日 23:57:41 Ethernet adapter 本地连接: Connection-specific DNS Suffix . :
Description . . . . . . . . . . . : Broadcom NetLink (TM) Fast Ethernet
Physical Address. . . . . . . . . : 00-1B-38-04-D1-AB
Dhcp Enabled. . . . . . . . . . . : Yes
Autoconfiguration Enabled . . . . : Yes
IP Address. . . . . . . . . . . . : 10.33.48.96
Subnet Mask . . . . . . . . . . . : 255.255.248.0
Default Gateway . . . . . . . . . : 10.33.48.1
DHCP Server . . . . . . . . . . . : 172.18.12.58
DNS Servers . . . . . . . . . . . : 211.103.13.101
211.138.200.69
Lease Obtained. . . . . . . . . . : 2009年7月24日 21:02:09
Lease Expires . . . . . . . . . . : 2009年7月25日 20:52:55 June 14 1. loop 循环中不要用select. 2. 用inner join时，不要超过3到4个表 用head表 join detail表 3. 数据量大的时候用index，或是视图。 4. select时，where后面的条件多点，3到4个以上。 5. 一般都是先保存到内表，然后操作内表 1、使用where语句 2、使用聚合函数 不推荐 Maxnu = 0. Select * from zflight where airln = ‘LF’ and cntry = ‘IN’. Check zflight-fligh > maxnu. Maxnu = zflight-fligh. Endselect. 推荐 Select max( fligh ) from zflight into maxnu where airln = ‘LF’ and cntry = ‘IN’. 3、使用视图代替基本表查询 不推荐 Select * from zcntry where cntry like ‘IN%’. Select single * from zflight where cntry = zcntry-cntry and airln = ‘LF’. Endselect. 推荐 Select * from zcnfl where cntry like ‘IN%’ and airln = ‘LF’. Endselect. 4、使用INTO table 代替select endselect 不推荐 Refresh: int_fligh. Select * from zflight into int_fligh. Append int_fligh. Clear int_fligh. Endselect. 推荐 Refresh: int_fligh. Select * from zflight into table int_fligh. 5、使用批量修改内表代替逐行修改 不推荐 Loop at int_fligh. If int_fligh-flag is initial. Int_fligh-flag = ‘X’. Endif. Modify int_fligh. Endloop. 推荐 Int_fligh-flag = ‘X’. Modify int_fligh transporting flag where flag is initial. 6、使用二分法查询，提高查询内表数据速度 不推荐 Read table int_fligh with key airln = ‘LF’. 推荐 Read table int_fligh with key airln = ‘LF’ binary search. 7、两个内表添加使用批量增加代替逐行 不推荐 Loop at int_fligh1. Append int_fligh1 to int_fligh2. Endloop. 推荐 Append lines of int_fligh1 to int_fligh2. 8、使用table buffering Use of buffered tables is recommended to improve the performance considerably. The buffer is bypassed while using the following statements Select distinct Select … for update Order by, group by, having clause Joins Use the Bypass buffer addition to the select clause in order to explicitly bypass the buffer while selecting the data. 9、 使用FOR ALL Entries 不推荐 Loop at int_cntry. Select single * from zfligh into int_fligh where cntry = int_cntry-cntry. Append int_fligh. Endloop. 推荐 Select * from zfligh appending table int_fligh For all entries in int_cntry Where cntry = int_cntry-cntry. 10、正确地使用where语句，使查询能使用索引 When a base table has multiple indices, the where clause should be in the order of the index, either a primary or a secondary index To choose an index, the optimizer checks the field names specified in the where clause and then uses an index that has the same order of the fields. One more tip is that if a table begins with MANDT, while an index does not, there is a high possibility that the optimizer might not use that index. 11、正确地使用MOVE语句 Instead of using the move-corresponding clause it is advisable to use the move statement instead. Attempt should be made to move entire internal table headers in a single shot, rather than moving the fields one by one. 12、正确地使用inner join Let us take an example of 2 tables, zairln and zflight. The table zairln has the field airln, which is the airline code and the field lnnam, which is the name of the airline. The table zflight has the field airln, the airline code and other fields which hold the details of the flights that an airline operates. Since these 2 tables a re logically joined by the airln field, it is advisable to use the inner join. Select a~airln a~lnnam b~fligh b~cntry into table int_airdet From zairln as a inner join zflight as b on a~airln = b~airln. In order to restrict the data as per the selection criteria, a where clause can be added to the above inner join. 13、使用sort by 代替order by 15、使用select 字段列表代替 Select * 不推荐 SELECT * FROM DD01L INTO DD01L_WA WHERE DOMNAME LIKE ‘CHAR%’ AND AS4LOCAL = ‘A’. ENDSELECT. 推荐 SELECT DOMNAME FROM DD01L INTO DD01L_WA-DOMNAME WHERE DOMNAME LIKE ‘CHAR%’ AND AS4LOCAL = ‘A’. ENDSELECT. 16、使用subquery代替多个select语句 不推荐 SELECT * FROM SPFLI INTO TABLE T_SPFLI WHERE CITYFROM = ‘FRANKFURT’ AND CITYTO = ‘NEW YORK’. SELECT * FROM SFLIGHT AS F INTO SFLIGHT_WA FOR ALL ENTRIES IN T_SPFLI WHERE SEATSOCC < F~SEATSMAX AND CARRID = T_SPFLI-CARRID AND CONNID = T_SPFLI-CONNID AND FLDATE BETWEEN ‘19990101′ AND ‘19990331′. ENDSELECT. 推荐 SELECT * FROM SFLIGHT AS F INTO SFLIGHT_WA WHERE SEATSOCC < F~SEATSMAX AND EXISTS ( SELECT * FROM SPFLI WHERE CARRID = F~CARRID AND CONNID = F~CONNID AND CITYFROM = ‘FRANKFURT’ AND CITYTO = ‘NEW YORK’ ) AND FLDATE BETWEEN ‘19990101′ AND ‘19990331′. ENDSELECT. 17、如何快速删除重复内表的记录 不推荐 READ TABLE ITAB INDEX 1 INTO PREV_LINE. LOOP AT ITAB FROM 2 INTO WA. IF WA = PREV_LINE. DELETE ITAB. ELSE. PREV_LINE = WA. ENDIF. ENDLOOP. 推荐 DELETE ADJACENT DUPLICATES FROM ITAB COMPARING K. 18、如何快速删除内表一定范围内的记录 不推荐 DO 101 TIMES. DELETE ITAB INDEX 450. ENDDO. 推荐 DELETE ITAB FROM 450 TO 550. 19、使用collect语句代替人工合计计算结果 不推荐 LOOP AT ITAB1 INTO WA1. READ TABLE ITAB2 INTO WA2 WITH KEY K = WA1-K BINARY SEARCH. IF SY-SUBRC = 0. ADD: WA1-VAL1 TO WA2-VAL1, WA1-VAL2 TO WA2-VAL2. MODIFY ITAB2 FROM WA2 INDEX SY-TABIX TRANSPORTING VAL1 VAL2. ELSE. INSERT WA1 INTO ITAB2 INDEX SY-TABIX. ENDIF. ENDLOOP. 推荐 LOOP AT ITAB1 INTO WA. COLLECT WA INTO ITAB2. ENDLOOP. SORT ITAB2 BY K. 20、使用显示的work area 代替默认的work area 不推荐 ITAB = WA. APPEND ITAB. 推荐 APPEND WA TO ITAB. 21、使用LOOP …ASSIGNING代替loop … modify. 不推荐（整条记录更新） LOOP AT ITAB INTO WA. I = SY-TABIX MOD 2. IF I = 0. WA-FLAG = ‘X’. MODIFY ITAB FROM WA. ENDIF. ENDLOOP. 推荐（只会更新需要修改内容） LOOP AT ITAB ASSIGNING . I = SY-TABIX MOD 2. IF I = 0. -FLAG = ‘X’. ENDIF. ENDLOOP. March 22 《萨班斯法案》（Sarbanes-Oxley Act，简称SOX法案） SOX法案规定： ●禁止向本公司董事或高管人员提供私人贷款； ●公司高管、董事或者受益权人10％的股权变动必须在两个营业日内披露； ●在养老金计划管制期内，公司的董事和高层管理人员不能直接或间接交易持有的该公司股票或从中获益的其他行为； ●对于有违反证券法规情节的有关人士，美国证监会可以禁止他们担任公司的管理人员或者董事等。 再建立上市公司高管人员责任追究机制 1.明确CEO/CFO的会计责任 SOX法案要求在上市公司公开披露的信息中，须附有首席执行官（CEO）和首席财务主管（CFO）的承诺函，保证所提交的定期信息披露报告的真实性。此前，美国的上市公司定期信息披露并不需要CEO/CFO签字，因此一旦其上市公司的财务丑闻被揭发，其CEO/CFO往往以自己不知情来开脱个人的法律责任；由于专业性强，程序复杂，一般也很难找到直接证据来证明CEO/CFO明知或故意披露虚假财务信息。结果，美国无罪推定的司法原则使监管部门经常无计可施。 SOX法案规定： ●上市公司所有定期报告(包括公司依照1934年证券交易法规定编制的会计报表)应附有公司首席执行官与首席财务官签署的承诺函； ●承诺函中的内容包括：确保本公司定期报告所含会计报表及信息披露的适当性，并且保证此会计报表及信息披露在所有重大方面都公正地反映了公司的经营成果及财务状况。 这样一来，监管者即使找不到或者不再需要寻找财务欺诈的直接证据，也可以要求其CEO/CFO本人承担法律责任。 2.要求公司CEO/CFO本人承担不当行为的法律责任 此前，在那些造成重大危害的上市公司财务欺诈事件中，公司CEO/CFO本人仅面临个人职业声誉下降（Reputation Risk）的威胁；即使监管者对其采取种种处罚措施，这些惩罚可能也会以各种方式转嫁给上市公司负担，却难以对CEO/CFO本人形成有效威慑。 SOX法案此次直接明确了公司CEO/CFO本人面临的法律责任，为监管机构查处财务欺诈提供了强有力的法律武器，弥补了监管体系上的漏洞，使公司的激励机制与责任追究机制达成某种平衡。 SOX法案规定： ●在公司定期报告中若发现因实质性违反监管法规而被要求重编会计报表时，公司的CEO/CFO应当返还给公司12个月内从公司收到的所有奖金、红利，其他形式的激励性报酬以及买卖本公司股票所得收益； ●如果公司CEO/CFO事先知道违规事项，但仍提交承诺函，最多可以判处10年监禁，以及100万美元的罚款； ●对于故意做出虚假承诺的，最多可以被监禁20年并判处500万美元的罚款。 强化内外制衡 安然事件的引爆，并非始于监管机构的稽查行动，而是市场投资机构（主要是对冲基金等）对安然公司的信息披露产生怀疑，即向公司管理层提出一连串的问题要求予以澄清，并大量抛空安然股票所致。因此可以说，提高信息披露义务、加强信息披露，是各国对上市公司进行监管的基本手段。 但是一般而言，如何使投资者获得全面、准确、有用的信息以便作出正确的投资决策，并形成对上市公司的监管，还是一个难题。尽管在上市公司信息披露的有关制度方面，美国走在世界前沿，但是SOX法案依然提出了更高的要求，似乎有点矫枉必须过正的味道。 SOX法案规定： ●进一步缩短财务报告披露的滞后期，提高及时性。其中，未来3年内，年度报告由90天缩短为60天；季度报告由45天缩短为35天。年报及季报都需要注册会计师的审计。 ●强化上市公司内控及报告制度，要求公司年度报告中提供“内部控制报告”，说明公司内部控制制度及其实施的有效性，“内部控制报告”要出具注册会计师的意见； ●提高对公司信息披露可用性的要求，包括定期报告中披露所有的资产负债表外交易、财务状况的预测性信息、高层财务人员的道德守则、所有由注册会计师出具的实质性的纠正调整、临时报告中公司财务状况或财务经营状况的实质性变化等。 加强内部独立监督能力 与我国上市公司不同，美国上市公司内部设有审计委员会，但不设立监事会。审计委员会的职责是监督该公司的会计及财务报告程序，以及审计该公司的财务报告。2002年上市公司系列财务丑闻表明，公司的审计委员会没有发挥应有的作用，甚至形同虚设。 SOX法案规定： ●为保证独立性，审计委员会必须完全由“独立董事”组成，独立董事不得是公司或者其子公司的关联人士，其中至少一人应是财务专家；独立董事不得从公司中接受任何咨询、顾问费或者其他酬金; ●公司聘用会计师事务所及报酬方式要由审计委员会批准，并接受审计委员会的监督；会计师事务所在审计过程中遇到的重大事项必须及时报告审计委员会； ●为保证审计委员会能够及时发现公司的会计和审计问题，还需要建立一套处理举报或投诉的工作程序以及相应的监测系统、反应机制。 SOX法案所提出的措施，是否能确保对会计、审计及公司高官人员的监督，还需要实践检验。但是会计审计本身的专业性较强，即使由审计委员会进行监督，还是能够给注册会计师留有一定的操作空间。 杜绝注册会计师利益瓜葛 美国上市公司的连锁会计丑闻，已使有关会计师事务所深陷其中。然而，负有审计责任的会计师事务所不但没有履行职责，五大会计师事务所之一的安达信甚至为虎作伥，帮助安然销毁证据。 实际上，美国证监会在很早以前就注意到并着手开始纠正会计师事务所与被审计公司之间存在的利益瓜葛问题。例如：若一个事务所长期服务于同一客户，就有可能和客户发生复杂的利害关系，它们会在进行审计业务的同时，再提供企业咨询等非审计业务。而非审计业务的收益，很可能会超过审计业务等。 前任美国证监会主席阿瑟·莱维特曾经力主：所有会计师事务所的审计业务与咨询业务必须分拆。但此建议曾遭到五大会计师事务所的抵制。对此，SOX法案授予美国证监会一柄尚方宝剑，严格限制会计师事务所那些可能产生利益冲突的做法。 SOX法案规定： ●禁止会计师事务所在进行审计业务的同时提供非审计业务。其中，明确列举了8类不适当业务被禁止，并授权美国证监会的会计监督委员会可以根据情况对其他类业务作出禁止规定。 ●强制实行注册会计师定期轮换制。规定会计师事务所的主审会计师，或者复核审计项目的会计师，为同一公司连续提供审计服务不得超过5年。 ●限制注册会计师去被审公司任职。公司的现任CEO/CFO等高管人员，若在一年内曾经受雇于会计师事务所并参与该公司有关的审计工作，则该事务所不得再担任该公司的审计工作。 ●实行会计师事务所注册备案制度。从事上市公司审计业务的会计师事务所，必须在会计监督委员会进行注册，并且要定期更新注册信息。 ●针对安达信销毁审计档案的问题，SOX法案还规定：注册会计师有保管审计工作底稿的责任。要求会计师事务所审计上市公司的工作底稿至少保存7年。 由于此项措施的强制性，到目前为止，五大会计师事务所已经基本完成审计和咨询业务的分拆。例如毕马威的咨询业务分拆为毕博咨询；普华永道的咨询业务分拆后被IBM收购；因为分拆较早，从安达信分拆出来的埃森哲咨询得以从安然事件中幸免。 会计师行业由自律改为监管 以往，美国注册会计师行业的监管与服务职能都集中在美国注册会计师协会（AICPA）。然而，证券市场的系列会计丑闻，已使注册会计师行业自律的有效性遭到空前质疑。 实际上，美国注册会计师协会是依靠会员会费的资助在维持运作，所以少数大型会计师事务所对协会的影响很大，使协会不可避免地会自发维护注册会计师的利益。因此，仅依靠协会自律，很难杜绝丑闻再度发生。 SOX法案规定： ●要求美国证券交易委员会（SEC）成立上市公司会计监督委员会(PCAOB)，而原来由AICPA行使的对注册会计师行业的监管职能，则交给更具公共职能的PCAOB。 ●PCAOB由五人组成，直接归美国证监会管辖，但不属于其内部雇员。为消除注册会计师事务所对其的影响，该委员会的运行经费不再由会计师事务所承担，而是改为由上市公司分担； ●美国证监会授权该委员会制定审计准则、会计师事务所注册权、日常监督权、调查和处罚权；检查和处理上市公司与会计师之间的会计处理分歧。 尽管此前在《1934年证券交易法》中已明确：制定上市公司会计准则的权限属于美国证监会。但是，由于政府机构的效率、经费、专业人才等方面的不足，更由于对行业自律的有效性存在幻想，美国证监会一度将会计准则的制定权代理给了民间自律机构。 SOX法案要求美国证监会对这个问题进行纠正，并向国会报告有关情况。 确保证券分析师的客观性和独立性 美国证券市场系列会计丑闻中，除了注册会计师外，证券公司在其中也扮演了不光彩的角色。尤其证券公司内部投资银行部门和证券分析师相互勾结，发布虚假分析报告，操纵市场价格，误导投资者。此类情况被揭发后，证券公司面临大量的法律诉讼和监管部门的处罚。 SOX法案规定： ●要求美国证监会SEC制定相关的规定和细则，以避免证券分析师在其研究报告或公开场合向投资者推荐股票时“见利忘义”，以提高研究报告的客观性，向投资者提供更为有用和可靠的信息。规定的内容包括：禁止公开发布由经纪人和交易商雇佣的从事投资银行业务的人员所提供的研究报告，以及非直接从事投资研究的人员提供的研究报告；由经纪人和交易商雇佣的非从事投资银行业务的官员负责对证券分析师的监管和评价；要求经纪人和交易商，以及他们雇佣从事投资银行业务的人员，不得因证券分析师对发行人证券提出了不利的或相反的研究结论，并因该结论影响到经纪人、交易商同发行人的关系而对证券分析师进行报复和威胁； ●规定一定期限内担任或即将担任公开发行股票承销商或坐市商(dealers)的经纪人和交易商不得公开发布关于该股票或发行人的研究报告； ●在执业的经纪人和交易商内部建立制度架构体系，将证券分析师划分为复核、强制(pressure)、监察等不同的工作部门，以避免参与投资银行业务的人员存有潜在的偏见； ●要求证券分析师、经纪人和交易商在研究报告公布的同时，披露已知的和应当知晓的利益冲突事项。 SOX法案还注意到纠正各种干扰证券分析人员独立性的问题，例如来自公司内部投资银行部门的威胁利诱等。 加强刑事处罚 由于上市公司会计丑闻给投资者造成极大损失，人们迫切要求将犯罪分子绳之以法。因此，除了对CEO/CFO的处罚规定外，SOX法案中还制定了严厉处罚证券犯罪的法规。 SOX法案规定： ●任何人通过信息欺诈或价格操纵在证券市场获取利益，最多可监禁25年或处以罚款；对违法的注册会计师可被判处10年以下监禁或罚款； ●延长了对证券欺诈的追诉期，起诉时间可以延长至非法行为发现的两年内，或者非法行为实施后的五年内； ●新的规定将保护公司检举揭发的员工，对举报者进行打击报复的，最高可判处10年监禁，还规定了对举报者的具体的补偿措施，比如恢复职务、补发报酬及其他损失等。 SOX法案是匆忙出台的产物，这与美国特定的政治背景有关。 从目前情况看，SOX法案提出的措施，对于稳定美国股市起到了一定作用。但要使投资者全面恢复信心，解决证券市场深层次的问题，还需要一定的时间，也并非制定几条法律法规那么简单。 SOX法案即《萨班斯-奥克斯莱法案》 又称《2002年公众公司会计改革和投资者保护法》。美国国会为纠正2001年安然事件后爆发的连串上市公司会计丑闻，恢复投资者对股票市场的信心，推出此亡羊补牢之举。该法案于2002年7月由美国总统布什签署发布。 SOX法案主要针对公司财务丑闻中揭露出来的问题，修补完善了《1933年证券法》和《1934年证券交易法》的有关章节。 测试结果: 长颈鹿
知性优雅,默默等待爱情
长颈鹿是位冷静的思考者,这类型的人知性而优雅,喜欢研究问题,为人成熟稳
重,进退自如,绝不会做出令人大跌眼镜的事情来,人缘不错,大家都很喜欢你,不
管遇到什么状况,你都能冷静处理,但也因为在一些小地方上过於保守,可能会白白
错失不少机会,当机会降临时可要抓牢哦!
【如何排除人际烦恼】
你从不会拒绝别人的请求,不管身边的朋友拜托你做什么,你都欣然接受,这样一
来,很容易把自己累坏哦!别人喜欢依赖你,而你却找不到可以依赖的人,你必须向
别人请求支援才能为自己减压。
【对异性的态度】
你很少主见主动追求别人,你好像一直在默默等待有缘人的出现哦!过於温吞的个性
是你恋爱路上的绊脚石,你必须积极行动起来才能牢牢抓住手中的红线。
【职业预测】
你的理性和知性,适合做心理谘询师、访谈专员、顾问等。
|
Tools 