ActiveX DLL from Stored Proc and file access permissions

[h109]

Hi,
I've written a stored procedure which calls a ActiveX DLL that writes toa textfile.

If I execute the stored procedure from Query analyzer, it works fine and the text file is created with the data from a table.

But, if I call the same stored procedure from a database trigger, the textfile is blank. I think it has some thing to do with write permissions to the text-file/directory when called thro' the TRIGGER.

I've logged in to the system with a username having administrator privileges.

Please point in the right direction to solve this problem.

Thank you kindly,
-hari