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...

  • D'OH!

    The WHERE recovery_model_desc = 'SIMPLE' should've been = 'FULL'

    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...