SQL IP Address and netgear setup
========================
Delete all the tables in a database mssql
==========================
EXEC sp_MSforeachtable @command1 = “DROP TABLE ?”
this is a hidden SP in sql server, this will be executed for each table in the database you connected (you cant
rollback this)
========================
Error netgear 834
========================
the system has detected an ip address conflict with another system on the network.
To fix I went to the router and found the mac address being used and changed it.
Then for all of the cpus I set the router ip as the static ip for the computer in tcp/ip settings for the local area
connection. Afterwards you must put in the dns servers from the router also. Then to make sure that it didn’t
happern again I set address reservation to a mak of 192.168.0.5 and rerouted to the specific computer.
Also turned off upnp and dyndns.
========================
To set the ip address to be static in windows from dos
========================
First type:
ipconfig /all
—
You should see then something like:
+———————————————————+
|Windows IP Configuration |
| |
| |
|Ethernet adapter VMware Network Adapter VMnet8: |
| |
| Connection-specific DNS Suffix . : |
| IP Address. . . . . . . . . . . . : 192.168.118.1|
| Subnet Mask . . . . . . . . . . . : 255.255.255.0|
| Default Gateway . . . . . . . . . : |
| |
|Ethernet adapter VMware Network Adapter VMnet1: |
| |
| Connection-specific DNS Suffix . : |
| IP Address. . . . . . . . . . . . : 192.168.186.1|
| Subnet Mask . . . . . . . . . . . : 255.255.255.0|
| Default Gateway . . . . . . . . . : |
| |
|Ethernet adapter Ethernet Broadcom 440x 10 100 built in: |
| |
| Connection-specific DNS Suffix . : |
| IP Address. . . . . . . . . . . . : 192.168.0.3 |
| Subnet Mask . . . . . . . . . . . : 255.255.255.0|
| Default Gateway . . . . . . . . . : |
| |
|Ethernet adapter Network Bridge (Network Bridge) 13: |
| |
| Connection-specific DNS Suffix . : |
| Autoconfiguration IP Address. . . : 189.244.93.4 |
| Subnet Mask . . . . . . . . . . . : 255.255.0.0 |
| Default Gateway . . . . . . . . . : |
+———————————————————+
So to change the IP address of your Broadcom network card to
192.168.0.4, you should type:
netsh interface ip set address name=”Ethernet Broadcom 440x 10 100
built in” source=static addr=192.168.0.4 mask=255.255.255.0
====================
find the mac addresses of systems on the network
=====================
arp -a
==================
dos Flush and reset a client resolver cache using the ipconfig command
=================
ipconfig /flushdns
ipconfig /release
ipconfig /renew