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 |
|
SergioM
Posting Yak Master
170 Posts |
 Posted - 2013-09-12 : 15:19:14
|
When I follow the tutorials online - using the SQL Server Management Studio 2008 - to view stored procedures, it appears completely blank. But, when I run this query, I see the stored procedure that I've created (multipleOrderSearch)SELECT * FROM sc.information_schema.routines WHERE routine_type = 'PROCEDURE' AND SPECIFIC_NAME LIKE '%multiple%' Is there a setting that might hide stored procedures? More to the point, how would I edit it? In other instances, I would right click and press alter, which shows me everything I need. What do I do here?-SergioI use Microsoft SQL 2008 |
|
|
jackv
Master Smack Fu Yak Hacker
2179 Posts |
Posted - 2013-09-12 : 15:41:17
|
| If necessary ,you could extract the text from the system tables using the query on : http://www.sqlserver-dba.com/2007/03/search_for_text.html and then use ALTER to edit the procedure , assuming you had permissionsJack Vamvas--------------------http://www.sqlserver-dba.com |
 |
|
|
Bustaz Kool
Master Smack Fu Yak Hacker
1834 Posts |
Posted - 2013-09-13 : 13:09:07
|
| Have you been granted "VIEW DEFINITION" rights?=================================================The cure for anything is salt water -- sweat, tears, or the sea. -Isak Dinesen |
|
|
|
SergioM
Posting Yak Master
170 Posts |
Posted - 2013-09-13 : 14:49:17
|
quote:
Originally posted by Bustaz Kool
Have you been granted "VIEW DEFINITION" rights?
I'm the only user/admin on the server. However I've loaded someone else's database. So I can change any of the settings, I just need to know which ones to change. I'll Google the VIEW DEFINITION rights.quote:
Originally posted by jackv
If necessary ,you could extract the text from the system tables using the query on : http://www.sqlserver-dba.com/2007/03/search_for_text.html and then use ALTER to edit the procedure , assuming you had permissions
Thanks, I'll look at this next-SergioI use Microsoft SQL 2008 |
|
|
|
|
|
|
|
|
Cannot See stored procedures