13518219792
李昆，SQL
创新互联专注于达坂城企业网站建设,响应式网站设计,成都做商城网站。达坂城网站建设公司,为达坂城等地区提供建站服务。全流程按需策划，专业设计，全程项目跟踪，创新互联专业和态度为您提供的服务
SERVER2000课程设计案例精编，北京：中国水利水电出版社，2006
何文华,
SQL
Server
2000
应用开发教程，北京：电子工业出版社出版，2007
仝春灵，数据库原理与应用—SQL
Server
2000，北京：电子工业出版社，20
够了吧
哎~都是被毕业论文逼得
管理系统参考文献
文献意思为有历史意义或研究价值的图书、期刊、典章。以下是我整理的管理系统参考文献，希望对大家有所帮助。
档案管理系统设计方面的参考文献
[1] 刘洪峰,陈江波.网络开发技术大全[M].人民邮电出版社,2005：119-143.
[2] 程成,陈霞.软件工程[M].机械工业出版社,2003：46-80.
[3] 舒红平.Web 数据库编程-Java[M].西安电子科技大学出版社,2005：97-143.
[4] 徐拥军.从档案收集到知识积累[M].是由工业出版社,2008：6-24.
[5] 纪新.转型期大型企业集团档案管理模式研究[D].天津师范大学,2008：46-57.
[6] 周玉玲.纸质与电子档案共存及网络环境电子档案管理模式[J].中国科技博览,2009：44-46.
[7] 张寅玮.甘肃省电子档案管理研究[D]. 兰州大学,2011:30-42
[8] 惠宏伟.面向数字化校园的档案信息管理系统的研究与实现[D]. 电子科技大学,2006:19-33
[9] 刘冬立.基于 Web 的企业档案管理系统的设计与实现[D].同济大学,2007:14-23
[10]钟瑛.浅议电子文件管理系统的功能要素[J]. 档案学通讯,2006:11-20
[11] 杜献峰 . 基于三层 B/S 结构的档案管理系统开发 [J]. 中原工学院学报,2009:19-25
[12]林鹏,李田养. 数字档案馆电子文件接收管理系统研究及建设[J].兰台世界,2008:23-25
[13]汤星群.基于数字档案馆建设的两点思考[J].档案时空,2005:23-28
[14]张华丽.基于 J2EE 的档案管理系统设计与实现[J].现代商贸工业. 2010:14-17
[15]Gary P Johnston,David V. Bowen.he benefits of electronic recordsmanagement systems: a general review of published and some unpublishedcases. RecordsManagement Journal,2005:44-52
[16]Keith Gregory.Implementing an electronic records management system: Apublic sector case study. Records Management Journal,2005:17-21
[17]Duranti Luciana.Concepts , Principles , and Methods for the Management of Electronic RecordsR[J].Information Society,2001：57-60.
[18]Lynn C Westney.Intrinsic value and thepermanent record the preservation conundrum[M].International digital library perspectives,2007：34-89.
[19]Aleksej Jerman Blai.Long-term trustedpreservation service using service interaction proto-col and evidence records[J].Computers and Standards,2007：23-29.
[20]Carmela Troncoso.Improving Secure Long-Term Archival of Digitally Signed Documents[M].Proceedings of the4th ACM international workshop on Storage secu-rity and survivability,2008：102-134.
[21]Elizabeth Yakel.Adoption and Diffusionof Encoded Archival Description[M].Journal Of The AMERICAN Society For Information Science And Technology,2005：99-167.
[22]Carol Smith.Encoded Archival Context : Authority Control For Archives[M].Info 663-techprocesses in libraries,2006：24-56.
[23]Victor E Pollak.Effect of electronic pa-tient record use on mortality in End Stage RenalDisease , a model chronic disease : retrospective anal-ysis of 9 years of prospectively collected data[M].BMCMedical Informatics and Decision Making,2007：99-123.
[24]Surithong Srisa-ard.Digital Heritage : Applying Digital Imaging to Cultural Heritage[M].Online Information Review[J],2007：33-46.
[25]Shien-Chiang Yu.Building an open archive union catalog for digitalarchives. Emerald[D] , 2005:17-27
酒店管理系统参考文献
[1]彭伟民.基于需求的酒店管理系统的建模与实现.微机发展，2005.10.1-6.
[2]翟广宇.基于C/S结构的酒店管理系统. 兰州工业高等专科学报,2004.6.2-4.
[3]薛华成.管理信息系统[M].清华大学出版社,1996.7.2-5.
[4]候炳辉,刘世峰.信息管理系统[J].信息管理系统分析,2004.5:254-562.
[5]童德利,田娟,谢琪,陈世福.基于B/S模式的构件式酒店管理信息系统的设计与实现.2003.4.1-4.
[6]刘学明.饭店客房管理[M].广东旅游出版社，2000.10.1-6.
[7]张亚东.酒店企业销售管理信息系统的设计与实现[J].管理信息系统, 2000.9:45249.
[8]李朝晖.PowerBuilder开发实例完全剖[J].PowerBuilder10.2006:122-189.
[9]萨师煊,王珊.数据库系统概论[M].高等教育出版社,2000.7:21-347.
[10]马秀莲,高志安.宾馆管理系统的设计.黑龙江八一农垦大学信息技术学院,2005.2.1-3.
学籍管理系统论文参考文献：
[1]管建军.软件工程[M].武汉：武汉大学出版社，2007.
[2]梅书荣.钢铁企业销售物流管控系统开发研究[J].计算机工程与科学，2011，33(1)：177-178.
[3]曲培新，庞永庆.Java项目开发案例精粹[M].北京：电子工业出版社，2010.
[4]陆迟.Java语言程序设计[M].2版，北京：电子工业出版社，2005.
[5]刘辉.零基础学sqlserver2005[M].北京：机械工业出版社，2008.
[6]王珊，萨师煊.数据库系统概论[M].4版，北京：高教出版社，2007.
[7]胡立坤.一种实验室综合管理系统的开发与实践[J].计算机测量与控制与科学，2010，18：1417-1419.
学籍管理系统论文参考文献：
[1]易和平.分布式多数据库高校学籍管理系统研究与应用[J].西安石油大学学报：自然科学版，2009，(7).
[2]宣华，王映雪，陈怀楚.清华大学综合教育系统在教务管理中的应用[J].计算机工程与应用，2012，(12).
[3]梁德华.浅析高等院校学籍管理信息系统的设计与开发[J].硅谷，2011，(11).
[4]李香敏.SQLServer2000编程员指南[M].北京：希望电子出版社，2000：12.
[5]杨易.JSP网络编程技术与实例[M].北京：人民邮电出版社，2005：10.
学籍管理系统论文参考文献：
[1]罗少华；基于LAMP的高校成绩管理系统的设计与实现[D]；复旦大学；2011年.
[2]石瑨；基于B/S模式的.医院信息管理系统研究与开发[D]；电子科技大学；2011年.
[3]曹维；数学课程教学网站的分析与设计[D]；云南大学；2012年.
[4]冯志华；基于PLC的沙湾水厂自控管理系统分析与设计[D]；云南大学；2012年.
[5]黄艳霞；食堂管理系统分析与设计[D]；云南大学；2012年.
[6]张小敏；4S店汽车客户服务管理系统的设计与实现[D]；电子科技大学；2012年.
[7]任静；四川教育学院学生成绩管理信息系统设计与实现[D]；电子科技大学；2012年.
[8]张成文；基于Web的中小学综合教学管理平台的研究与实现[D]；兰州大学；2013年.
[9]邓有荣；保山纪检监察信访信息管理系统的分析与设计[D]；云南大学；2013年.
;
你直接找你上一届的学长学姐要不就行了嘛，这个东西又不查重
sqlserver.exe 进程文件: sqlserver.exe or sqlserver
病毒路径：未知
进程名称: trojan.W32.SAMX
英文描述:
sqlserver.exe is a process which is registered as a trojan. This 木马 allows attackers to access your computer from remote locations, stealing passwords, Internet banking and personal data. This process is a security risk and should be removed from your system.
DISABLE AND REMOVE sqlserver.exe IMMEDIATELY. This process is most likely a virus or trojan.
中文描述：
sqlserver.exe被记录为一个木马进程。这个木马允许攻击者 远程访问你的计算机，盗取密码，网银帐号和个人数据。此进程是安全隐患，应该立即从系统中移除。
建议使用木马克星查杀，在百度里搜索木马克星破解版即可。
参考文献：
一、SQL Server关系数据库简介
1、SQL Server是由Microsoft开发和推广的关系数据库系统（DBMS)，它最初是由Microsoft、Sybase和Ashton-Tate三家公司共同开发的，并于1988年推出了第一个OS/2版本。
2、关系数据库（RDBMS)管理系统功能：
》维护数据库数据之间的关系；
》保证数据存储的正确性；
》当出现系统故障的时候，将所有数据恢复到能够保证一致行的某种状态
3、RDBMS:SQL Server，Oracle，DB/2,Sybase，Informix
4、Non-RDBMS(File-based）：Foxpro，Access
二、SQL Server 2000的版本
1、SQL Server 2000常见版本有：
》企业版（Enterprise Edition）
支持所有SQL Server 2000的功能。该版本多用于大中型产品数据库服务器，并且可以支持大型网站，企业OLTP（联机事务处理）和大型数据仓库系统OLAP(联机分析处理）所要求的性能。
》标准版（Standard Edition）
实用范围是小型的工作组或部门。它支持大多数的SQL Server2000功能。但是，不具有支持大型数据库，数据仓库和网站的功能。而且，不支持所有的关系数据库引擎的功能。
》个人版（Personal Edition）
主要适用于移动用户，因为他们经常从网络上断开，而运行的应用程序却仍然需要SQL Server 2000的支持。除了事务处理复制功能以外，能够支持所有SQL Server 2000标准版支持的特性。
》开发者版（Developer Edition）
适用于应用程序开发的版本，支持除图形化语言设置以外的SQL Server2000的所有其它功能。该版本主要适用于程序员在开发应用程序时，将SQL Server 2000作为其数据存储区。虽然开发版的功能齐备，但是只被授权为一个开发和测试系统，而不是一个产品服务器。
1.1 SQL Server特点
》与因特网的集成：
SQL Server 2000的数据库引擎全面支持XML（Extensive Markup Language，扩展标记语言），能使用户很容易地将数据库中的数据发布到Web页面上。
》可伸缩性与可用性：
可跨越从运行Windows 95/98的膝上型电脑到运行Windows 2000的大型多处理器等多种平台使用。另外，对联合服务器，索引视图等的支持，使得SQL Server 2000企业版可以升级到最大Web站点所需的性能级别。
》企业级数据库功能：
SQL Server 2000分布式查询可以引用来自不同数据库的数据，而且这些对于用户来说是完全透明的；分布式数据库将保证任何分布式数据更新时的完整性；复制可以使我们能够维护多个数据复本，这些用户能够自主地进行工作，然后再将所做的修改合并到发布数据库；SQL Server 2000关系数据库引擎能够充分保护数据完整性，还可以将管理并发修改数据库开销到最小。
》易于安装，部署和使用：
SQL Server 2000由一系列的管理和开发工具组成，这些工具使得在多个站点上进行SQL Server的安装，部署，管理和使用变得更加容易。开发人员可以更加快速地交付SQL Server应用程序，而且只需要进行最少的安装和管理就可以实现这些应用程序。
》数据仓库：
数据仓库是SQL Server 2000中包含的用于分析取和分析汇总数据以进行联机分析处理的工具。这个功能只在Oracle和其他更昂贵的DBMS中才有。
1.1.1 SQL Server 2000新特性
全面扩展了SQL Server 7.0的性能，可靠性和易用性。增加了一系列的功能，具体如下：
》在关系数据库方面的增强
》图形管理增强
》增强的联合数据库服务器
1.2 SQL Server 2000工具和实用程序
1、企业管理器 2、服务管理器 3、查询分析器 4、事件探查器
5、导入和导出数据 6、服务器网络使用工具 7、客户端网络使用工具 8、联机帮助文档
1.2.1 企业管理器
企业管理器是基于一种新的被称为微软管理控制台（Microsoft Management Console)的公共服务器管理环境，它是SQL Server 2000中最重要的一个管理工具。
企业管理器不仅能够配置系统环境和管理SQL Server，而且由于它能够以层叠列表的形式来显示所有的SQL Server对象，因而所有SQL Server对象的建立与管理都可以通过它来完成。
用企业管理可以完成的操作
》管理SQL Server服务器；建立与管理数据库；建立与管理表、视图、存储过程、触发程序、角色、规则、默认值等数据库对象，以及用户定义的数据类型；备份数据库和事务日志、
恢复数据库；复制数据库；设置任务调度；设置警报；提供跨服务器的拖放控制操作；管理用户账户；建立Transact-SQL命令语句以及管理和控制SQL Mail。
》在企业管理器中包含两个窗口，左侧的窗口是以“树状目录”显示的活动窗口，右侧是显示内容的窗口。
》单击左侧窗口中的加号，可以展开各个项目包含的子项目。
》通过选中的某个项目的节点，可以在右侧的窗口中看到该项目包含的内容。
1.2.2服务管理器（Service Manager）
1、SQL Server服务管理器是在服务器端实际工作时最有用的实用程序，服务管理器用来启动、暂停、继续和停止数据库服务器的实时服务，其提供的服务类型包括：SQL Server、SQL Server代理、Microsoft搜索和分布式事务协调器等。
A relational database, SQL Server
1, by Microsoft SQL Server is the development and popularization of relational database system (DBMS), which was originally by Microsoft, and Ashton Sybase Tate - three companies and joint development, launched in 1988, the first OS / 2 version.
2 and relational database management system (RDBMS) function:
"Maintaining the relationship between database data,
"Ensure the correctness of the data storage,
"When a system fault, all data recovery to ensure consistent done some condition
3, RDBMS: SQL Server, Oracle, DB / 2, Sybase Informix,
4 and amplified RDBMS (File - based) : Foxpro, Access
Second, SQL Server 2000 version
1 and SQL Server 2000 common version:
"Enterprise Edition (Enterprise Edition),
Support all SQL Server 2000 function. This version for large and medium-sized products, and can support the database server, large web companies OLTP (online transaction processing) and large data warehouse system (on-line analytical processing (OLAP) required performance.
"Standard version (Standard Edition),
A small range of practical working or departments. It supports most SQL Server2000 function. But, do not have support large database, data warehouse and the functionality of the site. And don't support all the relations of the database engine.
"Personal Edition (Personal Edition),
Mainly used in mobile users, because they often disconnected, and from the network of applications running still need SQL Server 2000 support. Besides the transaction copy, able to support all functions of SQL Server 2000 standard version of the support.
"Edition) Developer Edition (Developer
Suitable application development version, support except graphical Server2000 SQL language setting beyond all the other functions. This version is mainly used in the programmer development application, will SQL Server 2000 as data storage area. Although development version of the function, but only authorized for a development and testing system, not a product server.
1.1 SQL Server features
With the integration of the Internet:
SQL Server 2000 database engine comprehensive support XML Language, creating take (extensible Markup Language), that the user can easily be database data released to the Web page.
"Scalability and usability:
Can span from running Windows 95, 98 / the laptop to run Windows 2000 large-scale multiple processors etc. Various platforms. In addition, to jointly Server, etc, the support index view that SQL Server 2000 enterprise edition can upgrade to the largest Web site desired performance level.
"Enterprise databases functions:
SQL Server 2000 distributed query can quote from different database data, and these are completely transparent to users, Distributed database will ensure that any distributed data update integrity, Copy can enable us to maintain multiple data available, the user can work independently, and then will be done by modified merged into the database, SQL Server 2000 relational database engine can fully protect data integrity, still can be modified database management concurrent cost to a minimum.
"Easy to install, deployment and use:
SQL Server 2000 by a series of management and development tools, these tools at multiple sites on SQL Server installation, deploy, manage and use more easily. Developers can more quickly deliver SQL Server applications and requires only the least installation and management can achieve these applications.
"Data warehouse:
The data warehouse is SQL Server 2000 contains for analysis and summary data analysis on on-line analytical processing tools. This function only in Oracle and other more expensive DBMS.
1.1.1 SQL Server 2000 new features
Fully expanded the SQL Server 7.0 performance, reliability and usability. Increases the range of functions, specific as follows:
In the aspect of relational database
"Graphics management enhancement
The combination of enhanced database server
1.2 SQL Server 2000 tools, and utilities
1, enterprise management, service management 3, 4, event detection query parsers
5 and 6, the input and output data network, server client to use tools, tools Internet use online documentation
1.2.1 enterprise management
Enterprise Management is based on a new called Microsoft Management Console (r) of public Management Microsoft Server Management environment, it is the SQL Server 2000 in one of the most important Management tools.
Enterprise management can not only configuration system environment and management, but also because it SQL Server can cascade form to list all the SQL Server object, so all the SQL Server object of establishment and management can be accomplished by it.
In enterprise management can finish operation
"Management SQL Server Server. Establish and manage database, Establish and manage, view, storage process, triggering role, rules, procedures, by default, such as user defined object database of data types, Backup database and transaction log,
Restore database, Copy database, Set task scheduling, Set alarm, Provide cross-server drag-and-drop controls operating, Manage the user accounts, Establish Transact - SQL commands and the management and control of the SQL statement E-mail.
"In the enterprise management in the window contains two on" the window "directory tree right is the active window, showing the contents of the window.
"The window, click on various projects can deploy plus committeeapos contains.
"Through a project of the selected node in the window, can see on this project contains the content.
1.2.2 Service Manager (up) Service
1 and SQL Server service manager is in practical work when the Server is most practical program, service management is to start, stop, and continue to suspend the real-time database Server service, the service provided types include: SQL Server, SQL Server proxy, Microsoft search and distributed coordination, etc.
给分的啊 累死了！！
sql server SQL
SQL is Structured Query Language English acronym, which means for the Structured Query Language. SQL language is the main function of establishing ties with the various databases, for communication. In accordance with ANSI (American National Standards Institute) requirements, SQL as a relational database management system standard language. SQL statements can be used to implement a wide range of operations, such as updating the data in the database, extract data from the database and so on. At present, the vast majority of the popular relational database management systems such as Oracle, Sybase, Microsoft SQL Server, Access, adopted the standard SQL language. Although many databases on the SQL statement for the redevelopment and expansion, but including the Select, Insert, Update, Delete, Create, and Drop, including the standard SQL commands can be used to complete almost all the database operations.
SQL Server
SQL Server is a relational database management system. It was originally proposed by Microsoft Sybase and Ashton-Tate three companies jointly developed in 1988 with the introduction of the first OS / 2 version. After the introduction of Windows NT in, Microsoft and Sybase in the development of SQL Server on the split, Microsoft will migrate to SQL Server on Windows NT system, focusing on promoting the development of SQL Server version of Windows NT. Sybase is more focused on SQL Server in the UNIX operating system applications.
SQL Server 2000 is Microsoft Launches the SQL Server database management system, the inherited version of SQL Server 7.0 version of the merits, at the same time it increases than many of the more advanced features. Good scalability with ease of use and related high degree of software integration, across from the running Microsoft Windows 98 laptop running Microsoft Windows 2000 large-scale multi-processor servers such as the use of multiple platforms.
SQL Server 2005?
SQL Server 2005 is a comprehensive database platform, the use of integrated business intelligence (BI) tools to provide enterprise-class data management. SQL Server 2005 relational database engine for data and structured data to provide a more secure and reliable storage function that allows you to build and manage high availability for business and high-performance data applications.
SQL Server 2005 data engine is the enterprise data management solutions for the core. The SQL Server 2005 combines the analysis, reporting, integration and notifications. This makes your business can build and deploy cost-effective BI solutions that help your team through the Scorecard, Dashboard, Web services and data applications to mobile devices to all areas of business.
With Microsoft Visual Studio, Microsoft Office System and the new development kit (including the Business Intelligence Development Studio) to enable the close integration of SQL Server 2005 unique. Whether you're a developer, database administrator, information worker or decision-makers, SQL Server 2005 that can provide you with innovative solutions to help you benefit from more data.
[Edit this paragraph] Microsoft SQL Server 2008
SQL Server 2008 is a major product version, it introduced many new features and key improvements made to date it has become the strongest and most comprehensive version of SQL Server. The article described in detail in Microsoft SQL Server 2008's new features, advantages and features ... ...
Microsoft's data platform to meet these data explosion and the next generation of data-driven applications that demand and support the data platform vision: mission-critical enterprise data platform, dynamic development, relational data and business intelligence.
Microsoft data platform vision
SQL Server's vision
Many factors have led to an explosion of information storage. A new type of information, such as pictures and digital video, and RFID tags obtained from the sensor information, the company's digital information in the rapid growth of the number. Compliance with the norms and requirements of the development of globalization, the security of information storage and are available at any time. At the same time, the cost of disk storage significantly reduced so that every dollar invested can store more data. Users to move quickly in a large amount of data to find relevant information. In addition, on any device they want to use this information, and plan to use every day, such as the Microsoft Office system applications. The explosion of data and user expectations for an increase in the management of the company has created many challenges.
Microsoft ® data platform vision to provide a solution to meet these needs, this solution is companies can store and manage the use of many data types, including XML, e-mail, time / calendar, files, documents, geographic, etc., at the same time provide a rich set of services to interact with the data: search, query, data analysis, reporting, data integration, synchronization and powerful. Users can access from the creation to archive to any device, from desktop to mobile devices
SQL Server 2008 new features
The platform has the following characteristics:
Trusted - allows the company can be a very high security, reliability and scalability to run their most mission-critical applications.
Efficient - allows the company to reduce development and management of their data infrastructure of the time and cost.
Intelligence - provides a comprehensive platform for users in your time of need to send him to observe and information.
A trusted
(A) the protection of your information
In the past the basis of SQL Server 2005 on, SQL Server 2008 made the following enhancements to expand its security:
* Simple data encryption
SQL Server 2008 can be the entire database, data files and log files for encryption, without requiring changes to applications. Encrypt enable companies to meet compliance with the norms and their concern about data privacy requirements. Simple and the benefits of data encryption, including the use of any scope or ambiguous search query data encryption to enhance data security to prevent unauthorized user access, as well as data encryption. These can change the applications have been conducted.
* Foreign key management
SQL Server 2008 for the encryption and key management provides a comprehensive solution. In order to meet evolving data center for more information on the needs of security, to the supplier's investment company to manage the security key. SQL Server 2008 by supporting third-party key management and hardware security module (HSM) products to provide for the needs of a very good support.
* Enhanced the review
SQL Server 2008 allows you to review the operation of your data, resulting in improved compliance and security. Review of more than modification of data, including all of the information, but also on the data when reading the information. SQL Server 2008 as server with enhanced configuration and management review of such a function, which allows the company to meet the needs of a variety of norms. SQL Server 2008 can also define a database review of each specification, so the review can be configured for each separate database for the development. For a specific configuration object for the review so that review of the implementation of better performance, higher flexibility in configuration.
(Ii) to ensure business sustainability
* Improved database mirroring
SQL Server 2008 on SQL Server 2005, and provides a more reliable database mirroring to enhance the platform. The new features include:
Automatic page repair. SQL Server 2008 through a request for cooperation from the mirror to be the wrong machine to copy pages to the main computer and the image can be transparent to repair the data page 823 and 824 errors.
To improve performance. SQL Server 2008 reduced the output of the log stream in order to enable database mirroring the network bandwidth required to achieve the minimum.
[Edit this paragraph] SQL Server Analysis Server Install
sql server 2000 the previous version, for example, there is generally no more than 7.0 version, only the Standard Edition with the desktop version, users who do not know what version of the equipment, the installation can be a prerequisite for the installation instructions to install, usually in WIN2000 Server Edition's Wear Standard Edition, and other systems installed on the desktop version of the can; and SQL Server 2000 installed on the larger issues, when the common issues are as follows:
(1) interruption of server configuration.
(2) when the interruption of registered ActiveX.
(3) show that 100% of the time to interrupt.
(4) prompt: command line option syntax error, type command /? For help, continue with the installation, the last time in there to configure the server: can not find the specified dynamic-link SQLUNIRL.DLL path ... ...
(5) before the procedure to create a pending file operations, before running Setup, you must restart the
(1) (2) (3) solution:
Reminder: In order to avoid misoperation the first database backup into the registry and can not SQL Server 2000, can be backup Program Files \ Microsoft SQL Server \ MSSQL \ Data folder of the document.
1, first uninstall SQL Server (uninstall does not matter can not continue to operate below)
2, the Microsoft SQL Server to delete the entire folder.
3, run the registry, delete the following items:
HKEY_CURRENT_USER \ Software \ Microsoft \ Microsoft SQL Server
HKEY_LOCAL_MACHINE \ SOFTWARE \ Microsoft \ Microsoft SQL Server
HKEY_LOCAL_MACHINE \ SOFTWARE \ Microsoft \ MSSQLServer
4, if necessary, restart the system on
5, re-install
Can also try to run the installation of single-step method of SQL Server 2000:
1: Add SQL Server 2000 CD-ROM.
2: In the "Start" - "Run" type "F: \ x86 \ setup.exe k = dbg" (F is the CD-ROM)
Note:
First, different operating systems support SQL Server 2000 version and hardware requirements.
Windows 2000 Server can be installed any SQL Server 2000 version.
Windows 2000 Professional can only install SQL Server 2000 Personal Edition, Developer Edition, Evaluation, MCDE
Two,
SQL Server 2000 versions and hardware requirements.
(4) solution
Because the path of installation files (full path), there are Chinese.
For example, c: \ SQLSERVER Chinese Enterprise Edition \
Changed to c: \ SQLSERVER \
(5) solution
a, restart the machine and then install, if there is the error, follow these steps
B, at the beginning - Run, type regedit
c, to HKEY_LOCAL_MACHINE \ SYSTEM \ CurrentControlSet \ Control \ Session Manager position
D, select the file - Pour out the preservation
e, in the right window right-click PendingFileRenameOperations, select Delete, and then confirmed
F, restart the installation, problem-solving
-------------------------------------------------- -----
If the problem remains, try to repair the operating system
Under the command prompt:
Sfc / scannow
Finally, the method: for Windows 2000 installation disk and installation disk SQL Server2000
Sometimes the cause of the problem is very strange that someone has to replace a power supply to solve the problem.
1 to uninstall your SQL Server 2000, the time necessary to delete Program Files \ Microsoft SQL Server folder
2 Open the registry
In the "Start" - "Run", type "regedit"
3 clicks to open in the following order
+ HKEY_LOCAL_MACHINE
+ SOFTWART
+ Microsoft
+ Windows
+ CurrentVersion
+ Setup
+ ExceptionComponents
4 ExceptionComponents the following to delete all folders!
Such as (60BFF50D-FB2C-4498-A577-C9548C390BB9)
(60BFF50D-FB2C-4498-A577-C9548C390BB9)
(60BFF50D-FB2C-4498-A577-C9548C390BB9)
(60BFF50D-FB2C-4498-A577-C9548C390BB9)
6 to restart:
7 re-install SQL Server 2000
sql server SQL
SQL是英文Structured Query Language的缩写，意思为结构化查询语言。SQL语言的主要功能就是同各种数据库建立联系，进行沟通。按照ANSI(美国国家标准协会)的规定，SQL被作为关系型数据库管理系统的标准语言。SQL语句可以用来执行各种各样的操作，例如更新数据库中的数据，从数据库中提取数据等。目前，绝大多数流行的关系型数据库管理系统，如Oracle, Sybase, Microsoft SQL Server, Access等都采用了SQL语言标准。虽然很多数据库都对SQL语句进行了再开发和扩展，但是包括Select, Insert, Update, Delete, Create,以及Drop在内的标准的SQL命令仍然可以被用来完成几乎所有的数据库操作。
SQL Server
SQL Server 是一个关系数据库管理系统。它最初是由Microsoft Sybase 和Ashton-Tate三家公司共同开发的，于1988 年推出了第一个OS/2 版本。在Windows NT 推出后，Microsoft与Sybase 在SQL Server 的开发上就分道扬镳了，Microsoft 将SQL Server 移植到Windows NT系统上，专注于开发推广SQL Server 的Windows NT 版本。Sybase 则较专注于SQL Server在UNIX 操作系统上的应用。
SQL Server 2000 是Microsoft 公司推出的SQL Server 数据库管理系统，该版本继承了SQL Server 7.0 版本的优点，同时又比它增加了许多更先进的功能。具有使用方便可伸缩性好与相关软件集成程度高等优点，可跨越从运行Microsoft Windows 98 的膝上型电脑到运行Microsoft Windows 2000 的大型多处理器的服务器等多种平台使用。
SQL Server 2005？
SQL Server 2005 是一个全面的数据库平台，使用集成的商业智能 (BI) 工具提供了企业级的数据管理。SQL Server 2005 数据库引擎为关系型数据和结构化数据提供了更安全可靠的存储功能，使您可以构建和管理用于业务的高可用和高性能的数据应用程序。
SQL Server 2005 数据引擎是本企业数据管理解决方案的核心。此外 SQL Server 2005 结合了分析、报表、集成和通知功能。这使您的企业可以构建和部署经济有效的 BI 解决方案，帮助您的团队通过记分卡、Dashboard、Web services 和移动设备将数据应用推向业务的各个领域。
与 Microsoft Visual Studio、Microsoft Office System 以及新的开发工具包（包括 Business Intelligence Development Studio）的紧密集成使 SQL Server 2005 与众不同。无论您是开发人员、数据库管理员、信息工作者还是决策者，SQL Server 2005 都可以为您提供创新的解决方案，帮助您从数据中更多地获益。
[编辑本段]微软SQL Server 2008
SQL Server 2008是一个重大的产品版本，它推出了许多新的特性和关键的改进，使得它成为至今为止的最强大和最全面的SQL Server版本。这篇文章详细介绍了Microsoft SQL Server 2008中的新的特性、优点和功能……
微软的这个数据平台满足这些数据爆炸和下一代数据驱动应用程序的需求，支持数据平台愿景：关键任务企业数据平台、动态开发、关系数据和商业智能。
Microsoft数据平台愿景
SQL Server的愿景
许多因素致使产生了信息存储爆炸。有了新的信息类型，例如图片和视频的数字化，和从RFID标签获得的传感器信息，公司的数字信息的数量在急剧增长。遵守规范和全球化的发展要求信息存储的安全性和在任何时候都可用。同时，磁盘存储的成本显著地降低了，使得公司投资的每一美元可以存储更多的数据。用户必须快速的在大量的数据中找到相关的信息。此外，他们想在任何设备上使用这个信息，并且计划每天使用，例如Microsoft Office系统应用程序。对数据爆炸和用户期望值的增加的管理为公司制造了许多挑战。
Microsoft® 数据平台愿景提供了一个解决方案来满足这些需求，这个解决方案就是公司可以使用存储和管理许多数据类型，包括XML、e-mail、时间/日历、文件、文档、地理等等，同时提供一个丰富的服务集合来与数据交互作用：搜索、查询、数据分析、报表、数据整合，和强大的同步功能。用户可以访问从创建到存档于任何设备的信息，从桌面到移动设备的信息
SQL Server 2008新功能
这个平台有以下特点：
· 可信任的——使得公司可以以很高的安全性、可靠性和可扩展性来运行他们最关键任务的应用程序。
· 高效的——使得公司可以降低开发和管理他们的数据基础设施的时间和成本。
· 智能的——提供了一个全面的平台，可以在你的用户需要的时候给他发送观察和信息。
一、可信任的
（一）保护你的信息
在过去的SQL Server 2005的基础之上，SQL Server 2008做了以下方面的增强来扩展它的安全性：
* 简单的数据加密
SQL Server 2008可以对整个数据库、数据文件和日志文件进行加密，而不需要改动应用程序。进行加密使公司可以满足遵守规范和及其关注数据隐私的要求。简单的数据加密的好处包括使用任何范围或模糊查询搜索加密的数据、加强数据安全性以防止未授权的用户访问、还有数据加密。这些可以在不改变已有的应用程序的情况下进行。
* 外键管理
SQL Server 2008为加密和密钥管理提供了一个全面的解决方案。为了满足不断发展的对数据中心的信息的更强安全性的需求，公司投资给供应商来管理公司内的安全密钥。 SQL Server 2008通过支持第三方密钥管理和硬件安全模块(HSM)产品为这个需求提供了很好的支持。
* 增强了审查
SQL Server 2008使你可以审查你的数据的操作，从而提高了遵从性和安全性。审查不只包括对数据修改的所有信息，还包括关于什么时候对数据进行读取的信息。SQL Server 2008具有像服务器中加强的审查的配置和管理这样的功能，这使得公司可以满足各种规范需求。SQL Server 2008还可以定义每一个数据库的审查规范，所以审查配置可以为每一个数据库作单独的制定。为指定对象作审查配置使审查的执行性能更好，配置的灵活性也更高。
（二）确保业务可持续性
* 改进了数据库镜像
SQL Server 2008基于SQL Server 2005，并提供了更可靠的加强了数据库镜像的平台。新的特性包括：
· 页面自动修复。SQL Server 2008通过请求获得一个从镜像合作机器上得到的出错页面的重新拷贝，使主要的和镜像的计算机可以透明的修复数据页面上的823和824错误。
· 提高了性能。SQL Server 2008压缩了输出的日志流，以便使数据库镜像所要求的网络带宽达到最小。
[编辑本段]SQL Server 服务器安装剖析
sql server 2000以前的版本，例如7.0一般不存在多个版本，只有标准版跟桌面版，用户如果不清楚该装什么版本的话，可按安装上的安装先决条件指示安装，一般在WIN2000 服务器版上装标准版，其他的系统装桌面版的就可以；而SQL Server 2000安装问题就比较大，时常见问题有如下：
(1)配置服务器时中断.
(2)注册 ActiveX 时中断.
(3)显示到100%的时候中断.
(4)提示：command line option syntax error, type command /? for help，继续安装,最后在配置服务器的时候出现：无法找到动态链接SQLUNIRL.DLL于指定的路径……
(5)以前进行的程序创建了挂起的文件操作，运行安装程序前，必须重新启动
(1)(2)(3)的解决办法：
提醒：为避免误操作，先备份注册表和数据库进不了SQL Server 2000,可以备份 Program Files\Microsoft SQL Server\MSSQL\Data 文件夹的文件.
1、先把SQL Server卸载（卸载不掉也没有关系，继续下面的操作）
2、把Microsoft SQL Server文件夹整个删掉。
3、运行注册表,删除如下项：
HKEY_CURRENT_USER\Software\Microsoft\Microsoft SQL Server
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer
4、需要的话就重新启动系统
5、重新安装
另外也可尝试单步运行安装 SQL Server 2000的方法：
1:放入 SQL Server 2000 光盘.
2:在"开始"--"运行"键入 "F:\x86\setup.exe k=dbg" (F是光盘)
注意：
一、不同的操作系统支持的SQL Server 2000版本以及对硬件的要求。
Windows 2000 Server可以安装SQL Server 2000的任何版本.
Windows 2000 Professional只能安装SQL Server 2000的个人版、开发版、评估版、MCDE
二、
SQL Server 2000各版本以及对硬件的要求。
(4)的解决办法
因为安装文件的路径(完整路径)里有中文.
比如 c:\SQLSERVER中文企业版\
改成 c:\SQLSERVER\
(5)的解决办法
a、重启机器，再进行安装，如果发现还有该错误，请按下面步骤
b、在开始-运行中输入regedit
c、到HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\Session Manager 位置
d、选择文件-倒出,保存
e、在右边窗口右击PendingFileRenameOperations，选择删除，然后确认
f、重启安装，问题解决
-------------------------------------------------------
如果问题依旧,试试先修复操作系统
命令提示符下执行:
sfc /scannow
最后的方法：换Windows 2000 安装盘 和SQL Server2000安装盘
有时候问题的原因很奇怪，有人曾更换了一个电源就解决了问题。
1 先卸载您的 SQL Server 2000,必要的时候删除 Program Files\Microsoft SQL Server 文件夹
2 打开注册表
在"开始"--"运行"键入 "regedit"
3 按下列顺序点击打开
+ HKEY_LOCAL_MACHINE
+ SOFTWART
+ Microsoft
+ Windows
+ CurrentVersion
+ Setup
+ ExceptionComponents
4 将 ExceptionComponents 下面的文件夹全部删除!
如 {60BFF50D-FB2C-4498-A577-C9548C390BB9}
{60BFF50D-FB2C-4498-A577-C9548C390BB9}
{60BFF50D-FB2C-4498-A577-C9548C390BB9}
{60BFF50D-FB2C-4498-A577-C9548C390BB9}
6 重新启动:
7 重新安装 SQL Server 2000
