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 |
mani_1234
Starting Member
24 Posts |
Posted - 2012-10-08 : 06:48:05
|
i like to know can i debugg bcp utitilty for creating text file. though i m getting the correct result bt want to debugg it in sql2000.give some light on it |
|
sunitabeck
Master Smack Fu Yak Hacker
5155 Posts |
Posted - 2012-10-08 : 06:49:52
|
I don't think there is any way to debug bcp utility in the traditional sense of the word where you insert breakpoints, watch local variables etc.What is the issue or problem that you are trying to solve? |
|
|
mani_1234
Starting Member
24 Posts |
Posted - 2012-10-08 : 07:37:43
|
does it means sql doesnot support this ..?.as such there is no issue or proble. |
|
|
sunitabeck
Master Smack Fu Yak Hacker
5155 Posts |
Posted - 2012-10-08 : 07:55:52
|
The only things that come close to what you may be looking for are a) the -e option (for bcp in operations) that allows you to store the rows that bcp utility cannot processb) the -m option that lets you specify the maximum number of errors that can be allowed before the operation is terminated (by default 10).http://msdn.microsoft.com/en-us/library/ms162802.aspx |
|
|
mani_1234
Starting Member
24 Posts |
Posted - 2012-10-08 : 08:04:33
|
in query there s no such options ..i have searched a lot bt i m unable to find out the reason behind it |
|
|
sunitabeck
Master Smack Fu Yak Hacker
5155 Posts |
Posted - 2012-10-08 : 08:23:08
|
I do see those options even in SQL 2000, here: http://msdn.microsoft.com/en-us/library/aa174646(v=sql.80).aspxI wasn't suggesting that those are adequate replacements/stand-ins for the conventional debuggers; just that those are the closest that I could think of. |
|
|
|
|
|