April 4, 2004 at 7:43 pm
I was testing an app and it blew up in the process of executing a DTS package that had always worked before. I tried using the Import and Export Data wizard to do run the query, and it blew up on row 9713720 of the data - something about an overflow problem. There is obviously something wrong with the new data I got today.
I have taken a subset of the original data and have everything working for now, but I want to look at row 91713720 to see what the data looks like that caused the problem. There are a little over 20 million rows of data in the original table, and try as I might I cannot come up with the row in question without going through a LOT of eyeballing. Even that has produced no results.
PK is not a good way to find this as rows are deleted at times, so the PK will not match the row number. BOL does not seem to offer any way to do this (or I am asking the wrong question).
Is there a way to pull up a single row of data based on its row number?
Thanks for any help on this!
Mark Rider
http://www.commonsensesecurity.info
April 5, 2004 at 9:08 am
bcp data out, then bcp into temptable using -F, -L parameters.
September 5, 2004 at 1:18 am
ds
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply