I have sample DB, pubs.

I want to view stored procedures in the pubs db.

(The stored procedure names I want to see are "GetEmployeeCount" and "GetEmployeeCountByLastInitial"

How could I see it in the SQL Server 2012?

Hi,

Like so in the image below

You can also script them out by right clicking on the proc > Script stored procedure option.

Hope This helps

Thanks

Bhanu

• Edited by bhanu_nz 11 hours 18 minutes ago
• Proposed as answer by PrajapatiNeha 6 hours 7 minutes ago

Alternatively you can see the content of the stored procedures by using sp_helptext (assuming you have sufficient permission),

sp_helptext GetEmployeeCount
sp_helptext GetEmployeeCountByLastInitial

in addition, to list all the stored procedures from your database you can get it as below,

Select * From Sys.Procedures;

• Edited by Aung Mon Chit Htwe 10 hours 35 minutes ago
• Proposed as answer by PrajapatiNeha 6 hours 7 minutes ago

hi ,

You can also design your own shortcut key for getting code from stored procedure.
after that you can simply select your procedure name then press short key.

you can follow below post;
http://techequation.com/create-you-own-shortcut-using-sql-server-managment-studio/

as per above you can select Name of procedure and press CTRL+F1

Thanks

you can see it in Object Explorer details tab

see

http://visakhm.blogspot.in/2013/02/object-filtering-using-ssms-object.html