Showing all Databases

  • Import the text file into a table and do the necessary formatting from there. Else you can also try with excel if the number of rows in the text file is less than 64K so that it gets into a single sheet.

    Cheers,
    Sugeshkumar Rajendran
    SQL Server MVP
    http://sugeshkr.blogspot.com

  • Sugesh, your script doesn't show multiple instances on one box. Also, it's showing databases that are off-line or suspect (which may or may not be desirable, for me, I wouldn't want off-line DBs).

    This is a tricky little problem! I'd like to experiment with the linked server approach, but I'm not sure about identifying the multiple instances issue.

    -----
    [font="Arial"]Knowledge is of two kinds. We know a subject ourselves or we know where we can find information upon it. --Samuel Johnson[/font]

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

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