• I second your thoughts. Correct way is to get permissions and I have already asked for that.

    MysteryJimbo (10/1/2012)


    You could create a SQL Account with sysadmin permissions and use this to do the detach/attach. It should work if the service account has host admin priviledges but it is a work around to circumvent security.

    The correct way should be to get the server admin to grant you permissions to the required folders.

    Online Trainer For SQL DBA and Developer @RedBushTechnologies with 18 yrs exp.