- #Sql server 2000 enterprise manager download update#
- #Sql server 2000 enterprise manager download upgrade#
- #Sql server 2000 enterprise manager download full#
- #Sql server 2000 enterprise manager download windows#
A real gem is the integration of the Transact-SQL Debugger into the Query Analyzer.
#Sql server 2000 enterprise manager download update#
It now contains block-mode editing, automatic scripting of insert and update statements, and the ability to handle multiple results sets in a grid. By passing through the action, you get the same effect as a BEFORE trigger.ĭevelopers will also love the new Query Analyzer. Another standout feature: INSTEAD OF triggers allow developers to specify an action to occur before an insert, update or delete. Indexed Views materialize a view through an indexing technique, thereby allowing summary and other sorts of queries to run much faster than they would against base tables. This overcomes the problem in SQL Server 6.5 and 7.0 of not getting the correct identity value back when a table has an insert trigger into another table that also has an identity column. SQL Server 2000 also introduces a number of new features to the language, including user-defined functions, variant, table, and bigint data types, and a SCOPE_IDENTITY() function that gets the last identity property value in the current scope. When you add a foreign key constraint, you can specify that deleting or updating a row in the referenced table should delete or update the given table's foreign key values. It's been a long wait, but cascading update and delete options have been added to referential integrity constraints.
In addition, queries can output XML-formatted results sets. It can accept raw XML requests, meaning that inserts, updates, and deletes can be sent within XML strings. SQL Server 2000 makes XML a bit more native to the database. The big news for developers has to be XML and new Transact-SQL features.
#Sql server 2000 enterprise manager download windows#
Like SQL Server 7.0, SQL Server 2000 does not support Windows Terminal Server on NT 4.0, but it does support it on Windows 2000. In addition, SQL Server 2000 will load backups from SQL Server 7.0, though not from 6.5.
#Sql server 2000 enterprise manager download upgrade#
There's definitely some welcome news in this area: The shipping version of SQL Server 2000 will upgrade evaluation versions, rather than first requiring you to uninstall the evaluation software as was the case with 7.0. The beta CD also requires that Windows 98 have Winsock2 support. Internet Explorer 5 is required, and the SQL Server 2000 installation will supply Microsoft Data Access Components (MDAC) 2.6. Non-server editions will run on Windows 98 and Windows ME - Windows 95 support has been dropped. SQL Server 2000 runs on Windows NT 4.0 with SP5 or better, or on Windows 2000. The 6.5 installation must be at the Service Pack (SP) 5 level. SQL Server 2000 can run with both SQL Server 7.0 and 6.5 on the same machine, although the latter two must still switch between one another. In a controversial move, the Enterprise Edition is also required for Log Shipping, an alternative disaster recovery feature scenario involving a warm standby server instead of a cluster. The Standard Edition will run on symmetric-multiprocessor servers with up to four processors. As with SQL Server 7.0, only the Enterprise Edition will support clustering and large memory addressing, including Windows 2000 Address Windowing Extensions (AWE). The remaining editions are intended for non-servers, such as desktops and workstations. The Enterprise and Standard Editions are meant to be installed on servers. (A Microsoft press release provides more information on CE.) Only the CE Edition is a truly new product, and the beta for it is not yet available. There's bound to be confusion about the Personal Edition - which is called the Desktop Edition in 7.0 - and the SQL 2000 Desktop Engine, also called MSDE. It remains to be seen whether there will be a Standard Evaluation Edition as well. The Developer Edition is a license-restricted version of the Enterprise Edition, whereas the Enterprise Evaluation Edition is a timed version, also with licensing restrictions. Personal Edition ("Desktop Edition" in SQL Server 7.0).At it stands, there are no fewer than seven editions:
The overall configuration of the product is similar to SQL Server 7.0, with a few significant differences.įirst of all, Microsoft has changed the list of product names somewhat.
#Sql server 2000 enterprise manager download full#
SQL Server 2000 has an internal version of, indicating a full release - which the number of new features and improvements do seem to merit.
0 kommentar(er)
