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.
| 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'; |
 |
|
|
|
|
|
Lock Request Timeout - error 1222