Visual Basic - Getting info on a remote computer

You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author

Getting info on a remote computer

Francois Houde

2006-03-31, 6:55 pm

Hi all, we have an autosys batch that runs everyday and do database inserts,
deletes and updates. Sometimes if a user is still connected, it can cause
some problem.

I've been asked to identified users who are still connected to the database.
The database is SQL Server 8.?.? . First I do a select * from sysprocesses
and I'm able to retrieve the hostname but the nt_domain and nt_user column
are empty.

My question is how can I retrieve info on the user (login name for example)
which hostname is in the sysprocesses table

I can't modify the properties of the database so the nt_domain and nt_user
would be filled.

We have done it very easily on Oracle because the username is in the
database but not in SQL Server.

Thanks in advance for your help.

Francois Houde

Sponsored Links