Free "Execute this/these T-SQL scripts in a translation" Utility from xSQL Software (aka "Query Analyzer is scary to users but they still need to execute T-SQL scripts" Utility...)

xSQL Software - xSQL Script Executor

"Free utility that provides for transactional execution of T-SQL scripts

• Execute multiple scripts at once

• Support different transactional execution

• Robust error handling

• Command line options for batch execution

• Simple and intuitive interface

Script executor is a small, free utility that allows you to run multiple T-SQL scripts at once against a Sql Server database. You can choose to run a single script file or a group of files identified by a pattern. You can select different script execution modes, run it interactively via the user interface or in batches via the command line options.

..."

If Query Analyzer is overkill or to scary to give to your users, but those same users need to execute one or more T-SQL scripts, then this little utility may come in handy for you.

In a very brief, quick and dirty test, it worked just fine for me, even where the T-SQL script contained a number of embedded GO statements...

It can also be used via the command line, which could come in handy too (the UI will help you with that in that you can set everything up in the UI and then click on the Show Command Line button to see the final/finished command line...which is a nice touch)

 

Related Past Post XRef:
RSS Reporter for SQL Server V2 Released (with Custom Query Support & Database Size Feed)
RSSReporter - SQL Server Job Status via RSS Feeds