When the parameter @verbose is used, the output is displayed in the verbose mode.
sp_help_resource_limit [name [, appname[, limittime[, limitday [, scope[, action [, verbose]]]]]]]
@verbose – value is 1 or 0 (zero).
To list all limits in verbose mode:
sp_help_resource_limit null,null,null,null,null,null,1
Another way to list all limits in verbose mode:
sp_help_resource_limit @verbose=1
To list all resource limits in verbose mode.
| Copyright © 2005. Sybase Inc. All rights reserved. |
|
|
