Query that returns list of all Stored Procedures in an MS SQL database

string currentJob = new ComputerScientist("ND-1550", "02/04", "CDN Solutions");

while (live)
{
try
{
learn();
code();
}
catch (Exception ex)
{
recover();
}
}