Thanks Sergey,
if it's not part of the language why does SSMS put it in when generating the script?
>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?
>>