Simply execute the following command:
DBCC CHECKIDENT('TableNameHere', RESEED, 0);How to reset auto increment in msSQL
Leave a reply
Monthly Archives: February 2012
Setting Static IP in Linux
To setup a static IP in ubuntu, edit your networking settings file.
Here is an example of how to do it:
Open /etc/network/interfaces:
Use these configurations:
auto lo
iface lo inet loopback
auto eth0
iface eth0 inet static
address 192.168.0.10
network 192.168.0.0
netmask 255.255.255.0
broadcast 192.168.0.255
gateway 192.168.0.1
DHCP Address Configuration:
auto lo
iface lo inet loopback
auto eth0
iface eth0 inet dhcp
Then restart the service: /etc/init.d/networking restart (Make sure you are running with admin privileges when restarting 🙂 )