Quickly generate script to bring all SQL Server Databases offline.
SELECT 'ALTER DATABASE ['+name+'] SET OFFLINE WITH NO_WAIT'+CHAR(10)+' GO' FROM
MASTER.sys.databases
WHERE name NOT IN ('master','tempdb','model','msdb','distribution')
TechBrothersIT is the blog spot and a video (Youtube) Channel to learn and share Information, scenarios, real time examples about SQL Server, Transact-SQL (TSQL), SQL Server Database Administration (SQL DBA), Business Intelligence (BI), SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), Data Warehouse (DWH) Concepts, Microsoft Dynamics AX, Microsoft Dynamics Lifecycle Services and all other different Microsoft Technologies.
SELECT 'ALTER DATABASE ['+name+'] SET OFFLINE WITH NO_WAIT'+CHAR(10)+' GO' FROM
MASTER.sys.databases
WHERE name NOT IN ('master','tempdb','model','msdb','distribution')
I read this blog, Nice article...Thanks for sharing waiting for the next...
ReplyDeletecore java training in chennai
core java training institutes in chennai
Best core java Training in Chennai
core java training in anna nagar
core java training in vadapalani
C C++ Training in Chennai
javascript training in chennai
Hibernate Training in Chennai
LoadRunner Training in Chennai
Mobile Testing Training in Chennai
IEEE Final Year Project centers make amazing deep learning final year projects ideas for final year students Final Year Projects for CSE to training and develop their deep learning experience and talents.
DeleteIEEE Final Year projects Project Centers in India are consistently sought after. Final Year Students Projects take a shot at them to improve their aptitudes, while specialists like the enjoyment in interfering with innovation.
corporate training in chennai corporate training in chennai
corporate training companies in india corporate training companies in india
corporate training companies in chennai corporate training companies in chennai
I have read your blog its very attractive and impressive. I like it your blog. Digital Marketing Company in Chennai Project Centers in Chennai
Beautiful simplicity. Perfect!! Thank you.
ReplyDeleteNicest information!!! I'll be enchanted to greatly help due to what I've learnt from here.
ReplyDeleteuser experience design agency
He arrived on time, and expertly investigated and recognized the problem.
ReplyDeleteweb design SF
This article will outline all the different strategies you should be aware of when it comes to soccer.
ReplyDeletebest ias coaching in india
This web page has given me loads to keep in mind and what I wanted for years!! What an extraordinary solution to design studios!!
ReplyDeletecompany logo design
very very informative post for me thanks for sharing
ReplyDeleteBlockchaincClassroom Training Course in Bangalore
This is most informative and also this post most user friendly and super navigation to all posts... Thank you so much for giving this information to me..
ReplyDeleteBest MPSC Coaching in Mumbai
Best IAS Coaching in Navi Mumbai
Best IAS Coaching in dadar
Best IAS Coaching in Thane
Best IAS Coaching in Andheri
Best IAS Coaching in Mumbai
Best ias coaching in borivali
Best IAS Coaching in bhandup
Every day I visit a number of blog sites to see content, however this offers quality based content.
ReplyDeletebrand strategy firms
MPPSC Coaching in IndoreGet Free MPPSC Notes and MPPSC Study Material for preparation of MPPSC Exam.>
ReplyDeleteHi, I have just started to SQL Certification Online. and this blog is really informative for me. Keep us posted for this kind of valuable blog. Thank you for this blog!
ReplyDeleteI liked your blog because there is a lot of good information in it, if you look for java script in
ReplyDeleteTraining Services Company in Dinanagar then you will not get anything better than Satyam Technology.