Hi Guys,
I have to some scheduling export to excel like pull every week or daily. i found there is one solution for this is using MS SQL Server Agent.
I guest i able to save the query. But the problem is the query result save in SERVER instead of the shared drive. Anyone have face this problem before?
or maybe you have a better solution for that?
The C:/ drive actually is from server side.