SQL Server 2000 清除全部数据库日志的脚本

declare @i int
set @i=1
declare @DbCount int
set @DbCount=(select COUNT(name) from sysdatabases)

--select * from sys.databases

while(@i<@DbCount)
begin
declare @DbName nvarchar(2000)
declare @DbLog nvarchar(2000)
declare @sql nvarchar(2000)
set @DbName=(select top 1 name from sysdatabases where dbid=@i and name<>'tempdb')

set @sql=N'
backup log '+@DbName+' with no_log
dbcc shrinkdatabase ('+@DbName+')
'
--select @sql
exec (@sql)
set @i=@i+1
end