Home Forums Article Discussions Article Discussions by Author Discuss Content Posted by Joseph Sack Capturing The Error Description In A Stored Procedure RE: Capturing The Error Description In A Stored Procedure

  • July 21, 2008 at 3:22 pm

    #846036

    sql_er (7/21/2008)

    Zendada,

    Thank you for the reply - I am still a bit confused though.

    My question was referring to the approach used by the original article. If I follow that approach as is, with no modifications, and the excel template will reside on the server with no MS Excel installed, will this approach work?

    Thanks a lot!

    Oh sorry, I thought you were referring to my post. I just re-read the article. I don't see anything in the article that requires the Excel object model on the server, so you don't need the excel app on it. The delete and create table statements don't require it. Make sure you use ticks and not apostraphes just as in the article. Neither does the SMTP code require Excel (instructions for that are in the article). Hope that helps.

    [font="Courier New"]ZenDada[/font]