Use sp_help_resource_limit to get information about existing resource limits.
See sp_help_resource_limit in the Reference Manual: Procedures.
