Home Forums Article Discussions Article Discussions by Author Discuss Content Posted by Zach Nichter Writing to a File Using the sp_OACreate Stored Procedure and OSQL: The RE: Writing to a File Using the sp_OACreate Stored Procedure and OSQL: The

  • November 13, 2006 at 6:43 pm

    #671481

    I just tried the first osql cmd you wrote in SQL 2005 and replaced osql with sqlcmd

    osql command runs in 7 seconds

    sqlcmd runs in 2 minutes 26

    SQL 2005 docs say that sqlcmd is the replacement for osql. Can this be right? Obviously they are structured very differently, but wouldn't you expect that sontinuity of performance might be desirable?

    Regards,

    Steve

    Life without beer is no life at all

    All beer is good, some beers are just better than others