I am writing a stored procedure for a database that will be managed from the web via asp. I need the function to be able to determine the full path to the database so it can create a new table file in the same location. dbgetprop doesn't seem to have what I need.

Is there a way to do this?