Hi to all:
our HelpDesk needs from time to time to run a trace in some of my servers. They don't have sysadmin permissions so right now, I reset the password of a user with sysadmin rights, and let them use it for a few minutes.
This have become unconfortably, so I wanted to create a visual (6 or .NET) app to run traces on SQL Server. I Know to use trace stored procedures and save the result to a file and then import it to a table, but wanted to know if it is possible to create something like profiler, that will show the traces in realtime in the screen.
Any ideas?
thanks in advanced.