sql 2008 query for getting login information

Question

0.00/5 (No votes)

See more:

Hi all
my problem is that some one from our technical team connected my system by Remote Desktop Connection and done some work but I am not able to detect that particular system from where it has done. Is there any option to get the particular system?
here giving more details ---

No I m not getting LoginName field and other. it is showing LoginName field and other my sytem name that from my system some one send mail to a particular client but it has done by some other person from Remote Desktop Connection through my system so how can I get that system name or any clue Please help

Thanks to All

Posted 18-Mar-11 3:55am

IndrajitDasgupat

Updated 18-Mar-11 4:33am

v3

Add a Solution

Comments

Pravin Patil, Mumbai 18-Mar-11 10:17am

Do you mean SQL 2008?
What is sql 2088...?

Yusuf 18-Mar-11 10:18am

updated title.

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Abdul Quader Mamun · Answer 1 · 2011-03-18T04:17:00

Solution 1

Thank you for your question, use the following code

SQL

sp_helpuser

You will find LoginName field and other.

Thanks,
Mamun

Posted 18-Mar-11 4:17am

Abdul Quader Mamun

Comments

IndrajitDasgupat 18-Mar-11 10:31am

No I m not getting LoginName field and other. it is showing LoginName field and other my sytem name that from my system some one send mail to a particular client but it has done by some other person from Remote Desktop Connection through my system so how can I get that system name or any clue Please help

Yusuf · Answer 2 · 2011-03-18T04:23:00

Solution 2

Your question is misleading. Your title stated SQL 2008, but the question is about Remote Desktop Connection. Ok, let me see if I got this right. You are trying to determine which user connected to you via remote desktop, right? If so, check your event log. There should be a log for the remote user login/logof.

If the question is about SQL 2008 login info, well they have to use one your sql login credentials. I am not sure if you can get that from SQL 2008, but there may be something in the event log again.

Posted 18-Mar-11 4:23am

Yusuf

Comments

IndrajitDasgupat 18-Mar-11 10:35am

I m new to sql but I know that we r using sql 2008 that is why I wrote here SQL 2008 but below I m giving more clarity---
No I m not getting LoginName field and other. it is showing LoginName field and other my sytem name that from my system some one send mail to a particular client but it has done by some other person from Remote Desktop Connection through my system so how can I get that system name or any clue Please help