I'm in the administrators group on a Windows 2008 database server.
My username appears in the Security -> Logins section of the SQL Server Management Studio and under Properties -> Server Roles I see I have the "public" role only. Under "User Mapping" I'm a member of the "db_datareader" and "public" roles.
I need to add myself to the "db_datawriter" role. When I try, I get error 15247 - User does not have permission to perform this action.
Is there anything I can do to give myself this role? As a Windows administrator on the box I would have thought that it would be possible...
Thanks in advance for helping a very out-of-his-depth developer :)