In SQL management studio, you can open a New Query by right clicking on the Server Group itself rather than a registered server. When you do so, at the bottom right, you can see the user as
<various logins> and the database as
In this case, how should the query window be used? Do we need to specify that we are running the query as a particular user and if yes, then how?