peetherson ser aque es job query dar pra fazer i altomatico ConnectMember pra quem vip ir altomatico da uma olhada ai
declare @memb___id varchar(10)declare @vip intdeclare @value varchar(255)declare @address varchar(255)SET @address = 'C:\MuServer\Data\ConnectMember.txt'SET @value = 'DEL '+ @addressexec MASTER..XP_CMDSHELL @valuedeclare c cursor for select memb___id, vip FROM MEMB_INFOopen cFETCH NEXT FROM c INTO @memb___id, @vipWHILE @@FETCH_STATUS = 0BEGIN IF @vip = 2 BEGIN SET @value = 'ECHO;"' + @memb___id + '" >> '+ @address exec MASTER..XP_CMDSHELL @value print @value; ENDFETCH NEXT FROM c INTO @memb___id, @vipENDCLOSE cDEALLOCATE c