Sunday, June 25, 2023

SQL Server set databases online

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

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)