SQL Server primary key's are usually uniqueidentifiers. Here's a couple of links documenting stuff around this.
http://made-of-stone.blogspot.com/2006/06/about-turn-or-how-to-use-ruby-on-rails.html
http://www.agileprogrammer.com/dotnetguy/archive/2005/10/27/8991.aspx
