With the increasing importance of apps & networks in both business & personal interconnections, perfor. has become one of the key metrics of successful communication. This ebook is a hands-on business-case-driven guide to understanding MySQL query parameter tuning & database perf
Solved
How to identify the Host in an SQL process
Posted on 2010-08-19
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,
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,
[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
3 Comments
Featured Post
Question has a verified solution.
If you are experiencing a similar issue, please ask a related question
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…
A Stored Procedure in Microsoft SQL Server is a powerful feature that it can be used to execute the Data Manipulation Language (DML) or Data Definition Language (DDL).
Depending on business requirements, a single Stored Procedure can return differe…
Via a live example, show how to extract information from SQL Server on Database, Connection and Server properties
Using examples as well as descriptions, and references to Books Online, show the different Recovery Models available in SQL Server and explain, as well as show how full, differential and transaction log backups are performed
Suggested Courses
Course of the Month8 days, 15 hours left to enroll
721 members asked questions and received personalized solutions in the past 7 days.
Join the community of 500,000 technology professionals and ask your questions.