Home / user-6668

SO User's questions

Martin Hope
SO User
Asked: 2011-08-02 20:20:04 +0800 CST
  • 0

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 <multiple>.

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?

Thanks :)

ssms sql-server-2008
Martin Hope
SO User
Asked: 2011-08-01 20:32:00 +0800 CST
  • 0

I have just got SQL Server Mgmt Studio 2008 installed on my machine. Previously I was working with SQL Server Mgmt Studio 2005. I had stored a number of databases under Registered Servers in 2005. I am able to export these to a .regsrvr file from 2005. But I don't see any option in 2008 to import these.

Can you please advice on how the registered servers can be imported into SQL Mgmt Studio 2008?

Thanks :)

ssms sql-server-2008