--you can track pwd changes using trace,such as

declare @on bit,@p1 int

select @on = 1

set @P1=1

exec sp_trace_create @P1 output, 1, NULL, NULL, NULL

exec master..sp_trace_setevent @p1, 107, 1, @on -- textdata

exec master..sp_trace_setevent...

The script below will solve your problem,it runs for bot sql 7.0 an sql 2000.

-- Caution : database compatibility level must be 7.0 or higher ..

dbcc shrinkfile ( [Logical Log...

The script below will solve your problem,it runs for bot sql 7.0 an sql 2000.

-- Caution : database compatibility level must be 7.0 or higher ..

dbcc shrinkfile ( [Logical Log...

declare @tablename varchar (128)

select @tablename = 'TableName'

declare @tableid int,@columnpointer ...

replace <logname> with log name of the db

and <dbname> with dbname.

if its okey i explain it later.

declare @logname varchar(128)

dbcc shrinkfile ( <logname>, truncateonly )

backup log <dbname> with truncate_only

GO

if exists...