I realise this is subjective, but I figure some discussion on here can't be a bad thing!
The system stored procedures are pushed into the following categories in MSDN:
Which of those categories do you make use of?
asked Nov 23 '09 at 08:55 PM in Default
Matt Whitfield ♦♦
for DBA code I love
answered Nov 24 '09 at 12:39 AM
I guess I would probably use these every week.....
Database Engine Stored Procs
Security Stored Procs
SQL Server Profiler Stored Procs
SQL Server Agent Stored Procs
General Extended Stroed Procs
answered Nov 24 '09 at 06:15 AM
Kev Riley ♦♦
I am currently working on some back-end code to generate views, format files, etc. from metadata, and
answered Nov 23 '09 at 10:50 PM