Viewing 3 posts - 1 through 4 (of 4 total)
i using bcp command only now.But i need to add header in following code. how use bcp command to add header
set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
go
-- =============================================
-- Author:<Author,,Name>
-- Create date:...
July 21, 2010 at 2:44 pm
declare @bcpCommand varchar(8000)
SET @bcpCommand = 'bcp "select * from #Extractemployee" queryout c:\dump.txt -c -STORDBDO1 -Ukumaravels -Pasd123
I geting error
SQLState = 08001, NativeError = 53
Error = [Microsoft][SQL Native Client]Named Pipes Provider: Could...
July 20, 2010 at 5:50 pm
SET @bcpCommand = 'bcp "select * from #Extractemployee" queryout c:\dump.txt -S TORDB01,-U Kumaravels,-P AppsUser'
i put server name as -S TORDB01
USER NAME AS -U Kumaravels
password as -P AppsUser'
still giving me same...
July 20, 2010 at 5:19 pm
Viewing 3 posts - 1 through 4 (of 4 total)