To find status of your DB in your SQL Server.

A simple script that is enable me to save lot of time, to find out which database is in runnable status in my server. you can use SQL Profiler but i find this one is very simple for me.hope it helps you friends!!!!

EXEC sp_who