the problem is that when you try to preview the data written in arabic from sql client you will find it "?" , so i searched how to solve this all the solutions i found to uninstall the MS sql then change the regional setting to arabic then install MS sql again , but i dont wanna do that , i wanna s solution to see these arabic character with out uninstall
Did you read the article? It is a fairly comprehensive description of what is causing your problem.
You shouldn't need to uninstall the SQL Server client tools (and certainly you don't need to uninstall SQL Server it supports Arabic fine). Microsoft applications will all pick up the regional settings if you change them without needing reinstalled.
Assuming your data model uses a unicode data type to store the data and your client can support Arabic you should be able to see it fine.
This shouldn't matter. The collation only applies to text manipulation logic (sorting and the like) and shouldn't affect the underlying data - unless you use a TSQL function that also relies on the collation to manipulate the data. For example I'm currently looking at Arabic data in a SQL Server instance that has a Latin1_General_CI_AS collation.
I’ve looked at a lot of different solutions, and in my humble opinion Aspose is the way to go. Here’s the link: http://aspose.com