Results 1 to 4 of 4
  1. #1
    Join Date
    Dec 2002
    Posts
    2

    Unanswered: automatic printing from trigger

    Hi,
    I am new to Sql Server 2000. I am looking for help on how to automatically generate a report to a network printer after a record is added/updated/changed in a table. How should I do this? With a Trigger? With DTS?

    Please help.

  2. #2
    Join Date
    Dec 2002
    Location
    Czech Republic
    Posts
    249

    Re: automatic printing from trigger

    With a Trigger ...

  3. #3
    Join Date
    Dec 2002
    Posts
    2

    Re: automatic printing from trigger

    Thanks for the info. I think I was unclear in my initial question and would like to know what are the exact steps needed to perform this function? I don't know how to create a trigger to do this and would be looking for an example of some sort or instructions for the code.

    Any help greatly appreciated.

  4. #4
    Join Date
    Dec 2002
    Location
    Czech Republic
    Posts
    249
    What about sp_OA... procedures, write component in any language
    and use these SP for communication.

    Export with DTS or SQLDMO objects.

    Multitask temp tables with :
    1.X=OBJECT_ID('temp..#temptbl')
    2.Send X to object
    3.Get temp name
    use tempdb
    GO
    Y=OBJECT_NAME(X)

    Too much work to be done ...
    MSSQLSERVER2K has native support for e-mail and pager.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •