Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
DBCC via SQLPT - How to get the results/msgs ??
Message
De
22/07/2004 23:46:14
 
 
À
21/07/2004 14:48:03
Information générale
Forum:
Visual FoxPro
Catégorie:
Client/serveur
Divers
Thread ID:
00926652
Message ID:
00927272
Vues:
15
Hi Mark.

That's perfect.

Thanks so much :-D

Scott
=======
>Use the "WITH TABLERESULTS" option.
>
>DBCC CHECKDB WITH TABLERESULTS
>
>>Hi there.
>>
>>I'm having trouble figuring out how to get the results/messages back from a sql passthrough call that does a DBCC on the SQL server. When I run the lcCmd shown below, it executes successfully, but the DBCC_Res cursor is not generated. (which I kinda' figured it might not be)
>>
>>
>>lcCmd = [DBCC CHECKDB ('TestDB')]
>>lnResult = sqlexec(lnHandle, lcCmd, 'DBCC_Res')
>>
>>So, is there an @@ variable I can retrieve on the very next sql call or something???
>>
>>TIA, Scott :-D
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform