Forum Replies Created

Viewing 15 posts - 1 through 15 (of 760 total)

  • RE: TSQL to create Excel 2013 file

    Does this work for anyone??....Can someone please test the code on your local box and let me know??...Thanks

  • RE: TSQL to create Excel 2013 file

    Lowell (8/25/2014)


    correct me if i'm wrong, but I thought noone can write to a file on the root of the C drive unless they are running elevated, admin priviledges:

    so C:\CambridgePubs.xlsx...

  • RE: TSQL to create Excel 2013 file

    LutzM (8/24/2014)


    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...

  • RE: TSQL to create Excel 2013 file

    Permissions don't seem to be the issue either. I am doin this on my laptop. There is only one user on my laptop. So, permissions are also fine.

    Please help...

  • RE: TSQL to create Excel 2013 file

    Eirikur Eiriksson (8/24/2014)


    vinu512 (8/24/2014)


    Eirikur Eiriksson (8/24/2014)


    Further on Lutz's question, what is the output of the code in your initial post? Note that all the sp_OA* procedure return 0 if successful,...

  • RE: TSQL to create Excel 2013 file

    Eirikur Eiriksson (8/24/2014)


    Further on Lutz's question, what is the output of the code in your initial post? Note that all the sp_OA* procedure return 0 if successful, otherwise a non-zero...

  • RE: TSQL to create Excel 2013 file

    LutzM (8/24/2014)


    this is not working for some reason

    doesn't include any details what the issue might be.

    Is there any error message?

    Hi LutzM,

    Following is the error message:

    Operation is not...

  • RE: TSQL to create Excel 2013 file

    Eirikur Eiriksson (8/24/2014)


    Quick thought, looks to me that the only thing missing is to enable Ole Automation Procedures

    😎

    Enable Ole Automation Procedures in T-SQL

    sp_configure 'show advanced options', 1;

    GO

    RECONFIGURE;

    GO

    sp_configure 'Ole Automation Procedures',...

  • RE: Creating tables on the fly with SSIS

    Phil Parkin (8/11/2010)


    Rich-403221 (8/11/2010)


    :ermm: Phil, my apologies.

    Should have tried it a little more before I ASSUMED that SSIS would be logical. Guess it's not as straight forward as I thought.

    Rich

    No...

  • RE: Dynamic Data Export

    So...is there no way of doing it??

  • RE: Dynamic Data Export

    Guys,

    Any Luck???

    I haven't been able to find a way around this one yet.....Any help guys??

  • RE: Unexpected Behaviour With SQL Server :,(

    Shadab Shah (7/17/2013)


    vinu512 (7/16/2013)


    Is Auto Update of Statistics on the Database Disabled??....Check both AUTO CREATE STATISTICS and AUTO UPDATE STATISTICS.........If any of them are disabled then enable them as follows:...

  • RE: Unexpected Behaviour With SQL Server :,(

    Shadab Shah (7/17/2013)


    kapil_kk (7/17/2013)


    vinu512 (7/16/2013)


    Is Auto Update of Statistics on the Database Disabled??....Check both AUTO CREATE STATISTICS and AUTO UPDATE STATISTICS.........If any of them are disabled then enable them as...

  • RE: Help needed for Select Query

    Very nice work Alan.

    I converted Alan's code to work Dynamically(Just in case you have more than 2 tables) as follows:

    IF OBJECT_ID('tempdb..TargetActivity') IS NOT NULL

    DROP TABLE TargetActivity;

    CREATE TABLE Customer

    (CustomerIdint...

  • RE: Unexpected Behaviour With SQL Server :,(

    Is Auto Update of Statistics on the Database Disabled??....Check both AUTO CREATE STATISTICS and AUTO UPDATE STATISTICS.........If any of them are disabled then enable them as follows:

    -- Enable Auto...

Viewing 15 posts - 1 through 15 (of 760 total)