Plus Auto Notice(Sample + Source)

Comandante - Plus Auto Notice(Sample + Source) - RaGEZONE Forums


same
please help me
 
0 SI has increased Grand Cross to [Plus 7] 2014-06-15 09:44:06.160 8
0 shiryus666 has increased Heavenly Scutum to [Plus 7] 2014-06-15 09:57:14.697 8
0 shiryus666 has increased Heavenly Scutum to [Plus 8] 2014-06-15 09:57:24.413 8
0 SI has increased Sacred Wing to [Plus 7] 2014-06-15 10:16:48.403 8
0 DarkSnoopy has increased Copper Blade to [Plus 9] 2014-06-15 11:37:15.767 8
NULL NULL NULL NULL

help pls notice does not appear
 
You know why the message wont send? I use V3 and the AutoNoticeWriter can send messages (normal automessage) but he cant send the message wich the log procedure writes in C:\MSSQLTips\FILENAME.txt. The messages stay in the file but nothing more?
 
Ok i found out what was wrong. And no i dont mean random numbers, i edited your script and custormized it. the filename was OnlineOffline.txt. The problem was that the file was created already. I had to delete it and now it works.
 
declare @azar INT
declare randomfile varchar(50)
SELECT top 1 @azar = (ABS(CHECKSUM(NEWID())) % 10000) FROM Master.dbo.Syscolumns
select randomfile = 'C:\MSSQLTips\' + convert(varchar, @azar) + '.txt'
SELECT dbo.WriteTextFile Veremos, randomfile, 0)


u forgot to declare Veremos
 
Back