I´m monitoring the SAPIENS applications in Sql Server 2005, I ´m finding a lot of Locks in Transactions, then I decided to use the command (ALTER DATABASE SAPIENS SET ALLOW_SNAPSHOT_ISOLATION ON ), but How can I know that this database SAPIENS is using the set command? , Where I can see this command, if is set for database SAPIENS? .
Please, someone have idea , How can I get it this information?