Home Forums SQL Server 2008 T-SQL (SS2K8) Use a SELECT to ALTER properties of all databases of certain type... RE: Use a SELECT to ALTER properties of all databases of certain type...
jasona.work
SSC Guru
Points: 50070
More actions
October 22, 2013 at 10:40 am
#1660604
D'OH!
The WHERE recovery_model_desc = 'SIMPLE' should've been = 'FULL'
WHERE recovery_model_desc = 'SIMPLE'
Thanks.
I hadn't thought of the dynamic SQL idea, although I'm now messing with that to try to check what DBs SQL Logins might have access to before dropping them...