Output Trigger Result to Text Doc

[WurzelGummidge]

Had some help earlier on Finding triggered row. Further to this, would anyone have the code that would:

a) create trigger on order_table insert action
b) get the data from the row that triggered the trigger
c) send this data to a text file

 

[SriSamp]

You can use the contents of the "inserted" pseudo table and then use the sp_OA* stored procedures to create the text file on the server. See the SQL Server BOL to get more details on these procedures. Its too huge to mention here...

HTH,
SriSamp

 

[WurzelGummidge]

Excuse my ignorance but what / where is 'Sql Server BOL'?

 

[JamesLean]

What are SQL Books Online & Where Can I Find Them?
faq183-689 --James

 

[sguslan]

Books online can be found from windows Start->Programs->sql server. ________________________________________________________________________________
If you do not like change, get out of the IT business...

 

[sguslan]

http://msdn.microsoft.com/nhp/default.asp?contentid=28000409

is an online version on the MSDN site. On the left pane expand the SDK Doumentation icon ... ________________________________________________________________________________
If you do not like change, get out of the IT business...