Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase ««12

Using COM to Output Queries to a Text File Expand / Collapse
Author
Message
Posted Tuesday, February 12, 2002 12:36 PM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Wednesday, December 17, 2008 5:55 PM
Points: 28, Visits: 34
Thanks Andy, I greatly apprecitae the prompt and informative reply.

Best Regards,

Dunc




Post #19892
Posted Tuesday, March 26, 2002 9:14 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, March 26, 2002 12:00 AM
Points: 1, Visits: 1
I am trying to call the stored proc (which inturn call the DLL) from an update trigger. this is not able to write to the file.

bu if the SP is called directly in query analyser, it's working fine.

can anybody guide me to a solution ?

thanks
-hari




Post #19893
Posted Tuesday, March 26, 2002 11:08 AM
SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: Moderators
Last Login: Yesterday @ 2:51 PM
Points: 6,790, Visits: 1,902
Confirmed permissions on the proc? Are you executing it conditionally?


Andy


Andy
SQLAndy - My Blog!
Connect with me on LinkedIn
Follow me on Twitter
Post #19894
« Prev Topic | Next Topic »

Add to briefcase ««12

Permissions Expand / Collapse