To enable the use of indexed views in a number of databases, I had to set NUMERIC_ROUNDABORT to OFF. I have used this kind of script for all the databases.
USE databaseNameA; SET NUMERIC_ROUNDABORT OFF; USE databaseNameB; SET NUMERIC_ROUNDABORT OFF; ...
Yet, when I checked this setting in the Properties window in SSMS, NUMERIC_ROUNDABORT was still set to "True" in all the databases.
I have the impression that SET NUMERIC_ROUNDABORT is only effective in the session that script was run.
Is there a way to set this option in a script (as opposed to do it manually in the Properties window in SSMS)? That way I can include it in the script that generates the scripts to create databases (in the generated scripts, the correct name and location of the .mdb and .ldb files are generated, a login and user are defined, ...)
As a side node. I don't understand what NUMERIC_ROUNDABORT has to do with indexed views. There must be an underlying reason, but what is it?