Solved

How to identify the Host in an SQL process

Posted on 2010-08-19

Microsoft SQL Server

2 solutions

455 Views

Last Modified: 2012-05-10

Hi
SQL server 2000. In enterprize manager I can see a process, the host name for this is not a machine in my network. I cant ping to this name. Not sure if this is a machine outside the network but connected through VPN, or this is some automated job. I have stopped all the scheduled jobs on server still the process is appearing. Even if the process is killed, it starts again in few minutes. Is there anyway to identify the source of this process? I have the host name - this is the name of a PC used long time back in our network but the PC doesnt exist in the network anymore. Network library is shown as LPC. Any ideas?

Thanks,

Comment

Question by:bijualex

[X]

Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

Help others & share knowledge
Earn cash & points
Learn & ask questions

Join The Community

3 Comments

LVL 143

Accepted Solution

by:Guy Hengel [angelIII / a3]

Guy Hengel [angelIII / a3] earned 250 total points

ID: 334825272010-08-19

LPC means it's using the (local) shared memory, so it's a process on the box itself.

Author Comment

by:bijualex

ID: 334906692010-08-21

Hi angelIII

Thanks for this information. Is there anyway to identify the actual application which triggers this process? I have disabled all sql server scheduled jobs, I have nothing in windows scheduled tasks. No user defined services also enabled. Any other place to check?

Thanks

Assisted Solution

by:shrimantpatel

shrimantpatel earned 250 total points

ID: 334941562010-08-21

It can very well be a service that would be constantly retrieving data from the SQL server, Try looking for the same process id in the regular windows task manager and the Event logs too

Featured Post

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

How to replicate SQL 2008 database to SQL 2014 by using Initialize from Backup.

Article by: lcohan

Ever needed a SQL 2008 Database replicated/mirrored/log shipped on another server but you can't take the downtime inflicted by initial snapshot or disconnect while T-logs are restored or mirror applied? You can use SQL Server Initialize from Backup…

How to resolve “Cannot install SQL Server 2014 Service Pack 2: Unable to install windows installer msi file” error ?

Article by: Yashwant

In this article we will learn how to fix “Cannot install SQL Server 2014 Service Pack 2: Unable to install windows installer msi file” error ?

Creating and Executing a SQL Pass-thru Query

Video by: TechMommy

Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…

SQL - Updating and Deleting Data

Video by: Zia

Viewers will learn how to use the UPDATE and DELETE statements to change or remove existing data from their tables. Make a table: Update a specific column given a specific row using the UPDATE statement: Remove a set of values using the DELETE s…