SQL Server auditing prior to SQL Server 2000 Earlier releases of SQL Server have only one built-in auditing feature: the ability to capture server logins. Under SQL Server 7.0, for example, you ...

SQL Server stores smalldatetime values as two 2-byte integers. The first 2 bytes store the number of days after January 1, 1900. The other 2 bytes store the number of minutes since midnight.

Using SQL Server 2000.In a table, I want to default a column 'BillingName' to another column's value in that same table, which is named 'Name'.Using Enterprise Manager, I can normally only set ...

SQL Server 2000 is Microsoft Corp.’s latest version of its flagship relational database management system offering. The long awaited follow-up to SQL Server 7.0 was released to manufacturing on ...

Unlike the previous version of SQL Server, SQL Server 2000 lets you specify collations for almost any task, at virtually every level within a database — from table column to SELECT statement.

Microsoft SQL Server 2000 allows administrators to configure database security flexibly, and supports the U.S. government certification for C2-level installations in sensitive environments.