Nope. A script cannot chain to another script. You'll have to run everything together or convert things to stored procedures.
Another option would be to create .bat or .cmd and run all of the scripts using OSQL.exe.
-Mike
>Hi folks
>
>I have a 'set' of scripts which do database set up stuff such as create defaults, indexes, stored procedures etc. I want to be able to run these scripts from another script file so things get done in 1 go. I've searched around but not really have any joy. Does anyone know if this can be done and if so how ?
>
>Regards
>
>Kal