Hi Roy !

You are right, SQL Server profiler does provide the information. I did not select the hostname column when performing the trace.

Thank You very much !

Regards,

Al

Hi Roy,

Thanks for your suggestion however it seems like sql server 2000 does not provide the IP address information even in the SQL Server profiler.

The connection is done via...

Hi,

Thanks for your suggestion. However it still does not work.

It should be some permission issues which is causing this but I can't seem to find what privileges it requires...

Hi everyone,

Just to update on this item. This behavior only happens whenever I used an admin account. I have created an admin account which has lesser privileges than the...

Hi Ashish,

Thanks a lot for the help !

That is exactly what I need !

Hi Frank,

I have read that and have tried using a brand new account with no rights at all. I gave the account permissions as provided by Microsoft in