sql 2008查询以获取登录信息 [英] sql 2008 query for getting login information

问题描述

大家好
我的问题是我们技术团队的某个人通过远程桌面连接连接了我的系统，并完成了一些工作，但是我无法从完成的地方检测到该特定系统.是否有任何选项可以获取特定的系统?
这里提供更多详细信息---

不，我没有得到LoginName字段和其他字段.它显示的是LoginName字段和其他我的系统名称，该名称是从我的系统发送邮件到特定客户端的，但是它是由其他人通过我的系统从远程桌面连接完成的，所以我如何获取该系统名称或任何提示，请帮忙

感谢All

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

推荐答案

感谢您的提问，请使用以下代码

Thank you for your question, use the following code

sp_helpuser

您会找到LoginName字段和其他内容.


谢谢，
Mamun

You will find LoginName field and other.


Thanks,
Mamun

您的问题有误导性.您的标题为SQL 2008，但问题是有关远程桌面连接的.好吧，让我看看我是否正确.您正在尝试确定哪个用户通过远程桌面连接了您，对吗?如果是这样，请检查您的事件日志.应当有一个用于远程用户登录名/徽标的日志.

如果问题与SQL 2008登录信息有关，那么他们必须使用您的sql登录凭据.我不确定是否可以从SQL 2008中获得该信息，但事件日志中可能又有一些内容.

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.

这篇关于sql 2008查询以获取登录信息的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！