• vhr2003 (8/3/2010)


    How come deattach/attach can resolve this issue?

    Cheers,

    Vivek

    Hi,

    My guess is that this is file permissions related. That might be why dettach/attach resolves the issue. This causes SQL server to apply an ACL to the mdf and ldf, overwriting your permissions and giving the service account and administrators full access.

    Thanks,

    Gian