Two stored procedures are changed to enable ALS:
sp_dboption adds an option that enables and disables ALS.
sp_helpdb adds a column to display ALS.
For more general information about these stored procedures, see the Reference Manual.