Okay, I got it to work.

Thanks

Thanks for the reply, bu this is all there is, and it is not working.

Thank you

When I filter or look in there, for that date and time I get nothing. Yet in my Audit, it says it occurred at 12:57 am.

Unless somehow I am misinterpreting...

Well, then I am lost. In the audit message, it had this file listed, and this is what was in the file.

However, like I was asking before is there anything...

Hi,

That is what too.

However, when I open the log file on I see this on for every line

Date, Source, Severity, Event Time,

10/25/2019 00:57:13, ,Success,

And as you can see the space where...

So I am going through it again, and I see what you are talking about. On instances page, where it asks you to select an instance, there is nothing there....

Last question, is if by chance it is installed and somehow I am reading this wrong, and it is installed. Would reinstalling it hurt anything?

Thanks

Thanks, this is really helpful.

I only see one instance.

and when I was going through the setup, and maybe I missed it, I do not remember it given me a choice.

One...

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

Sorry, I am not sure when you say instance installed. I have one server and a few databases.

How can I check this?

Thank you

Yes, you are right. sorry. I am going back and forth doing something.

However, I ran it on the right machine now and it still looks like I have SP 2,...

Hi When I run this

select @@version

I get which I do not see the sp number in it?

Microsoft SQL Azure (RTM) - 12.0.2000.8   Sep  9 2019 09:35:03   Copyright...

Hi Jonh, and thanks for the reply.

I am not sure I am following you.

I go to properties in there I do not see the SP number.

Is this where you mean.

Thanks  to everyone here, especially john, it worked great and gave me a whole new perspective on triggers.

Thanks again

Thanks, I appreciate the help and I will check it out.

One last question this looks like it would also work for a single insert as well. is that right?

Thnaks