IF EXISTS (SELECT * FROM sys.database_event_sessions WHERE name = 'Exceptions')
   DROP EVENT SESSION Exceptions ON DATABASE
go

CREATE EVENT SESSION [Exceptions] ON DATABASE 
ADD EVENT sqlserver.error_reported(
    ACTION(sqlserver.client_app_name,
           sqlserver.client_hostname,
           sqlserver.database_name,
           sqlserver.session_id,
           sqlserver.sql_text,
           sqlserver.tsql_stack,
           sqlserver.username)
    WHERE ([severity]>=(11) 
      AND NOT [sqlserver].[like_i_sql_unicode_string]([sqlserver].[client_app_name],N'%SQL Server Management Studio%')))
ADD TARGET package0.ring_buffer (SET MAX_MEMORY = 0,
                                     MAX_EVENTS_LIMIT = 1000)
WITH (MAX_MEMORY=4096 KB,
      EVENT_RETENTION_MODE=ALLOW_SINGLE_EVENT_LOSS,
      MAX_DISPATCH_LATENCY=30 SECONDS,
      MAX_EVENT_SIZE=0 KB,
      MEMORY_PARTITION_MODE=NONE,
      TRACK_CAUSALITY=OFF,
      STARTUP_STATE=ON)