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:
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.
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.
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.
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.
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
Asked: 2021-07-20 11:00:00 +0000
Seen: 8 times
Last updated: Dec 25 '21
How do you log Python data into a database?
How can the SQL debug mode be activated in PostgreSQL version 15.2?
How to deal with an operational error when connecting Django to MySQL?
What is the method for choosing data FROM a stored procedure?
How can SQL/PLSQL blocks be stripped of their comments?
What is the process for initializing Java UDFs in Spark?
How to set up Database First configuration in Entity Framework 7 for MVC 6?