Scenario: You have a SQL Server, and plenty of databases. Time progresses, and you started using another Disk OR Partition. Let's say you want to know how much space is being taken by all the Databases put together. OR better still, you want to get the details of all the Databases at one shot and not via that Right-Click->Properties thingy...

Here is what could help you...

    Go to SQL Query Analyzer window and ensure that Results to Text (CTRL + T) option is selected.

           
            
    Type the following in Query window and Execute it...
            select 'sp_helpdb ''' + name + '''' + char(10) + 'go'  from sys.databases

    Here is how my output looks like...
           
    Copy the selected part as shown above and execute, and you should get the details about all the tables at one shot. Yeah, this is no rocket science, but quite effective at times.

Cheers,
Rahul

Quote of the day:
An ignorant person is one who doesn't know what you have just found out. - Will Rogers