Files associated with a DB

Hi all
Is there any way to find the files/filenames associated with the SQL server instance ?. Is there any way to find it programmatically ? Does Microsoft provide any API for that ?

Thanks in Adcance,
mani3727

Maybe you can use WMI.

See what you can list installed software

In another example you can List Specific Files Included in the Indexing Service

|||

Are you talking about binary files or database files?

If you are using SQL Server 2005 you can use the following code to get all databases related to the instance:

Code Snippet

SELECT * FROM sys.master_files

WesleyB

Visit my SQL Server weblog @. http://dis4ea.blogspot.com

|||Hi Wesley

Thanks for the reply.I want to know all the files associated with a specific SQL server instance.Could you tell me how it can be done programmaically ?

Thanks,
mani3727

Files associated with a DB

Hi all
Is there any way to find the files/filenames associated with the SQL server instance ?. Is there any way to find it programmatically ? Does Microsoft provide any API for that ?

Thanks in Adcance,
mani3727

Maybe you can use WMI.

See what you can list installed software

In another example you can List Specific Files Included in the Indexing Service

|||

Are you talking about binary files or database files?

If you are using SQL Server 2005 you can use the following code to get all databases related to the instance:

Code Snippet

SELECT * FROM sys.master_files

WesleyB

Visit my SQL Server weblog @. http://dis4ea.blogspot.com

|||Hi Wesley

Thanks for the reply.I want to know all the files associated with a specific SQL server instance.Could you tell me how it can be done programmaically ?

Thanks,
mani3727