one of the ways you can quickly lookup the stored procedure definition in SQL server is using sp_helpText procname . This will print lines each with 255 character that show the code for the stored procedure
if you are trying from a remote machine try this instead
EXEC [ServerName].[DatabaseName].dbo.sp_HelpText 'ProcName'
Another help stored procedure is sp_help . You can inspect a table by running this and passing a table name as a parameter
note when you drag and drop in ssms it may give you a syntax like this
[procfwk].[AlertOutcomes]
you want to change it to [procfwk.AlertOutcomes] for it to work
sp_help [procfwk.AlertOutcomes]
this gives a detailed layout of the table
you can also find out dependencies using sp_depends
sp_depends [procfwk.AlertOutcomes]
sp_who or sp_who2 shows all , but sp_who active shows active users