The below query can be used to generate scripts to bring SQL Server Databases from Offline state to Online.
SELECT 'ALTER DATABASE ['+name+'] SET ONLINE'+CHAR(10)+' GO'
FROM MASTER.sys.databases
WHERE name NOT IN ('master','tempdb','model','msdb','distribution') AND state_desc='OFFLINE'
cdx
ReplyDeleteGreat Article it its really informative and innovative keep us posted with new updates. its was really valuable. thanks a lot. Free Generator
ReplyDeleteThis is wonderful and quite informative website design agencies blog I have learnt so many things from here.
ReplyDeleteazure online training
ReplyDeletejava online training
salesforce online training
hadoop online training
Data Science online training
Liên hệ Aivivu, đặt vé máy bay tham khảo
ReplyDeletemua ve may bay di my
giá vé máy bay mỹ về việt nam
giá vé máy bay từ đức về việt nam
chuyến bay từ nga về việt nam
giá vé máy bay từ anh về việt nam
lịch bay từ pháp về việt nam
khách sạn cách ly
vé máy bay chuyên gia nước ngoài sang Việt Nam
The quality of your blogs and conjointly the articles and price appreciating.
ReplyDeletemobile app design services