September 14, 2005 at 8:11 pm
I am trying to BCP out 93 tables from my database. I am looping through each table to be copied out using a cursor. Some of the tables are copied correctly and some are giving an error as follows.
Password:
SQLState = 08001, NativeError = 17
Error = [Microsoft][ODBC SQL Server Driver][Shared Memory]SQL Server does not exist or access denied.
SQLState = 01000, NativeError = 10061
Warning = [Microsoft][ODBC SQL Server Driver][Shared Memory]ConnectionOpen (Connect()).
NULL
my bcp string is
bcp.exe "Test.dbo.ADUser" Out "C:\Backup\ADUser.txt" -n -SUSPRNSRANKA1\DA -q -T
also to bcp out 93 tables it takes around 13 mins. does any body know how i can reduce the execution time and also not get the above error.
thanks in advance
September 16, 2005 at 1:31 pm
Do any of your table names have embedded spaces in them ? This could cause a parsing error.
For performance try executing 3 batches of 31 tables concurrently ... or something to that effect.
RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."
September 16, 2005 at 1:34 pm
Thank you for your reply. my problem is resolved
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply