Is there some sort of command that can tell me which mdf and ldf files are
associated to which databases?

Thanks,
Ninel

SELECT filename, db_name(dbid)
FROM master..sysaltfiles
ORDER BY dbid;


news:65fefd3e38aeb@uwe...
Show quoteHide quote

There may be an easier way to do this, but this will work:

CREATE TABLE #t (dbname sysname, filename sysname)

INSERT INTO #t (dbname, filename)
exec sp_msforeachdb 'USE ?; SELECT ''?'', filename from sysfiles'

SELECT *
FROM #t
ORDER BY dbname

DROP TABLE #t



ngorbunov via SQLMonster.com wrote:
Show quoteHide quote

Get last date in result set
TOP 10 for each group
UDF that take a UDT as a parameter (CLR)
Table reaching max value of identity very early
Crosstab, Pivot?