sql query login

There are four main options for tracking SELECT activity on a server: You can use SQL Server Profiler to connect to your server and watch for specific activity as it happens. gbo 007 login You can create a server-side trace to log activity to a trace file on the server, which can then be read by SQL Server Profiler, or by using fn_trace_gettable to load it