How should I store an IP address in SQL Server?
Four tiny INTs, as has been suggested, is a good solution if you will be looking at particular octets and/or doing manipulating/grouping at that level.
A VARCHAR(15) if you are going for plain, basic storage of an IPv4 - including the periods. Best suited for simple inventory.
No one has followed this question yet.