Hot answers tagged


Edit Top 200 Rows is simply a GUI way of performing INSERT, UPDATE or DELETE operations on a table, so you only require the same permissions you would require for performing these actions via T-SQL scripts. The minimum required is the following: Contained Database User or SQL Server Login mapped to Database User VIEW ANY DATABASE on server to Login GRANT ...


The Object Explorer pane and the Query pane are independent. You can have the Object Explorer connected without having a Query connected, and vice versa. The menu option you probably want is Query -> Connection -> Disconnect. HTH


SSMS runs on Windows only. If you're looking for a Microsoft tool, check out Azure Data Studio. There are also third-party tools available for Windows, Linux and Mac.

Only top voted, non community-wiki answers of a minimum length are eligible