Listing Online and Offline Databases in SQL Server
Hello to everyone,
In this article, I will try to give information about listing online and offline databases in SQL Server.
In SQL Server, in some cases, you may want to list online and offline databases.
You can easily do this using the code below.
--Offline Databases SELECT * FROM master..sysdatabases WHERE status & 512 = 512 AND dbid > 4; --Online Databases SELECT * FROM master..sysdatabases WHERE status & 512 <> 512 AND dbid > 4;
When you run the above code, you will see a result similar to the one below.
As you can see, we have listed online and offline databases.
Good luck to everyone in business and life.