It is fully qualified...

I dont know if I will make it for Summit this year... 🙁 I hope the company will allow me to go this year as well.

Great article as usual Jeff. I did not know about the Set Statistics. Thx. I will keep this in mind when I have to look at performance.

Depending on what you want to capture, you can use any of the three types of Auditing available. CDC, CT and SQL Audit. There are articles here in this website...

Hey All, When I saw 80 notification emails today morning from THE THREAD, I had to take a look at what was happening.

Well, Nothing changed. Jeff is still going...

Do you have any good network admins there? If so, ask them to do some packet sniffing on the wire. Since it is SQL Authentication, the authentication usually comes in...

Who is also shown. If you look at the first http://www.sqlservercentral.com/Images/14239.jpg

you will session_server_principal_name which will show the user name

Yes it is. The behavior changes even for different level of Service packs unfortunately.

Beginner2008, Thx. You gave me an idea for the next article. I will try to do one regarding capturing the auditing data and writing it to a Table.

Hi Computrion, Thx for links. Yes, I noticed that the SQL Audit does not catch all the values.

Thx for pointing it out. 🙂 Next time I will be more careful. 🙂

Thanks... I had this hat for quite some time now. But I havent been around SSC lately. 🙁 I have to make time to...

Steve Jones - SSC Editor (4/27/2012)

---

Roy Ernest (4/27/2012)

---

So Steve, the article I submitted that still needs to be edited wont come out in May at all. Maybe June 2nd week...

So Steve, the article I submitted that still needs to be edited wont come out in May at all. Maybe June 2nd week if I am lucky?

You can check the performance counter on the OS level using performance dashboard.