Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
vicki
Posting Yak Master
117 Posts |
 Posted - 2002-04-11 : 15:43:21
|
| Is any one here know what is the comand to run to find out the following information of all the databases in SQL 6.5?Path of dat filesPath of backup filesDate CreatedDate Last updated/usedthanks |
|
|
joldham
Wiseass Yak Posting Master
300 Posts |
Posted - 2002-04-11 : 16:01:36
|
| Not sure if this will help. I did this in SQL 2000 and I wouldn't think it has changed too much.SELECT a.name, a.dbid, a.crdate, a.filename DataFile, b.filename LogFileFROM sysdatabases a, (Select dbid, filename FROM sysaltfiles WHERE right(rtrim(filename),3) = 'LDF') bWhere a.dbid = b.dbidCould not find anything on last used for the database.Jeremy |
 |
|
|
|
|
|
database information