Gerar arquivo ConnectMember.txt automaticamente.

[mymax]

olá , galera estou com esse seguinte problema !
não estou conseguindo gerar o ConnectMember.txt.

coisa que eu conseguia gerar quando usava outra DB no SQL 2000.
agora to usando uma DB do ms , de versao 1.02c, não se se esta faltando alguma coluna ou tabela !
estou usando esse codigo aqui ! que por sinal sempre usei e deu certo

declare @memb___id varchar(10)
declare @vip int
declare @value varchar(255)
declare @address varchar(255)
SET @address = 'C:\MuServer\Data\ConnectMember.txt'
SET @value = 'DEL '+ @address
exec MASTER..XP_CMDSHELL @value
declare c cursor for select memb___id, vip FROM MEMB_INFO

open c
FETCH NEXT FROM c INTO @memb___id, @vip

WHILE @@FETCH_STATUS = 0
BEGIN 
    IF @vip = 2
    BEGIN
      SET @value = 'ECHO;"' + @memb___id + '" >> '+ @address
      exec MASTER..XP_CMDSHELL @value
     print @value; 
       END
 FETCH NEXT FROM c INTO @memb___id, @vip
END

CLOSE c
DEALLOCATE c 

e está dando esse erro ! no qual aparece os loguins dos players !

Msg 15281, Level 16, State 1, Procedure xp_cmdshell, Line 1
SQL Server blocked access to procedure 'sys.xp_cmdshell' of component 'xp_cmdshell' because this component is turned off as part of the security configuration for this server. A system administrator can enable the use of 'xp_cmdshell' by using sp_configure. For more information about enabling 'xp_cmdshell', see "Surface Area Configuration" in SQL Server Books Online. 
Msg 15281, Level 16, State 1, Procedure xp_cmdshell, Line 1
SQL Server blocked access to procedure 'sys.xp_cmdshell' of component 'xp_cmdshell' because this component is turned off as part of the security configuration for this server. A system administrator can enable the use of 'xp_cmdshell' by using sp_configure. For more information about enabling 'xp_cmdshell', see "Surface Area Configuration" in SQL Server Books Online. 
ECHO;"zgii" >> C:\MuServer\Data\ConnectMember.txt
Msg 15281, Level 16, State 1, Procedure xp_cmdshell, Line 1
SQL Server blocked access to procedure 'sys.xp_cmdshell' of component 'xp_cmdshell' because this component is turned off as part of the security configuration for this server. A system administrator can enable the use of 'xp_cmdshell' by using sp_configure. For more information about enabling 'xp_cmdshell', see "Surface Area Configuration" in SQL Server Books Online. 
ECHO;"ya9" >> C:\MuServer\Data\ConnectMember.txt
Msg 15281, Level 16, State 1, Procedure xp_cmdshell, Line 1
SQL Server blocked access to procedure 'sys.xp_cmdshell' of component 'xp_cmdshell' because this component is turned off as part of the security configuration for this server. A system administrator can enable the use of 'xp_cmdshell' by using sp_configure. For more information about enabling 'xp_cmdshell', see "Surface Area Configuration" in SQL Server Books Online. 
ECHO;"YAMI_" >> C:\MuServer\Data\ConnectMember.txt
Msg 15281, Level 16, State 1, Procedure xp_cmdshell, Line 1
SQL Server blocked access to procedure 'sys.xp_cmdshell' of component 'xp_cmdshell' because this component is turned off as part of the security configuration for this server. A system administrator can enable the use of 'xp_cmdshell' by using sp_configure. For more information about enabling 'xp_cmdshell', see "Surface Area Configuration" in SQL Server Books Online. 
ECHO;"TNT" >> C:\MuServer\Data\ConnectMember.txt 

[mymax]

ninguem sabe não ? ;\

---------- Post added at 02:19 AM ---------- Previous post was at 02:13 AM ----------

podem fechar , consegui solucionar

[TheNight]

Poste como fez, eu tenho a mesma duvida cara.

[hadeslan]

poderia falar como resolvel amigo

[sula]

- Gerar connectMember, vc monta uma job, use o comando abaixo e ponha pra rodar no horario que achar melhor.
- A parte em negrito vc altera para onde fica seu arquivo.

declare @memb___id varchar(10)
declare @vip int
declare @value varchar(255)
declare @address varchar(255)
SET @address = 'C:\MuServer\Gamexxxx\Data\ConnectMember.txt'
SET @value = 'DEL '+ @address
exec MASTER..XP_CMDSHELL @value
declare c cursor for select memb___id, vip FROM MEMB_INFO

open c
FETCH NEXT FROM c INTO @memb___id, @vip

WHILE @@FETCH_STATUS = 0
BEGIN
IF @vip = 1
BEGIN
SET @value = 'ECHO;"' + @memb___id + '" >> '+ @address
exec MASTER..XP_CMDSHELL @value
print @value;
END
FETCH NEXT FROM c INTO @memb___id, @vip
END

CLOSE c
DEALLOCATE c

é isto