SQL Server 2005 has great sys.XXX views on the system catalog which I use frequently.
What stumbles me is this: why is there a "sys.procedures" view to see info about your stored procedures, but there are no "sys. functions" view to see the same for your stored functions?
Doesn't anybody use stored functions? I find them very handy for e.g. computed columns and such!
Is there a specific reason sys.functions is missing or is it just something that wasn't considered important enough to put into the sys catalog views?? Is it available in SQL Server 2008??