Dave,

Take a look at http://www.umachandar.com/technical/SQL2000Scripts/UtilitySPs/Main7.htm and http://mysite.freeserve.com/nigelrivett/WriteTextFile.html.
I would not recommend to do that from within a trigger because you should keep transactions as short as possible and disk access is relatively slow.

>SQL Server 7.0/2000
>
>Hi,
>
>Is it possible to create a text file on directory c: since a trigger or StoredProc ?
>
>If yes, what is the syntax ?
>
>Thank in advance.
>
>Dave
>Technologies Nter