Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
How retrieve the dir of Sql Server?
Message
From
20/12/2001 15:37:48
 
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00596890
Message ID:
00596984
Views:
20
>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
Previous
Reply
Map
View

Click here to load this message in the networking platform