Hot answers tagged

5

According to the documentation, SQL Server Configuration Manager requires Local Administrator permissions since various SQL Server Configuration items are stored in the local system registry. From the "SQL Server Properties (Startup Parameters Tab)" in the SQL Server Configuration Manager Help: Use of this page is restricted to users who can change the ...


4

You can look at the currently running processes in SSMS in Activity Monitor. You can also get it using sys.dm_exec_sessions as well as sys.dm_exec_connections and sys.dm_exec_requests. Query: SELECT DB_NAME(database_id) as [DB] , login_name , nt_domain , nt_user_name , status , host_name , program_name , COUNT(*) AS ...


2

I would also suggest what Julien suggested but I guess scheduling the query through SQL Server Agent would be better idea and then every time it runs you dump the information into a physical table. Two DMVs are joined sys.dm_exec_connections and sys.dm_exec_sessions Like first create a physical table create table Session_Information ( session_id int, ...



Only top voted, non community-wiki answers of a minimum length are eligible