Truncates and shrinks log files for each user database on MS Sql server.

declare @ssql nvarchar(4000)
set @ssql= '
        if ''?'' not in (''tempdb'',''master'',''model'',''msdb'') begin
        use [?]
        declare @tsql nvarchar(4000) set @tsql = ''''
        declare @iLogFile int
        declare LogFiles cursor for
        select fileid from sysfiles where  status & 0x40 = 0x40
        open LogFiles
        fetch next from LogFiles into @iLogFile
        while @@fetch_status = 0
        begin
          set @tsql = @tsql + ''DBCC SHRINKFILE(''+cast(@iLogFile as varchar(5))+'', 1) ''
          fetch next from LogFiles into @iLogFile
        end
        set @tsql = @tsql + '' BACKUP LOG [?] WITH TRUNCATE_ONLY '' + @tsql
        --print @tsql
        exec(@tsql)
        close LogFiles
        DEALLOCATE LogFiles
        end'

exec sp_msforeachdb @ssql

Clear all keys(indexes) and constraints for rebuild
create 2 procedures below in your DB
then exec the following
EXEC sp_MSforeachtable "Utils_drop_constraints '?'"
EXEC sp_MSforeachtable "Utils_DeleteAllIndexesOnTable '?'"

-------------------------------------------------------------------------------------
---Drop all contraints on a table
--- for all tables in DB use: EXEC sp_MSforeachtable "sp_drop_constraints '?'"
---
SET QUOTED_IDENTIFIER  OFF   
SET ANSI_NULLS  ON
GO

if exists (select * from sysobjects where id = object_id(N'[dbo].[Utils_drop_constraints]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[Utils_drop_constraints]
GO

create proc Utils_drop_constraints @tablename sysname
as

-- name:   sp_drop_constraints (renamed by SAM)
-- author: douglas bass
-- date:   06/19/2000
-- sp_drop_constraints will drop all constraints on the specified table,
-- including CHECK, FOREIGN KEY, PRIMARY KEY, UNIQUE, and DEFAULT constraints. 
-- Compile it in your master database and use it from any user database.

set nocount on

declare @constname sysname,
 @cmd  varchar(1024)

declare curs_constraints cursor for
 select  name
 from  sysobjects
 where  xtype in ('C', 'F', 'PK', 'UQ', 'D')
 and (status & 64) = 0
 and     parent_obj = object_id(@tablename)

open curs_constraints

fetch next from curs_constraints into @constname
while (@@fetch_status = 0)
begin
 select @cmd = 'ALTER TABLE ' + @tablename + ' DROP CONSTRAINT ' + @constname
 exec(@cmd)
 fetch next from curs_constraints into @constname
end

close curs_constraints
deallocate curs_constraints

return 0

GO
SET QUOTED_IDENTIFIER  OFF   
SET ANSI_NULLS  ON
GO
---end drop all constraints
--++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

-------------------------------------------------------------------------------------
---Drop all indexes on a table
--- for all tables in DB use: Exec sp_MSforeachtable "Utils_DeleteAllIndexesOnTable '?'"
---
/******  ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO

if exists (select * from sysobjects where id = object_id(N'[dbo].[Utils_DeleteAllIndexesOnTable]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[Utils_DeleteAllIndexesOnTable]
GO

create PROCEDURE [dbo].[Utils_DeleteAllIndexesOnTable] @TableName VarChar(200)
AS
BEGIN
Declare @IndexName varchar(200)

DECLARE index_cursor CURSOR FOR
SELECT name FROM sysindexes where id = object_id(@TableName)
AND NAME IS NOT NULL --and ROWS > 0

OPEN index_cursor

-- Perform the first fetch.
FETCH NEXT FROM index_cursor into @IndexName

WHILE @@FETCH_STATUS = 0
BEGIN

if left(@IndexName,2) = 'PK'
BEGIN
print 'drop constraint ' + @IndexName + ' on ' + @TableName
Exec( 'ALTER TABLE ' + @TableName +
'DROP CONSTRAINT ' + @IndexName )

END
ELSE
BEGIN
-- This is executed as long as the previous fetch succeeds.
print 'drop index ' + @IndexName + ' on ' + @TableName

Exec('drop index ' + @IndexName + ' on ' + @TableName)
END

FETCH NEXT FROM index_cursor into @IndexName

END

CLOSE index_cursor
DEALLOCATE index_cursor
END
---end drop all indexes
--++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++