SQL Server Profiler Determine Number Times User Account Used
in [Programming SQL]
|
Prev: TSQL Challenge 18 - Generate text formatted month calendars
Next: computing a counter/counting column?
From: Joe K. on 1 Dec 2009 07:21 I have numerous SQL Server 2005 Profiler traces that run when certain user account are used in the database server in the last month. Please help me with a program to determine the number of times and duration the user account has been used in a database server? Please help me resolve this issue.
From: Uri Dimant on 1 Dec 2009 08:51
Joe You can query SUM(duration) column in the trace file...I mean he/she was running the queries Also take a look at DDL Trigger for log on event http://www.simple-talk.com/sql/sql-server-2005/logon-triggers/ "Joe K." <JoeK(a)discussions.microsoft.com> wrote in message news:74151D67-24FD-4001-857A-AE58CAF20BF9(a)microsoft.com... >I have numerous SQL Server 2005 Profiler traces that run when certain user > account are used in the database server in the last month. Please help me > with a program to determine the number of times and duration the user > account > has been used in a database server? > > Please help me resolve this issue. |