thax I have test in query analyzer it is work .
but still don't know why in the view designer prompt error after save ( if test it in view designer is work fine ) anyway thax you !
(* it prompt ".....not support transaction .....")