Skip to content

Conversation

@hemanthmsft
Copy link
Contributor

@hemanthmsft hemanthmsft commented Mar 6, 2020

Updating the length of CMD from 16 to 26 as we are seeing values with length more than 16 like XIO_LEASE_RENEWAL_WORKER

Updating the length of CMD from 16 to 32 as we are seeing values with length more than 16 like XIO_LEASE_RENEWAL_WORKER
@PRMerger12
Copy link
Contributor

@HEMANTHSQL : Thanks for your contribution! The author(s) have been notified to review your proposed change.

The length of CMD should be nchar(26) -- as we get the data from sys.sysprocesses where cmd length is nchar(26)
@PRMerger14
Copy link
Contributor

@HEMANTHSQL : Thanks for your contribution! The author(s) have been notified to review your proposed change.

@VanMSFT
Copy link
Member

VanMSFT commented Mar 6, 2020

Hi @HEMANTHSQL! Thanks for making this suggestion. However, the old value is correct and we will not make this change. See the following screenshot:

image

We'll close this for now, but please feel free to comment further.

@VanMSFT VanMSFT closed this Mar 6, 2020
@VanMSFT
Copy link
Member

VanMSFT commented Mar 6, 2020

Re-open to change cmd length correctly for SQL 2019

@VanMSFT VanMSFT reopened this Mar 6, 2020
@VanMSFT
Copy link
Member

VanMSFT commented Mar 6, 2020

Discussed with @HEMANTHSQL. Editing the article to reflect new data type for cmd for SQL Server 2019.

#sign-off

@ktoliver ktoliver merged commit 1c504c5 into MicrosoftDocs:live Mar 6, 2020
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

Projects

None yet

Development

Successfully merging this pull request may close these issues.

6 participants