The "GO" statement isn't a part of T-SQL language. You'll have to parse script and send each batch separatelly.
>
>I've got some code that gets the available SQL servers and now I want to allow the user to create a database on a selected server. So I've got the name of the new database and some code that connects to the server. How do I now create the database? I tried:
>
<snip>
>
>which is basically copied from the CREATE script for the database in SQL Server Management Studio.
>
>Obviously there are some problems in that I have the hard coded path to the files. Is there a way that I can find out where the default path for files are on a particular server?
>
>However, I am getting llSuccess to be .F. all the time. Am I trying to do too much? Or is this possible? Anybody willing to show me an example of what they have done?
>