-
If one of the BCP fail. Does it affect the rest of the process??
Hi, I am wrote the following code in one store procedure called p_bcp_all.
and then scheduled it to run over night. what if the first two bcp were successful but the third one failed. Is the whole procedure going to fail? also what if the first one failed, is the rest of the code going to be executed have the bcp process going for the second and the third table?
thanks for your adivce
regards Ali
create procedure p_bcp_all as
Exec master..xp_cmdshell "bcp servername..tblone in d: blone.txt /fd:formatfile blone.fmt /servername /Usa /password/b250000 /a8000"
Exec master..xp_cmdshell "bcp servername..tbltwo in d: bltwo.txt /fd:formatfile bltwo.fmt /servername /Usa /password/b250000 /a8000"
Exec master..xp_cmdshell "bcp servername..tblthree in d: blone.txt /fd:formatfile blthree .fmt /servername /Usa /password/b250000 /a8000"
GO
-
How to change default TCP connection port in SQL 2000?
Dear all,
I want to change default TCP connection port of SQL server 2000.
Does anybody know how to do this?
Thanks.
-
How to change default TCP connection port in SQL 2000? (reply)
I answered this message already. if this has fire wall.
http://www.swynk.com/discuss_sql7/getmessage.asp?rootid=81653&id=81653
------------
Mete at 7/13/2002 10:52:20 AM
Dear all,
I want to change default TCP connection port of SQL server 2000.
Does anybody know how to do this?
Thanks.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|