Monthly Archives: May 2013

SET NUMERIC_ROUNDABORT ON and others

A good link:¬†http://sqlservercode.blogspot.com/2006/11/use-sessionproperty-to-check-if.html Useful commands: DBCC USEROPTIONS SELECT¬†SESSIONPROPERTY(‘numeric_roundabort’) NUMERIC_ROUNDABORT seems is a server level (or user session level) setting. Because when I change it on one DB, all other DBs are changed too. If use Visual Studio Database project, make … Continue reading

Posted in SQL | Tagged | Leave a comment