SQL Mysteries: Why am I​​ Still Seeing 17830​​ Errors?


 

Moved from: bobsql.com

 

I was recently contacted by Christophe Laporte posing a very interesting question.

« This is about the blog post you published a while ago, but I’ have questions regarding the error which is firing an XEvent almost every 10 ms.
I’ve done a bunch of simple testing on a lab environment to reproduce the issue of my customer and it appears that the event is raised on the logout statement, but not on the login statement.

 

Repro (Powershell commands and XEvent):

 

$connectionString = ‘Data Source=ServerName;database=master;Pooling=False;Trusted_Connection=yes’

$sqlConnection = New-Object System.Data.SqlClient.SqlConnection $connectionString

$sqlConnection.Open()

Start-Sleep