Admin role lost - inability to administer database

When I open SQL Server Enterprise Administrator to create or manipulate data
bases errors are thrown at me for not having appropriate permissions. Howeve
r, on one database I am able to modify its contents, tables and so forth.
How have I lost access? What can I do to fix it?Hi,
Are you trying to do this with a user with "DB_OWNER" role. In this case
only the database which is assigned this role will only have the permission.
If you have to perform administrative task on all databases then either
register using "SA" user or a Login with "Sys Admin" server fixed role.
How to identify the role assigned:
1. Login to Query Analyser as "SA"
2. Execute the procedure sp_helplogins <login name>
Note:
Automatically the permissions will never be lost / revoked in SQL server.
Thanks
Hari
MCDBA
"John Russell" <anonymous@.discussions.microsoft.com> wrote in message
news:46C5D23D-730B-4820-97B6-F6A710E73C81@.microsoft.com...
> When I open SQL Server Enterprise Administrator to create or manipulate
databases errors are thrown at me for not having appropriate permissions.
However, on one database I am able to modify its contents, tables and so
forth.
> How have I lost access? What can I do to fix it?