Francisco Tapia
fhtapia at gmail.com
Tue Dec 6 09:06:23 CST 2011
In 2008 this has changed, to view your current activity you simply click on the GUI button for activity monitor on the toolbar ... or (hey John.. check it out, an arcane asininity) simply press CTRL+ALT+A on any of your Management Studio windows. I don't use the express management studio, however I suspect that if Activity Monitor is not available via ctrl+alt+a then you can always execute the query sp_who to gather your info that you need. -Francisco http://bit.ly/sqlthis | Tsql and More... <http://db.tt/JeXURAx> On Mon, Dec 5, 2011 at 09:47, jwcolby <jwcolby at colbyconsulting.com> wrote: > 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@**colbyconsulting.com<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@**databaseadvisors.com <dba-SQLServer at databaseadvisors.com> >> http://databaseadvisors.com/**mailman/listinfo/dba-sqlserver<http://databaseadvisors.com/mailman/listinfo/dba-sqlserver> >> http://www.databaseadvisors.**com <http://www.databaseadvisors.com> >> >> >> > ______________________________**_________________ > dba-SQLServer mailing list > dba-SQLServer@**databaseadvisors.com <dba-SQLServer at databaseadvisors.com> > http://databaseadvisors.com/**mailman/listinfo/dba-sqlserver<http://databaseadvisors.com/mailman/listinfo/dba-sqlserver> > http://www.databaseadvisors.**com <http://www.databaseadvisors.com> > >