If you modify the auto generated class that wraps the web service you can get the raw xml. I was more or less just curious about whether or not the detail I added to my soap exception was being sent to the consumer correctly. See OmegaMans article http://www.codeproject.com/cs/webservices/SerializationFun.asp

They always do if the new records are inserted between existing record unless there is a space according to a previously deleted record. You can minimize this effect by configuring fill factor and padding for indexes. If you use the clustered index as an identity column, fragmentation should not occur. So there is no very direct do and don't in this case. You need to study your database structure carefully. Hesham A. Amin blog