Delete Database Log

ALTER   proc [dbo].[usp_del_log]
 @dbname varchar(50)
as
backup log @dbname with no_log
dbcc shrinkdatabase(@dbname,50)