Server default collation change or not change
I worked out this issue and share it here, in case someone needs it in future.

The default collation setting is determined by the server locale. For most English speaking countries is it : Latin1_General_CI_AS

If the server locale setting has been left as default which is English (United States), the collation at time of MS SQL Management Studio would be set to SQL_Latin1_General_CP1_CI_AS. 


You can check the collation for each local in the following url:

http://msdn.microsoft.com/en-us/library/ms143508.aspx