Wednesday, March 7, 2012

execute SQL file from SQL Server

hello!
is it possible to execute SQL script flat file from SQL Server? I
guess yes, but couldn't find the way for that...
any idea?
thanks.
Vince
++Use Query Analyzer or the OSQL command line utility.
If you really want to execute a script from TSQL code you could use
xp_xmdshell to run OSQL.
David Portas
SQL Server MVP
--|||You can use xp_cmdshell to call OSQL.EXE.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
http://www.sqlug.se/
"Vince .>" <vincent@.<remove> wrote in message news:pl3o41h8tmo9g15v0ffmsth79ni7ikgqht@.
4ax.c
om...
> hello!
> is it possible to execute SQL script flat file from SQL Server? I
> guess yes, but couldn't find the way for that...
> any idea?
> thanks.
> Vince
> ++

No comments:

Post a Comment