Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Dbcc checkdb
Message
 
 
To
16/12/2003 05:50:01
General information
Forum:
Visual FoxPro
Category:
Client/server
Title:
Miscellaneous
Thread ID:
00859417
Message ID:
00859433
Views:
19
Jörg,

You can use SQLDMO
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)
...
>Hi!
>
>In the Query Analyzer I can check the Database on the SQL Server with
>
dbcc checkdb
>In the Message page I can read the result of the command.
>
>Now I call the dbcc checkdb command from VFP via sqlExec() it works, bud i do not get the result of the check. How can I get this? I do not get any Cursor.
--sb--
Previous
Reply
Map
View

Click here to load this message in the networking platform