I have recently had to take ownership of a MSSQL 2005 install.
There is only one database, with several tables and views, and I should have full permissions to everything, as far as I can tell. However, I am unable to
Modify views (greyed out) or use
Script View as -> CREATE To -< ... to copy a View (gives an error saying I don't have permission).
I notice that pre-existing Views have a little padlock icon on them, where as new one's I create do not. I have checked
Properties -> Permissions and ensured that I have full permission of the view, which I do, so from here I'm a little lost.
Can someone please give me some pointers as to what I should be checking, to ensure permissions are set up correctly? Thanks.