Basically I don’t want my msSQL database accessed directly through a website, mainly because I don’t want it working any harder than it should be.
I want to show specific statistics on my website that will be pulled from the database say once per day and saved to a text file that will be CALLed by the website.
I was thinking I have two options, create an SQL script or create an application to do it. SQL seems the most appropriate way.
What I ask is, is this possible? And can someone point me in the right direction?
Thanks 
