Home Forums SQL Server 2008 T-SQL (SS2K8) TSQL to create Excel 2013 file RE: TSQL to create Excel 2013 file

  • August 24, 2014 at 5:32 am

    #1740569

    What permission does the user have who's running that code?

    Based on MS Technet

    Only members of the sysadmin fixed server role can execute sp_OASetProperty.

    If you're not a member of the sysadmin role, this might be the reason for not creating the file.


    Lutz
    A pessimist is an optimist with experience.

    How to get fast answers to your question[/url]
    How to post performance related questions[/url]
    Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]