SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 General SQL Server Forums
 New to SQL Server Administration
 Cannot See stored procedures
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

SergioM
Posting Yak Master

168 Posts

Posted - 09/12/2013 :  15:19:14  Show Profile  Reply with Quote
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?

-Sergio
I use Microsoft SQL 2008

jackv
Flowing Fount of Yak Knowledge

United Kingdom
2076 Posts

Posted - 09/12/2013 :  15:41:17  Show Profile  Visit jackv's Homepage  Reply with Quote
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

Jack Vamvas
--------------------
http://www.sqlserver-dba.com
Go to Top of Page

Bustaz Kool
Flowing Fount of Yak Knowledge

USA
1770 Posts

Posted - 09/13/2013 :  13:09:07  Show Profile  Reply with Quote
Have you been granted "VIEW DEFINITION" rights?

=================================================
The cure for anything is salt water -- sweat, tears, or the sea. -Isak Dinesen
Go to Top of Page

SergioM
Posting Yak Master

168 Posts

Posted - 09/13/2013 :  14:49:17  Show Profile  Reply with Quote
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

-Sergio
I use Microsoft SQL 2008
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.06 seconds. Powered By: Snitz Forums 2000