Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Dbcc checkdb
Message
 
 
À
16/12/2003 05:50:01
Information générale
Forum:
Visual FoxPro
Catégorie:
Client/serveur
Titre:
Divers
Thread ID:
00859417
Message ID:
00859433
Vues:
20
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--
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform