SQL Query: Set All DBs to the Simple Recovery Model–DEV

  The Attached Query 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 […]