• Hi

    If a user has no permissions on the tables, he cannot even see them in the wizard.

    No way he can export data.

    I cannot imagine a bug this big.

    Remember, when running the export wizard, one is asked for (new) credentials.

    Check again which user was really active when the export was done, and the permissions.

    SA or dbo would not get denied anything, but I suspect you'd excluded that.

    Andreas

    ---------------------------------------------------
    MVP SQL Server
    Microsoft Certified Master SQL Server 2008
    Microsoft Certified Solutions Master Data Platform, SQL Server 2012
    www.insidesql.org/blogs/andreaswolter
    www.andreas-wolter.com