Service Pack 3 is the latest and most comprehensive update to SQL Server 2000. In addition to all of our QFE fixes to date, plus the top service pack requests made by our customers and security updates, SP3 will also include MDAC version 2.7 SP1 and Watson technology

Новая функция в SP3 :

SP3 includes the new function fn_get_sql that returns the text of the SQL statement for the specified SQL handle.

The information returned by the fn_get_sql function is similar to the DBCC INPUTBUFFER command. Use the fn_get_sql function when the DBCC INPUTBUFFER cannot be used, for example:

- When events have more than 255 characters.

- When you have to return the highest current nesting level of a stored procedure. For example, there are two stored procedures that are named sp_1 and sp_2. If sp_1 calls sp_2 and you get the handle from the sysprocesses system table while sp_2 is running, the fn_get_sql function returns information about sp_2. Additionally, the fn_get_sql function returns the complete text of the stored procedure at the highest current nesting level.

Чтобы получить SP3 beta нужно быть beta-тестером
со всеми вытекающими из этого статуса обязательствами