jwcolby
jwcolby at colbyconsulting.com
Mon Dec 5 11:47:12 CST 2011
Cool, except that my management folder does not have Activity Monitor as an object under it. John W. Colby Colby Consulting Reality is what refuses to go away when you do not believe in it On 12/5/2011 12:33 PM, David McAfee wrote: >> 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. >> >> > _______________________________________________ > dba-SQLServer mailing list > dba-SQLServer at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/dba-sqlserver > http://www.databaseadvisors.com > >