What are the challenges you face when working across database platforms? Take the survey

The number of rows in the TOP clause must be an integer - why is this getting raised?

Ok I'm a novice user so maybe I'm missing something. I've set up a little project to populate some tables from some views I've created elsewhere, replacing values in some of the view columns with Redgate generated values. The views contain between 1k and 20k rows, and I want to take all rows. The previews all look fine but when I Generate Data I get the aforementioned error for every table.
Where is this 'TOP clause' coming from? I'm not (knowingly) restricting the number of rows to read/write.
Any help much appreciated.


Sign In or Register to comment.