Skip to main content

Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Eclipse Projects » EclipseLink » SQL Server session Settings(Problem with ANSI_WARNINGS flag and TRUNCATE-ing error)
SQL Server session Settings [message #1768636] Thu, 20 July 2017 20:22
Bret Williams is currently offline Bret WilliamsFriend
Messages: 1
Registered: July 2017
Junior Member
Our project is mid converting from Sybase to SQL Server. I've had a number of exceptions due to the SQL Server prohibiting insert of data which will be truncated.

If I SET ANSI_WARNINGS OFF the insert happens without exception but of course truncates the data. That's what I want. But... the setting that I install at the database-level of "OFF" seems to be overridden by a Session/ClientSession-level switch.

How do I explicitly set the initial/default value of the connection to OFF at the session level?

Previous Topic:Sharing one column in multiple ForeignKeys
Next Topic:Unable to get data from extensible entity using Odata
Goto Forum:

Current Time: Tue Apr 07 04:55:49 GMT 2020

Powered by FUDForum. Page generated in 0.02056 seconds
.:: Contact :: Home ::.

Powered by: FUDforum 3.0.2.
Copyright ©2001-2010 FUDforum Bulletin Board Software

Back to the top