SQL log Truncation

Use [***]
Declare @ dataname nvarchar (100)
Select @ dataname = Name from Master .. sysdatabases where dbid = (select dbid from Master .. sysprocesses where spid = @ spid)
Print @ dataname
Declare @ logfilelogicalname sysname
Select @ logfilelogicalname = Name from SYS. database_files where type = 1
Print @ logfilelogicalname
Declare @ SQL varchar (255)
-- Go
-- Change to the simple mode truncate the log by changing the database recovery model to simple.
Set @ SQL = 'alter database ['+ @ dataname +'] set recovery simple ;'
Exec (@ SQL)
-- Go Truncation
DBCC shrinkfile (@ logfilelogicalname, 1024 );
-- Go
-- Restore to full mode reset the database recovery model.
Set @ SQL = 'alter database ['+ @ dataname +'] set recovery full ;'
Go