Home Forums SQL Server 2005 SQL Server 2005 General Discussion EXECUTE a Stored Procedure with NO OUTPUT RE: EXECUTE a Stored Procedure with NO OUTPUT

  • December 15, 2006 at 1:14 pm

    #678449

    I guess you are using the xp_cmdshell to execute the dts package from the procedure...

    use SET NOCOUNT ON also inside the proc...

    xp_cmdshell 'dtsrun /S... /E /N...',  no_output

    See BOL for details...

     

    MohammedU
    Microsoft SQL Server MVP