>>From my .NET application, I need to be able to execute a script against SQL Server. I have this script. It takes about 0.5 second to execute. I need to have it from the Web administration interface so I wouldn't have to get into SQL Server to execute it.
>>
>>Is the best approach to create a stored procedure and use my regular data class from the framework to execute this? Or, is there a way to have this script sitting in a directory and simply executing it and collect the result into a TXT file?
>
>I would suggest to simply use Stored Procedure.

I would agree. I'm not sure what you would gain by executing a script file instead of just a Stored Procedure.