Select stored procedures and function names from SQL Server

In addition to my previous post, within the same sysobjects table you should be able to find the names of the Stored Procedures and the Functions from a SQL Server database by running the following query.

Query for stored procedure names:

select [name],[crdate] from dbo.sysobjects where xtype='P'

Query for function names:

select [name],[crdate] from dbo.sysobjects where xtype='FN'