nu..vreau ceva mult mai simplu....de genul...

DECLARE @mesaj as nvarchar(50),@NrDuplicate int,@data datetime
SELECT @NrDuplicate = (SELECT COUNT(*) FROM Tmp) - (SELECT DISTINCT COUNT(*) FROM Tmp)
set @data=getdate()
set @mesaj = 'In data de '+cast(@data as nvarchar(12))+' avem in tabela Tmp un numar de '+cast(@NrDuplicate as nvarchar(4))+' duplicate.'

DECLARE
 @cmd  sysname,
 @var  nvarchar(100),
 @destinatie nvarchar(50)

set @var=@mesaj
set @destinatie='C:\test.txt'
SET @cmd = 'echo ' + @var + ' > '+@destinatie
EXEC master..xp_cmdshell @cmd
GO

dar nu merge.....imi scapa mie ceva....nu cunosc bine xp_cmdshell....ma ajuta cineva?

unde e greseala?