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

SQL 2005 express.
I detached an SQL 2005 express database from server A and attached to SQL
2005 express on server B.
When i right click stored procedure from server A i see a PROPERITES
options.
When i do the same from server B ..... NO PROPERTIES option is available.
I view the SPs in both DBs using SQL Express Mgt studio. Both managers are
logged in as SA.
Any ideas ?
Thank
Scott
---
http://www.sage-eshop.comJust a wild guess:
Perhaps the owner of the database isn't a login on server B? See sp_changedbowner.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Scott" <http://www.sage-eshop.com> wrote in message news:uommvsq9GHA.2268@.TK2MSFTNGP05.phx.gbl...
> SQL 2005 express.
> I detached an SQL 2005 express database from server A and attached to SQL
> 2005 express on server B.
> When i right click stored procedure from server A i see a PROPERITES
> options.
> When i do the same from server B ..... NO PROPERTIES option is available.
> I view the SPs in both DBs using SQL Express Mgt studio. Both managers are
> logged in as SA.
> Any ideas ?
> Thank
> Scott
> ---
> http://www.sage-eshop.com
>|||thanks for reply.
i can see sp_changedbowner, it executes ok.
im not exactly sure what i should do with it now.
scott.|||My guess is that the owner for the database (the SID) doesn't exist as a login in the master
database. Try setting the owner to sa, for instance.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Scott" <http://www.sage-eshop.com> wrote in message
news:uF%233%23Hr9GHA.4012@.TK2MSFTNGP04.phx.gbl...
> thanks for reply.
> i can see sp_changedbowner, it executes ok.
> im not exactly sure what i should do with it now.
> scott.
>|||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.|||Might be a bug in the GUI you are using. If you are using the express version of management studio,
you might want to post to an express group. I didn't find such on this news server, but you can try
the HTTP groups:
http://forums.microsoft.com/MSDN/ShowForum.aspx?ForumID=385&SiteID=1
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Scott" <http://www.sage-eshop.com> wrote in message news:et40aRr9GHA.3352@.TK2MSFTNGP03.phx.gbl...
>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.
>|||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.