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')
Label
- C# Scripts
- DWH INTERVIEW QUESTIONS
- MS Dynamics AX 2012 R2 Video Tutorial
- MariaDB Admin & Dev Tutorial
- MySQL / MariaDB Developer Tutorial Beginner to Advance
- MySQL DBA Tutorial Beginner to Advance
- Project / Work Support
- SQL SERVER DBA INTERVIEW QUESTIONS
- SQL SERVER DBA Video Tutorial
- SQL Server / TSQL Tutorial
- SQL Server 2016
- SQL Server High Availability on Azure Tutorial
- SQL Server Scripts
- SQL Server on Linux Tutorial
- SSIS INTERVIEW QUESTIONS
- SSIS Video Tutorial
- SSRS INTERVIEW QUESTIONS
- SSRS Video Tutorial
- TSQL INTERVIEW QUESTIONS
- Team Foundation Server 2013 Video Tutorial
- Team Foundation Server 2015 Video Tutorial
- Windows 10
- Windows Server 2012 R2 Installation Videos
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
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