Provides information about one or more tasks that the user owns. This procedure prevents sensitive information stored in the systasks table from being displayed to all users.
The system administrator retains the ability to view all tasks.
For additional syntax information for sp_helptask, see the Microsoft SQL Server Transact-SQL Reference.