List file names

  • How can i list all database names and mdf files corresponding in an instance.

  • try:

    select name, filename from master.sys.sysdatabases

    The probability of survival is inversely proportional to the angle of arrival.

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply