SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
 Password:
Save Password
Forgot your Password?

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 bcp		  New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

mani_1234
Starting Member

India
24 Posts
Posted - 10/08/2012 :  06:48:05  Show Profile  Reply with Quote
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
Flowing Fount of Yak Knowledge

5152 Posts
Posted - 10/08/2012 :  06:49:52  Show Profile  Reply with Quote
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?
Go to Top of Page

mani_1234
Starting Member

India
24 Posts
Posted - 10/08/2012 :  07:37:43  Show Profile  Reply with Quote
does it means sql doesnot support this ..?.
as such there is no issue or proble.
Go to Top of Page

sunitabeck
Flowing Fount of Yak Knowledge

5152 Posts
Posted - 10/08/2012 :  07:55:52  Show Profile  Reply with Quote
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 process

b) 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
Go to Top of Page

mani_1234
Starting Member

India
24 Posts
Posted - 10/08/2012 :  08:04:33  Show Profile  Reply with Quote
in query there s no such options ..
i have searched a lot bt i m unable to find out the reason behind it
Go to Top of Page

sunitabeck
Flowing Fount of Yak Knowledge

5152 Posts
Posted - 10/08/2012 :  08:23:08  Show Profile  Reply with Quote
I do see those options even in SQL 2000, here: http://msdn.microsoft.com/en-us/library/aa174646(v=sql.80).aspx

I 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.
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.08 seconds. Powered By: Snitz Forums 2000