|
dev
newsgroups
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
sql 2005: statement that will call another scriptIs there a t-sql statement I can use to run another script? Can I call
sqlcmd from within a script? You can use xp_cmdshell to call sqlcmd. If you execute the outer script from sqlcmd, you can use :r
to read and execute another script. -- Show quoteTibor Karaszi, SQL Server MVP http://www.karaszi.com/sqlserver/default.asp http://www.solidqualitylearning.com/ Blog: http://solidqualitylearning.com/blogs/tibor/ "Trex" <randytrex***@hotmail.com> wrote in message news:EYysf.11026$nm.5949@newsread2.news.atl.earthlink.net... > Is there a t-sql statement I can use to run another script? Can I call sqlcmd from within a > script? >  |
|||||||||||||||||||||||
Other interesting topics