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
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
