I am database creator and I don?t have ?sa? permission but I want monitor my transaction. Is that possible, How?
Thanks
Running the profiler is to intensive on server usage for normal use, we run it sometimes to find problems, but do not allow customers to use it. If you need to debug a query you need to do it on the local SQL server level.