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