Skip to content

Process ID and application name are NULL when you connect SQL Server in Linux

When you run DMV sys.dm_exec_sessions , sys.sysprocesses to check the process id/application, these DMVs return NULL.

This is a bug that has been fixed in ODBC 17.4.2. Please update your drive.

Here is the detail

Microsoft ODBC Driver 17.4.2  to SQL Server on Linux and macOS has been released.

Please suggest to apply the hotfix in case your customers hit following issues

Bug fixes in the Microsoft ODBC Driver 17.4.2 for SQL Server

· Fix for an issue where process ID and application name would not be sent correctly to SQL Server (for sys.dm_exec_sessions analysis) (Linux)

· Removed redundant dependency on libuuid (Linux)

· Fix for a bug with sending UTF8 data to SQL Server 2019

· Fix for a bug where locales that end in “@euro” were not being correctly detected (Linux)

· Fix for XML data being returned incorrectly when fetched as an output parameter while using Always Encrypted

https://docs.microsoft.com/en-us/sql/connect/odbc/linux-mac/release-notes-odbc-sql-server-linux-mac?view=sql-server-2017

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

%d bloggers like this: