I know to create a file share directory using the standard edition of sql server 2008 r2, I would use the following link: http://msdn.microsoft.com/en-us/library/ms157386.aspx. However, I still have the following question: 1. For writing to the file share directory, I want to be able to write to a directory structure that has three levels. The file share directory would look like: a. higher level would be region like midwest, east-coast, and west-coast. b. The middle level would be state level like Iowa, Ohio, oregon, california, etc... c. The third level would be the city name like Council bluffs (which is in Iowa and higher level would be the midwest). Another example would be the city of Anaheim (which is in California which is in the west-coast.) To be able to store files in this directory strucutre, could I accomplish task using a standard subscription? If so is there a url you can point me to that would give more details? If not, would one of the following two choices be an option: - Write a .net application that would accomplsih this task for me? If so, do you have a url I can look at for a reference? If not, I will look on the internet to see how to write this .net code and/or would you recommend what forum group would I ask this question to? - Would setting up the standard subscription to e-mail addresses help and then use the e-mail addresses to write the file to reports to the file share work?