answersLogoWhite

0


Best Answer

exec master..xp_cmdshell 'ipconfig'

User Avatar

Wiki User

11y ago
This answer is:
User Avatar

Add your answer:

Earn +20 pts
Q: How do you find host ip address in sql server?
Write your answer...
Submit
Still have questions?
magnify glass
imp
Related questions

Where can someone find information on clustering a SQL server?

There are many places where one can find information on clustering an SQL server. One can find this information from many different SQL related how-to sites.


How does a person configure SQL server hosting?

To begin the process of the configuration of SQL server hosting, one needs to have a website. From there, one will be required to log on to their account and go to the "Web Hosting" section. Afterwards, one will be able to create the database server that one wants to host under the "Databases" section. One can find that the configuration of SQL server hosting is completed.


Where can someone find information about SQL Server Backup software?

Someone is able to find information about SQL Server Backup software at several different webpages online such as the following: the SQL Wikipedia page and the SQL website.


Where can one find a SQL server monitoring tool?

You can find a free SQL server monitoring tool at the SpiceWorks website. Once on the page, scroll to the bottom and click on "SQL Server Monitoring" under "Monitoring" in the page footer.


Difference between sql server 2003 sql server 2005?

There is no such thing as SQL Server 2003. Microft released SQL Server 2005 as the next version of SQL Server 2000.


Where can one find information on SQL server 2005 replication?

You can find information on SQL Server 2005 replication in the official Microsoft documentation, such as the SQL Server Books Online or on the Microsoft website. Additionally, there are various online resources, forums, and tutorials dedicated to SQL Server replication that can provide valuable insights and guidance.


Where online can I find more information about SQL server classes?

here are three principal sources of information from Microsoft about SQL Server: The documentation, tutorials, and samples installed with SQL Server. The SQL Server sites on the Microsoft Developer Network (MSDN) and TechNet. SQL Server information on additional Microsoft Web sites. If you do not find the information you are looking for in these sources, you can either post questions in the SQL Server community forums and newsgroups, or you can open a support case with Microsoft.


Introduction to sql server?

The nintroduction sql server is are the following


Where is the SQL server management studio located?

The SQL server management studio is located in California. A simple search is all you would need to locate the exact address of the place. It is not accessible to the public.


Where could one purchase a Sequel or SQL server?

The Sequel, or SQL, Server is owned by Microsoft. One can purchase an SQL Server from the Microsoft website. Microsoft also offers a free trial of the SQL Server.


How do you find port number of a sql server?

In SQL Server 2005/2008 : Sql Server Configuration Manager -> Protocols -> TCP/IP -> IP Addresses -> TCP Port. In SQL Server 2000 : Client Network Utility -> Select 'TCP/IP' from the enable protocols list and press 'Properties' button. The default port is 1433.


Describe IDE of SQL Server 2005?

An IDE for SQL Server 2005 refers to an Integrated Development Environment for SQL Server 2005. This is a tool that can be used by a programmer to create and maintan a SQL server database. Some commonly used IDE tools for SQL Server 2005 are:SQL Server Management StudioTOAD for SQL ServerTOAD for Data Analysts