MS SQL Server - Re: no "properties" option on stored procedures (cant set permissions)

You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author

Re: no "properties" option on stored procedures (cant set permissions)

Dave Griffiths

2006-10-31, 12:15 am

Hi ..

I'm getting exactly the same issue.. We've gone and created our
databases in SQL Express, but have a code generator that needs to look
at extended proeprties on the stored procedures. In SQL Express
databases, the Properties option is not available for SP's,

Personally I just think this is a bug in the Management Studio UI too,
as Properties is available for the other objects such as Tables,
Databases (do it's not that SQL Express doesn't supoprt Extended
Properties, which was my first guess).

If you get any luck, please post a message here.

Scott wrote:
> i created a new DB and new SP and still dont get the properties.
>
> if the user has the ability to create a DB and SPs in the db, they should
> have the ability to view/amend properties.

Sponsored Links