Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
ranjeetsingh_6
Posting Yak Master
125 Posts |
 Posted - 2010-08-24 : 08:50:54
|
| Hi,i want to save query output into File.For this i am using below bcp command, this work fine but when i am using a store procedure with bcp command then it give.--command that execute successfullyEXEC master..xp_cmdshell'bcp " select * from Test_21082010..tbl_ChangesSchema " queryout "c:\text_24082010.txt" -c -T -S CHETUIWK270\SQL2008 '--command that give errorEXEC master..xp_cmdshell'bcp " exec Test_21082010..sp_CreateDataLoadScript ''1.0'' " queryout "c:\text_24082010.txt" -c -T -S CHETUIWK270\SQL2008 '--Error is SQLState = HY010, NativeError = 0Error = [Microsoft][SQL Native Client]Function sequence errorNULLRanjeet Kumar Singh |
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2010-08-24 : 12:17:58
|
| works for me. what is the SP doing? |
 |
|
|
|
|
|
bcp error