>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