Post reply

T-SQL Print Command help please

  • September 6, 2005 at 10:29 am

    #587849

    triggers are to be used more for referential integrity than anything else...when a new sales order is inserted in the database, does your application not get "refreshed" with the added row ?!?!

    Seems to me that this is really something that the company you bought the package from should be doing!!! Guess that's out of the question huh ?!







    **ASCII stupid question, get a stupid ANSI !!!**

  • September 6, 2005 at 10:29 am

    #587848

    The PRINT statement in a trigger is only there for testing & development.  Under no circumstances should it be part of your application.  I understand having FoxPro or Access or custom code as your application interface, but you should work on triggers in SQL Server.

    There are many ways to accomplish your application goal.  The most obvious is to create an email message in the trigger using xp_sendmail.

Viewing 2 posts - 16 through 16 (of 16 total)

You must be logged in to reply to this topic. Login to reply