Thanks for the information. I will send the same by email.

You are welcome. Let me know if you need any more details.

It is good - Thanks

Can we do a webex or something may be we can use teamviewer as it is personal purpose only. If you agree for me connecting to your system and checking...

Sharath,

What is the service pack level, I checked the script in both SQL Server 2005 SP2 and SP3.....I don't have SP1 to test.

In both the instances I tested. I don't...

Sharath,

Please send me the script that you are executing. I will check and let you know.

Sarath,

I guess you are executing the script all together at once. You are supposed to execute it in two steps.

Step 1:

create view sqlexec as

SELECT

s.spid,s.dbid,s.login_time,s.hostname, s.loginame, s.program_name,s.waittype,s.lastwaittype,s.cpu,s.memusage,s.status,s.net_library,s.sql_handle

,e.text as SQL

FROM

sys.sysprocesses s

CROSS...

Sharath,

What version of SQL Server are you using?