blogs.msmvps.com
4TheLuvofSharePoint – Ivan Sanders - Build, Build, Build
http://blogs.msmvps.com/ivansanders
4TheLuvofSharePoint – Ivan Sanders. Build, Build, Build. SQL Query: Set All DBs to the Simple Recovery Model–DEV. Posted by ivansanders on January 19th 2016 to SQL Server. The really cool part about this query is how easy it is to modify. The first section declares the variables, in this case there are 3. The second section, sets the action for each of he declared variables. The last section loops through each DB using the PROC sp MSforeachdb and runs each command, ,. Tempdb' ALTER DATABASE [? You must f...
SOCIAL ENGAGEMENT