Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Create SQL Server database from VFP Code
Message
From
09/11/2006 09:49:50
 
General information
Forum:
Visual FoxPro
Category:
Client/server
Environment versions
Visual FoxPro:
VFP 9 SP1
Database:
MS SQL Server
Miscellaneous
Thread ID:
01168252
Message ID:
01168432
Views:
13
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?
>>
Frank.

Frank Cazabon
Samaan Systems Ltd.
www.samaansystems.com
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform