Is SQL Expecting the user to have permission to the send_mail procedure ?

I was happy with both RedGate & Idera on physical & VM servers at previous jobs. No experience with Azure.

And what is the vendor's turn-around time ? Do you have to contact them, open a ticket, and twiddle your thumbs waiting for a restore ?

"....It all hinges I figure...

• This reply was modified 5 years, 1 month ago by homebrew01.

I ran it on a 2012 , 2016 and 2019 servers without errors.

• This reply was modified 5 years, 2 months ago by homebrew01.

I don't see your T-SQL. Paste it as "code" into the body of your post.

Are the tables & columns identical on the 2 servers ?

• This reply was modified 5 years, 2 months ago by homebrew01.

In case anyone else can benefit, I was given this as 1 possible solution.

;with src
as
(
select N.value('value[1]', 'varchar(max)') as SQLstatement
  from Extend_Events_Table as T
 cross apply T.Event_data.nodes('/event/data')...

• This reply was modified 5 years, 2 months ago by homebrew01.
• This reply was modified 5 years, 2 months ago by homebrew01.

Also, how do I get the EE date/time to show as local server time, not UTC ?

I want to query within a date range. The beginning of my XML has...

It seems like the number of replies to posts is lower than it used to be.

Tried this, but 0 results, although I know there are records.

select top 1 * FROM [EE_Table_20200617]
WHERE Event_data.value('(/event/data/value)[1]',  'nvarchar(max)') LIKE '%EXECUTE%'

Thanks in Advance.

• This reply was modified 5 years, 2 months ago by homebrew01.
• This reply was modified 5 years, 2 months ago by homebrew01.
• This reply was modified 5 years, 2 months ago by homebrew01.

How do I parse the "Event_Data" column so I can query it based on user, date, text string search etc ?

Thanks. I started a new thread specific to my new questions about extended events.

https://www.sqlservercentral.com/forums/topic/reading-extended-events-file-suggestions

My Extended event is below. I was originally including "sp_statement_completed", but that seemed to grow the file about 1 gig every few minutes. Obviously new at E.E.

CREATE...

I misunderstood. Any suggestions for other events I should capture at the same time ?

• This reply was modified 5 years, 2 months ago by homebrew01.

How can I capture the events within the trigger ?

• This reply was modified 5 years, 2 months ago by homebrew01.

Can you elaborate ?

Shouldn't I see the commands that the triggers execute...

• This reply was modified 5 years, 2 months ago by homebrew01.