I fully agree with Dejan.
Still if you want to do it, it can be done in a round
about way. You have to capture all the records from
inserted and deleted tables into a temp table inside your
trigger as these tables are not accessible outside the
Use DTS to out the records of this temp table into a .txt
Then use something like this:
set PrinterName = '\\scbdc\pcg laserjet5000'
print 'There '
+ case printrequestcount
when 0 then 'are no reports'
when 1 then 'is 1 report'
else 'are '+ convert(varchar(3),PrintRequestCount)
+ ' waiting to be printed.'
if PrintRequestCount > 0
exec master.dbo.xp_cmdshell 'isqlw -SJasper2 -
dReporting -Usa -Pinsql -ic:\print.sql -oc:\ReportOut.txt'
set Command = 'copy c:\reportout.txt "'+PrinterName+'"'
exec master.dbo.xp_cmdshell Command
Like I said before, its not recommended this way.