AK1516 (10/11/2013)
I have used the filetable to store the tsql scripts. what can be the best way to run them against the server. the only road block i have using the exec(@sql) or execute_sql (@command) is the 'GO' statement in the filetable script.Any help will be appriciated. Thanks
Take the GO out. It won't work with EXEC or EXECUTE_SQL. If the GO is important to the success of the script, then you will need to split the script at the GO and execute each section separately.
--Jeff Moden
Change is inevitable... Change for the better is not.