Skip to Content
1
Oct 30, 2019 at 04:30 PM

Passing a Prefix SQL Parameter with each Data Universe Query -- SQL Server

80 Views

We need to pass 'TRANSACTION ISOLATION LEVEL SNAPSHOT;' in front of each data universe SQL query. The database is SQL Server. As I understand it the BEGIN_SQL parameter doesn't work with SQL server. I've tried added it but nothing gets passed onto the database. What other method can I utilize to make this happen?

We're on 4.2 sp06

Thanks,
Mike Gaynor