Export (0) Print
Expand All
2 out of 3 rated this helpful - Rate this topic

What's New in SQL Server Books Online

SQL Server 2000

  Topic last updated -- June 2007

The following table describes what's new in Microsoft® SQL Server™ 2000 Books Online as of June 2007. The topics listed in the table contain significant technical corrections.

Topic Description
CREATE FUNCTION Corrected the description of the protection provided by using the WITH ENCRYPTION option when creating a function.
ALTER FUNCTION Corrected the description of the protection provided by using the WITH ENCRYPTION option when altering a function.
CREATE PROCEDURE Corrected the description of the protection provided by using the WITH ENCRYPTION option when creating a stored procedure.
ALTER PROCEDURE Corrected the description of the protection provided by using the WITH ENCRYPTION option when altering a stored procedure.
Programming Stored Procedures Corrected the description of the protection provided by using the WITH ENCRYPTION option when creating a stored procedure.
CREATE TRIGGER Corrected the description of the protection provided by using the WITH ENCRYPTION option when creating a trigger.
ALTER TRIGGER Corrected the description of the protection provided by using the WITH ENCRYPTION option when altering a trigger.
Programming Triggers Corrected the description of the protection provided by using the WITH ENCRYPTION option when creating a trigger.
CREATE VIEW Corrected the description of the protection provided by using the WITH ENCRYPTION option when creating a view.
ALTER VIEW Corrected the description of the protection provided by using the WITH ENCRYPTION option when altering a view.
Creating a View Corrected the description of the protection provided by using the WITH ENCRYPTION option when creating a view.
syscomments Clarified that the encryption column in the syscomments system table contains obfuscated, not encrypted stored procedure definitions.
Using Encryption and Obfuscation Corrected the description of the protection provided by using the WITH ENCRYPTION option when creating stored procedures, views, triggers, and functions. Also clarified that login and application role passwords are obfuscated rather than encrypted.
Encrypting Views Corrected the description of the protection provided by using the WITH ENCRYPTION option when creating a view.
If you save the view encrypted, you will no longer be able to alter the view definition. Corrected the description of the protection provided by using the WITH ENCRYPTION option when creating a view.

The following table describes what's new in Microsoft® SQL Server™ 2000 Books Online as of January 2004. The topics listed in the table are new or contain significant technical changes. Topics that contain minor changes are not listed.

Topic Description
Hardware and Software Requirements for Installing SQL Server 2000 Updated to document operating systems released since the original release of SQL Server 2000.
Running the osql Utility Added new topic describing how to use the osql utility.
Running Transact-SQL Statements Interactively Using osql Added new topic describing how to use the osql utility to run Transact-SQL statements that you enter interactively in a command prompt window.
Running Transact-SQL Script Files Using osql Added new topic describing how to build text scripts of Transact-SQL statements and then run them using the osql utility.
Administering SQL Server Using osql Added new topic describing how to use osql to execute Transact-SQL statements that configure instances of SQL Server and manage SQL Server databases.
osql Utility Updated topic to clarify how to specify file locations using the /i and /o switches.
SQL Server 2000 on Windows 98 Updated topic to note that Windows 98 does not support fibers and read-ahead I/O.
SQL Server 2000 Databases on the Desktop Expanded several paragraphs into new topics that document the SQL Server 2000 Desktop Engine (MSDE 2000). Added links to the new topics.
The SQL Server 2000 Workload Governor Added new topic describing the workload governor in SQL Server 2000 Personal Edition and MSDE 2000.
When to Upgrade from the Governor Added new topic describing how the workload governor can become the performance-limiting factor, justifying upgrading to SQL Server 2000 Standard Edition.
Data Access and the Workload Governor Added new topic describing how the workload governor slows down reads and writes of database data.
Understanding When the Workload Governor Is Activated Added new topic describing what causes the workload governor to start slowing down data reads and writes.
Maximum Capacity Specifications Updated topic to clarify that the 2-GB limit on the size of MSDE 2000 databases applies only to the data files, and not to the log files.
Understanding SQL Server 2000 Desktop Engine (MSDE 2000) Added new topic containing overview of MSDE 2000.
SQL Server 2000 Desktop Engine (MSDE 2000) Documentation Added new topic describing the parts of SQL Server 2000 Books Online that apply to MSDE 2000, with links to the main Web page containing MSDE 2000 information and software.
Programming SQL Server 2000 Desktop Engine (MSDE 2000) Applications Added new topic contrasting the MSDE 2000 programming model with the database engine from the other editions of SQL Server 2000 and noting that MSDE 2000 does not support SQLXML.
Administering SQL Server 2000 Desktop Engine (MSDE 2000) Added new topic describing MSDE 2000, and how to administer MSDE 2000 without the SQL Server 2000 graphical administration utilities.
DBCC CONCURRENCYVIOLATION Updated references to the workload governor to match the new workload governor description added to the "SQL Server Architecture" section.
Distributing SQL Server Applications Overview Updated topic to reflect the current recommendations for installing instances of MSDE 2000.
Distributing the SQL Server 2000 Desktop Engine Updated topic to reflect the current recommendations for installing instances of MSDE 2000.
Installing Desktop Engine Updated topic to reflect the current recommendations for installing instances of MSDE 2000 and to clarify the impacts of different ways of installing it.
Using SQL Server Desktop Engine Merge Modules Updated topic to include recommendation against using merge modules to install MSDE 2000.
Customizing Desktop Engine Setup.exe Updated topic to better guide new users to the examples of typical setup scenarios and to correct the descriptions of the TARGETDIR and DATADIR parameters.
Managing Desktop Engine Installation Package Files Updated topic to reflect the current recommendations for installing instances of MSDE 2000.
Windows Installer Return Codes for Desktop Engine Updated topic with new cause-and-resolution information for some of the return codes.
Desktop Engine Installation Samples Updated topic to reflect the current recommendations for installing instances of MSDE 2000.
ALTER DATABASE Updated topic with examples showing how to set multiple database options in a single transaction, and how to move tempdb to a new location on disk.
DATABASEPROPERTYEX Updated topic to document the IsPublished property.
sp_spaceused Updated topic to clarify the Result Set descriptions for several columns.
Error Message Descriptions Added new topics documenting the most frequently encountered error messages.

Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback
Show:
© 2014 Microsoft. All rights reserved.