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.

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.