Function

• SQL Server 2000 functions to provide businesses with data storage. Every record for each company department is saved to the central location. Data is stored in tables, which are the main data storage objects for any database solution. SQL Server 2000 has internal backup processes, so administrators can back up and archive the company data. This functions to save data in case of a hard drive crash.
  
  

Significance

• Dynamic website and desktop applications provide users with on-demand information according to the input or link clicked on a website. The dynamic data produced in these applications come from database solutions. Microsoft programming framework integrates seamlessly with SQL Server 2000. Developers can provide dynamic content using only a few lines of code in VB.NET and C# software.
  
  

Features

• The main storage unit for SQL Server 2000 is the table, but other features are used in the database software. Stored procedures are the programming units for the database. Stored procedures are written in the structured query language (SQL). They insert, delete, edit and retrieve records from the tables. User permissions are also used in SQL Server. User permissions are set up to restrict access to the database, and it provides administrators with a way to give each user permission to a specific database.
  
  

Identification

• The SQL Server 2000 database engine runs when the Windows server boots. The best way to identify if the database is running is to check the Windows system tray. The database engine leaves a "green light" icon in the system tray that indicates it is functioning. Administrators can stop and restart the engine from this system tray icon.
  
  

Maintenance

• Administration of the SQL Server 2000 database is done using a software application called Enterprise Manager. This software is installed on the SQL Server when the engine is installed. Administrators can also install the software on another network machine, so administration is accomplished remotely. Administrators can maintain several SQL Server databases using Enterprise Manager.