Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
How can i guess a sql server is already install on my pc
Message
 
 
To
05/02/2008 09:55:54
Arjun Bagojikop
Dynamic Super Software
Sangli, India
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Environment versions
Visual FoxPro:
VFP 9 SP2
OS:
Windows XP SP2
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01289516
Message ID:
01289532
Views:
10
This message has been marked as the solution to the initial question of the thread.
>hi All
>how can i guess a sql server is already install on my pc through programatically.
>even i want to start and stop service programatically. if any idea please give me suggestion.
>
>thanks in Advance
>Regards From
>arjun

Well, I found the following http://www.devx.com/vb2themax/Tip/18459 and I found some code in Sergey's message:
LOCAL oSQL AS "SQLDMO.SQLServer", ;
  oDatabase AS "SQLDMO.Database"

oSQL = CREATEOBJECT('SQLDMO.SQLServer')
oSQL.Connect(< server name >, < user name >, < password >)
oDatabase = oSQL.DataBases("pubs")
lcCmd = "DBCC CheckDB"
lcMsg = ""
oDatabase.ExecuteWithResultsAndMessages(lcCmd,, @lcMsg)
If it's not broken, fix it until it is.


My Blog
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform