The client obtains the MAC address of the SQL Server.

Source: Internet
Author: User

Make an encryptionProgramTo obtain the MAC address of the current server, but it is not that simple. Most of the recommended network methods use xp_mongoshell to execute ipconfig/all, and then write the extended storage process on your own. But we also see another method.

Http://topic.csdn.net/u/20070910/12/3d9673e0-dfe4-4c6e-aa8a-1c201bc89df2.html

Use the following SQL statement:

Select *, net_address from Master .. sysprocesses
Where hostname = '? '
And program_name = '? '
The premise of its effectiveness is to know the server name, but this does not guarantee to obtain the NIC address, because the server does not necessarily have a program similar to the client running. However, this lucky time, the server has a timed detection tool running, and this tool is unlikely to run on the client. Therefore, I can not even name the server, specifically specify the process to find a program name, to see how much mac it is.

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.