The listudws option is used to list user-defined Web services for the current database.
sp_webservices 'listudws' [, 'service_name']
service_name
The name of the user-defined Web service to be listed.
If the service_name parameter is not specified, all user-defined Web services are listed.