>Roles.Description is char (30). SQL-Server allows 128 character role names. How about changing Roles.Description to varchar (128) ?
Kevin McNeish
Eight-Time .NET MVP
VFP and iOS Author, Speaker & Trainer
Oak Leaf Enterprises, Inc.
Chief Architect, MM Framework
http://www.oakleafsd.com