Red Gate forums :: View topic - REQ: Limit number of "Duplicate Key ignored" messages
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Data Generator 1
SQL Data Generator 1 forum

REQ: Limit number of "Duplicate Key ignored" messages

Search in SQL Data Generator 1 forum
Post new topic   Reply to topic
Jump to:  
Author Message
tkdennis



Joined: 29 Feb 2008
Posts: 75

PostPosted: Fri May 23, 2008 5:04 am    Post subject: REQ: Limit number of "Duplicate Key ignored" messages Reply with quote

Could the final report at the end limit the number of times "Duplicate Key Ingored" message is printed. I'm using the suggested work around IGNORE_DUP_KEY on the primary key to avoid the generator stopping (http://www.red-gate.com/messageboard/viewtopic.php?t=6853&highlight=ignoredupkey)
and getting several pages worth.

Thanks,
Traci
Back to top
View user's profile Send private message
benhall



Joined: 14 Dec 2007
Posts: 98

PostPosted: Fri May 23, 2008 11:35 am    Post subject: Reply with quote

Hello,

Are you getting the message multiple times per table or just once per table but for lots of tables?

So I can log the feature for review, what would you like to be displayed on the report? Where would you like to be able to disable the message?

Thanks

Ben
Back to top
View user's profile Send private message
tkdennis



Joined: 29 Feb 2008
Posts: 75

PostPosted: Fri May 23, 2008 1:39 pm    Post subject: Reply with quote

It's multiple times per table. Ideally, I'd like one line that said "Duplicate key ignored 10,000 times"

If it needs to be disabled, then both at the table level and in the Project Edit option as the default setting for all tables.

Thanks,
Traci
Back to top
View user's profile Send private message
Display posts from previous:   
Reply to topic All times are GMT + 1 Hour
Page 1 of 1

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group