Ask Your Question
3

In the criteria pane of SSMS19, why does editing 200 rows in a table display "Unknown"?

asked 2021-07-20 11:00:00 +0000

lakamha gravatar image

edit retag flag offensive close merge delete

1 Answer

Sort by ยป oldest newest most voted
3

answered 2021-12-25 03:00:00 +0000

qstack gravatar image

There could be various reasons why editing 200 rows in a table displays "Unknown" in the criteria pane of SSMS19. Some of the possible reasons are:

  1. Network issues: If there are any network connectivity issues with the server, the criteria pane may not be able to display the status of the table update correctly.

  2. Permission issues: If the user does not have sufficient permissions to modify the table, the criteria pane may display "Unknown" instead of the actual update status.

  3. SQL Server Management Studio bug: There could be a bug in the SSMS19 that is causing this issue. In such cases, it is recommended to check for the latest updates or report the issue to Microsoft Support.

  4. Large amount of data: If the update involves a large amount of data, it may take a while for the criteria pane to display the status. In such cases, it is recommended to wait for a few minutes and refresh the criteria pane.

edit flag offensive delete link more

Your Answer

Please start posting anonymously - your entry will be published after you log in or create a new account. This space is reserved only for answers. If you would like to engage in a discussion, please instead post a comment under the question or an answer that you would like to discuss

Add Answer


Question Tools

Stats

Asked: 2021-07-20 11:00:00 +0000

Seen: 8 times

Last updated: Dec 25 '21