CHANGE RECOVERY MODEL BY USING QUARY

--------BY USING QUARY TO CHANGE RECOVERY

SELECT name, recovery_model_desc FROM sys.databases WHERE name = 'manju1'

USE [master]
GO
ALTER  DATABASE  [manju1]  SET RECOVERY FULL WITH  NO_WAIT
GO

ALTER DATABASE [manju1] SET RECOVERY SIMPLE WITH  NO_WAIT

select * from sys.databases