Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
How retrieve the dir of Sql Server?
Message
De
20/12/2001 15:37:48
 
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00596890
Message ID:
00596984
Vues:
21
>I need get the dir of Sql Server (the data & backup directory).
>
>I don't can use SQL-DMO, because a need do it from a client with only ADO.
>
>I look for a stored procedure, but i don't found something like it...
>
>How can do it?

You can use the following query for this:
SELECT filename 
FROM sysdatabases
WHERE name = 'myDatabaseName'
HTH
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform