I'm not a SQL admin, but I have rights to the SQL server granted from the old DBA that was with our company.
We have a new IT manager that wants DBA level permissions to our SQL servers and I don't know how to grant it to him.
POLITICS ASIDE as to whether it is a good idea to do this or not...
How can I grant DBA level (full) rights to a SQL server and all of its databases? Can I do it across all instances somehow?