Hi all,

I am facing one wired problem with sysprocesses table of system table.

What i am doing is executing some stored procedures though code written
in dot net.

What i want is to check those stored procedure's id in sysprocesses
table and then update status in one user defined table.

So when user started say 4 stored procedure. and when i check
sysprocesses table even if my 4 stored procedures are running those are
not getting displayed in sysprocesses table.

I am checking each processid and all my stored proceudures are heavy
running means there is no possibility that they will complete execution
within say 1 to 2 min.

So my question is why sysprocess table is not giving me information
about those procedures which i am running.

Can some one shed some light on it.

Any help will be truely appreciated.

Thanks in advance.

try
sp_who2
and see if there are processes running from the machine which has the dotnet

As you mentioned you execute the sp though code written in dot net, it
won't show directly in the sysprocesses table as a sp in the cmd field.
If you execute the sp in QA, you will then see it clearly.
Alternatively, run the profiler to capture the action.

Mel