view stored procedures stored in ms studio code example

Example: mssql describe stored procedure sqlcmd

sp_helptext <name of your sp>