Home Forums SQL Server 2012 SQL Server 2012 - T-SQL BCP through XP_CMDSHELL not responding RE: BCP through XP_CMDSHELL not responding
diegoanckizes
SSC Veteran
Points: 239
More actions
October 9, 2013 at 4:46 pm
#1657338
That thing:
EXEC('EXEC MASTER..XP_CMDSHELL ''BCP "SELECT * FROM [[db]]..[table]" QUERYOUT "C:\Users\processos\teste\TESTE.TXT" -t; -r -c -CRAW -U[user] -P[[pass]]''')
TY