The sp_helpdb stored procedure now includes the order parameter. Add the following to the reference page for sp_helpdb in Reference Manual: Procedures. The full syntax of sp_helpdb is:
sp_helpdb [dbname, order]
The default order of the output is by lstart, which is the order in which the databases were created or altered. Use device_name along with dbname to display the output of sp_helpdb ordered by device_name.
Example Specifies device_name for the order parameter to display the device fragments for mydb in alphabetical order, overriding the default sort order of sp_helpdb.
sp_helpdb mydb, device_name
name db_size owner dbid created status --------------- ------- ----- ---- ----------- ----------- mydb 4.5 MB sa 5 Feb 27, 2003 no options set (1 row affected) device_fragments size usage created free kbytes ---------------- ----- ------ -------- ------------------ A 1.5 MB data only Feb 27 2003 7:50AM 1530 B 1.0 MB log only Feb 27 2003 7:50AM not applicable C 2.0 MB data only Feb 27 2003 7:50AM 846
Copyright © 2004. Sybase Inc. All rights reserved. |