Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
BobRoberts
Posting Yak Master
109 Posts |
 Posted - 2010-02-10 : 12:16:16
|
| I've had some disk problems lately, and maybe that relates to this question. I'm running SQL 2008 Express, and not getting any sort of errors. However, when I right-click a stored procedure and click properties, and then click Permissions, I get a form that says Owner at the top left, with no Add or Remove button to add new Users or roles. Before, when I clicked Permissions, I got a very similar looking screen, but it said Schema on the top left, and it had buttons to Add and Remove users or roles.I have screenshot jpegs showing before and after, but I don't think this forum allows uploading of images. |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2010-02-10 : 12:19:08
|
quote:
Originally posted by BobRoberts
I've had some disk problems lately, and maybe that relates to this question. I'm running SQL 2008 Express, and not getting any sort of errors. However, when I right-click a stored procedure and click properties, and then click Permissions, I get a form that says Owner at the top left, with no Add or Remove button to add new Users or roles. Before, when I clicked Permissions, I got a very similar looking screen, but it said Schema on the top left, and it had buttons to Add and Remove users or roles.I have screenshot jpegs showing before and after, but I don't think this forum allows uploading of images.
you can post the images on hosted server and post link here------------------------------------------------------------------------------------------------------SQL Server MVP |
 |
|
|
BobRoberts
Posting Yak Master
109 Posts |
Posted - 2010-02-11 : 09:41:33
|
| I'm not sure I know what you mean by "hosted server". Can you post detailed instructions on how to upload to and link to files on this server? I think I've done a fairly good job in describing the problem - I'm not sure that pictures are really necessary. |
|
|
|
|
|
|
|
|
Stored Procedure Properties Permissions