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.With a 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.|||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.
No comments:
Post a Comment