• Is the problem that on a regular basis your rights are removed from the server?

    The bigger question is why.

    Is this production? If so, and you are not part of the administrators at your company, then the DBA's are doing their jobs.

    There should be no reason for a high level of access to production. Read only maybe, but that's about it

    You can create a script and run it using SQLCMD. The problem here is that you probably do not have the level of rights to get the specific rights assignment for your login.

    sp_helprolemember or sp_helpsrvrolemember should give you what you need.

    Why can't you simply connect, try to do what you need to do, and then ask for permissions is needed?

    Michael L John
    If you assassinate a DBA, would you pull a trigger?
    To properly post on a forum:
    http://www.sqlservercentral.com/articles/61537/