I have a stored proc that runs through my databases doing transaction logs. Currently it uses database names but this keeps being changed as a database will be added without me knowing. Next thing the transaction log job is goosed.
I really need something along the lines of select db from sys? where mode = 'Full'
Any help appreciated.
MPM
select * from sys.databases
where recovery_model_desc = 'FULL'
No comments:
Post a Comment