SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

IP6 Addresses Could Break Your DB

I saw this post from Rick Strahl about IP6 Addresses in Vista breaking some code, and it immediately made sense that we're probably going to feel some pain on the db site. While all it may take is altering a column on our side (which increases space usage of course) but it could also result in proc changes, and even application code depending on how things were typed. As much as I read I tend to not focus on the networking side of things very much because I've either had a network admin, or just opted to do without one because we only had a couple servers. Not often that changes on their side affect us, but this is one.

I'd suggest checking tables for storage of IP addresses, applications that process server logs into tables, and application code/procs that log the users IP address (obviously common in web apps).


I'm Andy Warren, currently a SQL Server trainer with End to End Training. Over the past few years I've been a developer, DBA, and IT Director. I was one of the original founders of SQLServerCentral.com and helped grow that community from zero to about 300k members before deciding to move on to other ventures.


No comments.

Leave a Comment

Please register or log in to leave a comment.