November 13, 2006 at 7:44 am
Hi,
I am unable to alter a table in Query Analyzer. I'm hoping that someone can tell me what permissions are required to do so. I am a developer and have communicated this problem to my IT group. They have told me that I have dbo rights to the database and that they don't know why I am unable to alter tables. Both "Alter" and "Execute" options are grayed-out.
Thanks in advance for your help!
Rachel
November 13, 2006 at 8:19 am
Hi,
These two option are gray out when you need to modify a table. As when you use alter on a table its means that you need to modify the column or constraints. That why it disbled that you make it according your logic. Its very ODD that you should make the full alter of a table all its column and contrainst. If you need a full alter then you should drop and create the table with migration script to store a data. Otherwise just use the
ALTER TABLE to the specific column/constrainst you want to modify...
Same is with the execute ... what you want to get the execute as this is normaly used for the stored procedure and view rather then table object.
I think you got the answer of your question...
cheers
November 14, 2006 at 5:16 am
What do you expect to see if you have ALTER option available?
I feel that the menu item of Right Click is common for all objects and will be disabled and enabled based on object selected.
Hope this helps.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply