[dba-SQLServer] Users in SQL Server

>From the SSMS Object Explorer, you can click on Management ->Activity
Monitor

You can see all active users/processes.

You can filter by database or user, right click on a process and Kill it if
you need.

All done via the GUI, with nothing typed except a user or database name if
you chose to filter by one.

D





On Mon, Dec 5, 2011 at 9:21 AM, jwcolby <jwcolby at colbyconsulting.com> wrote:

> Our (or at least my) problem is that MS is not spending enough time on the
> GUI.  When I realized I needed to get the users and their rights out of the
> database into the server, I tried to click / hold / drag and drop the user
> from the database security area into the server security area.
>
> Makes sense right?
>
> We have been dragging and dropping for 15 years now in Windows, longer
> than that in the MAC world. Visual Studio and C# uses drag and drop, Access
> uses drag and drop.  But no, in SQL Server we have to go figure out how
> this stuff even works, then how to use command line or query crap to type
> in arcane syntax into a dev environment that basically gives you a "didn't
> work, try again" error message if anything goes wrong.
>
>