i have a table in which records are coming with 3 different priorities. like A priority, B priority and C priority. On every A priority record insertion i am sending emails to department heads using SQL Server pre built stored procedure on post insert trigger. I want to print that A priority record on dedicated printers as soon as it receive.
Appreciate the response and suggestions. thank you.
Waqas
Jignesh TrivediPosted Mar 18, 2014, 2:33 AM
Hi,
I am not sure whether is it possible with SQL server query or not?
but we can achieve this by using C# right?
In this case we can use CLR function with SQL and from your trigger or SP you can call this CLR function.
Please refer below link for how to create CLR function with SQL server
http://www.c-sharpcorner.com/UploadFile/ff2f08/clr-function-in-sql-server-2005/
hopr this will help you.