Home Forums SQL Server 2005 Administering Security implications of allowing 'Ad hoc distributed queries' RE: Security implications of allowing 'Ad hoc distributed queries'

  • April 18, 2010 at 9:59 pm

    #1153569

    Thanks for the useful information. it is working ..

    EXEC sp_configure 'show advanced options', 1

    RECONFIGURE WITH OVERRIDE

    EXEC sp_configure 'Ad Hoc Distributed Queries', 1

    RECONFIGURE WITH OVERRIDE

    after running the above statements

    we need to run 'RECONFIGURE' once.

    after if you run the openrowset statement.. the data can be imported from .xls to destination database table.

    Thanks