Hello, I am very happy cause i made it and now i know where and how to look for bad queries!

Thank you all for your precious time and answers of...

Good morning everyone. I managed to run the procedure, my problem now is that i get a total different output from the procedure than that of activity monitor. I mean...

I do not know how to do that, sorry. Please explain.

Thank you.

I executed the query in the master db, it did gave me success in the output window, but when i go to the programmability and execute the proc, it opens...

Copy - Paste to a new query window.

This is what i get...

------ Execution started: Connection: SQL4.sql ------

Changed database context to 'NIKOLISGROUP'.

Changed database context to 'NIKOLISGROUP'.

Execute succeeded [0,024s]

Execute succeeded [0,001s]

Execute failed...

The message in the output window says :

Execute failed [0,055s]

Strange for my logical, because in the down limit of the editor window it says query executed successfully...!

Is there anything i...

when i did execute the query to create the procedure the sql editor gave the msg query executed successfully,

i went to modify the sp_whoisactive as you mention and this is...

Sql 2005 if you mean that, compatibility level 80.

Sorry if i am making you feel a little bit frustrated with my ignorance.

Thank you.

It has to do that im completely noob.

Done that, it was so simple, but in

the output window it says : stub version, to be replaced.

Thank you people, you're great.

As i saw that is a quite big query! So, how i am going to see the output of this query? I test run it on a temporary db and...