I suppose the easiest way to figure out what is going on will be to use a tool called SQL profiler you can normally find this under client tools under...
You could try some fancy SQL, be be aware some of this TSQL code does different things with different versions of SQL, but I am hoping you are using at-least...