tag:blogger.com,1999:blog-10813201962425067822024-09-21T19:01:36.686-07:00SQL server Managment Studio to get ipAnonymoushttp://www.blogger.com/profile/06731273299234474960noreply@blogger.comBlogger1125tag:blogger.com,1999:blog-1081320196242506782.post-64105993358964874532012-03-30T08:41:00.002-07:002012-03-30T08:41:15.381-07:00Use SQL server Managment Studio to get IP address<span id="internal-source-marker_0.9736824491330567" style="background-color: transparent; color: black; font-family: Arial; font-size: 15px; font-style: normal; font-variant: normal; font-weight: normal; text-decoration: none; vertical-align: baseline;"><br />
</span><br />
<span id="internal-source-marker_0.9736824491330567" style="background-color: transparent; color: black; font-family: Arial; font-size: 15px; font-style: normal; font-variant: normal; font-weight: normal; text-decoration: none; vertical-align: baseline;">You can use SSMS to get it, now.</span><br />
This is how:<br />
<span style="background-color: transparent; color: blue; font-family: Arial; font-size: 15px; font-style: normal; font-variant: normal; font-weight: normal; text-decoration: none; vertical-align: baseline;">xp_cmdshell 'ipconfig'</span><br />
<span style="background-color: transparent; color: black; font-family: Arial; font-size: 15px; font-style: normal; font-variant: normal; font-weight: normal; text-decoration: none; vertical-align: baseline;">One thing to remember is that you have to have xp_cmdshell enabled. How?</span><br />
<span style="background-color: transparent; color: black; font-family: Arial; font-size: 15px; font-style: normal; font-variant: normal; font-weight: normal; text-decoration: none; vertical-align: baseline;">You can do sp_configure</span><br />
<br />
<span style="background-color: transparent; color: #5b0f00; font-family: Arial; font-size: 15px; font-style: normal; font-variant: normal; font-weight: normal; text-decoration: none; vertical-align: baseline;">sp_configure 'show advanced options',1</span><br />
<span style="background-color: transparent; color: #5b0f00; font-family: Arial; font-size: 15px; font-style: normal; font-variant: normal; font-weight: normal; text-decoration: none; vertical-align: baseline;">go</span><br />
<span style="background-color: transparent; color: #5b0f00; font-family: Arial; font-size: 15px; font-style: normal; font-variant: normal; font-weight: normal; text-decoration: none; vertical-align: baseline;">sp_configure</span><br />
<span style="background-color: transparent; color: #5b0f00; font-family: Arial; font-size: 15px; font-style: normal; font-variant: normal; font-weight: normal; text-decoration: none; vertical-align: baseline;">go</span><br />
<span style="background-color: transparent; color: #5b0f00; font-family: Arial; font-size: 15px; font-style: normal; font-variant: normal; font-weight: normal; text-decoration: none; vertical-align: baseline;">sp_configure 'xp_cmdshell', 1</span><br />
<span style="background-color: transparent; color: #5b0f00; font-family: Arial; font-size: 15px; font-style: normal; font-variant: normal; font-weight: normal; text-decoration: none; vertical-align: baseline;">go</span><br />
<span style="background-color: transparent; color: #5b0f00; font-family: Arial; font-size: 15px; font-style: normal; font-variant: normal; font-weight: normal; text-decoration: none; vertical-align: baseline;">sp_configure</span><br />
<span style="background-color: transparent; color: black; font-family: Arial; font-size: 15px; font-style: normal; font-variant: normal; font-weight: normal; text-decoration: none; vertical-align: baseline;">This configuration can can also be done through Facets/Surface Area Configuration. </span>Anonymoushttp://www.blogger.com/profile/06731273299234474960noreply@blogger.com0