Application Locks, Sql Server 2005

  • 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? 

     

Viewing 0 posts

You must be logged in to reply to this topic. Login to reply