Thanks Shaw, but these are almost same like sysprocesses in sql2000 system table , i can use these two above views in sql2005 only.

Can you give me some thing for...

Thank you very much for your time , thats good examples.

Thank you for your time. database log file was corrupted and i did detach/attach the database with generating new logfile and my problem is fixed.

Thanks again.

Thank you very much for your time,now i am leaving for home and see you again if would have a problem.

Take Care

I am sorry i am not clear with your answere. do you mean if i have both switches enabled i will get a problem? you mean we should enable only...