Red Gate forums :: View topic - ANSI_WARNINGS Project Option
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Compare 10
SQL Compare 10 forum

ANSI_WARNINGS Project Option

Search in SQL Compare 10 forum
Post new topic   Reply to topic
Jump to:  
Author Message
s_solt



Joined: 01 Mar 2007
Posts: 7
Location: London

PostPosted: Fri Mar 22, 2013 6:23 pm    Post subject: ANSI_WARNINGS Project Option Reply with quote

NB I couldn’t find a wishlist on the support forums.

For several years I have wanted a project option to set ANSI_WARNINGS OFF when I am happy to ignore data truncation warnings. I know I can (and do):

• Copy the script to the clipboard
• Paste it into SSMS
• Edit two lines
• Execute it
• Go back to SQL Compare
• Close the deploy dialog
• Recompare

But this is a bit of a performance, particularly if I am using repeated deployment attempts fixing each error in turn that prevents the synch in order to identify all the issues other than those related to data truncation.

Stephen Solt
Planchest Ltd
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