Changed system procedures

Table 6 summarizes the changes made to existing system procedures.

Table 6: Changed system procedures

Procedure

Change

sp_helpjava

Supports the new depends keyword, which allows you to view a list of database objects that depend on the specified Java class or JAR.

sp_configure

sp_configure allows you to specify the value for configuration paramters in unit specifiers. The unit specifiers are p or P for pages, m or M for megabytes, and g or G for gigabytes. sp_configure also reports on whether the parameter is static or dynamic, and the units for each option.