Stored Procedures not accessible

Question

Stored Procedures not accessible

Prasad.Kawade

SSC Veteran

Points: 292
More actions
July 5, 2016 at 10:23 pm

#308845

Hi,
Please help me here.
I am not able to access stored procedures but I can access functions, tables, views and other objects.
Can somebody please help me here ? I am not getting what is the reason. I got suggestions that this issue is related to SQL Server 2014. I believe this issue is related to access.
Can somebody please tell me what is this related to and how this to be resolved.
Thanks in advance

Viewing 9 posts - 1 through 8 (of 8 total)

You must be logged in to reply to this topic. Login to reply

johnwalker10 SSCrazy Eights Points: 9124 More actions · Answer 1

Take a look at this link, hope this will help you: http://stackoverflow.com/questions/13307589/unable-to-access-stored-procedures-on-localhost

durga.palepu Hall of Fame Points: 3530 More actions · Answer 2

Can you check whether the stored proc is encrypted or you have proper access permissions on that proc?

Sid:) SSC-Addicted Points: 412 More actions · Answer 3

This issue may occur when you have read-write permission, but don't have ddl_admin permission.

Get execute permission from your DBA to execute procedure.

Command:

Grant Execute to [userName];

Ref.

http://stackoverflow.com/questions/9321334/grant-execute-to-all-stored-procedures

Prasad.Kawade SSC Veteran Points: 292 More actions · Answer 4

Hi Everyone,

Thanks for the reply.

It's not about any specific SP. I can access all other SQL objects such as Functions, Tables, Views etc.

If I try to check SP, it shows message as 'unknown property IsNativelyCompiled (Microsoft.SQLServer.Management.Sdk.Sfc)'. I tried to search this but no concrete solution found. I have tried some patches of SP1 with CU5,6,7 but nothing worked. I have also tried installing SQL Server 2016 but everything went in vain.

Please let me know what is this issue and how to resolve this.

Thanks again.

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 5

Sounds like you're using an old version of Management Studio with a new version of SQL. What do the following show:

SELECT @@Version

In Management Studio: Help -> About

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass