Useful SQL commands

SQL-ServerCommands.sql

-- Display all the database names on the instance
EXEC sp_databases

-- Display database size
USE database_Name;
GO EXEC sp_spaceused N'table_Name';
GO

-- Put the db in read-only mode
USE master EXEC sp_dboption 'Nom_Database', 'read only', 'TRUE'

-- Put the db offline
EXEC sp_dboption 'Nom_Database', Offline, 'True'

-- Display log size
DBCC SQLPERF (LOGSPACE)