Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2008 Forums
 SQL Server Administration (2008)
 Lock Request Timeout - error 1222

Author  Topic 

Bill_C
Constraint Violating Yak Guru

299 Posts

Posted - 2012-10-01 : 01:40:40
I'm getting this message on one of my databases whilst trying to refresh the list of stored procedures and need to alter/modify one of my Stored Procedures quickly.

My question is:-
Is there a way of opening a stored procedure programatically to alter it without having to right click on it's name and selecting 'Modify'?

i.e
Is there a back door to fire up the command within SQL Server that lists the SP for modification?

Bill_C
Constraint Violating Yak Guru

299 Posts

Posted - 2012-10-01 : 01:50:25
OK, cancel that, got it:-

sp_helptext 'YourSchemaName.YourProcedureName';

Go to Top of Page
   

- Advertisement -