When I follow the tutorials online - using the SQL Server Management Studio 2008 - to view stored procedures, it appears completely blank. But, when I run this query, I see the stored procedure that I've created (multipleOrderSearch)
WHERE routine_type = 'PROCEDURE'
AND SPECIFIC_NAME LIKE '%multiple%'
Is there a setting that might hide stored procedures? More to the point, how would I edit it? In other instances, I would right click and press alter, which shows me everything I need. What do I do here?
I use Microsoft SQL 2008