Sunday, June 25, 2023

SQL Server set databases offline

select 'ALTER DATABASE [' + A.Name + '] SET OFFLINE WITH ROLLBACK IMMEDIATE;'
from sys.databases a
where a.database_id > 4
and state_desc ='ONLINE'
and a.name not in ('SSISDB')
order by a.name

No comments:

Post a Comment