• if i have 50 columns in a table of datatype varchar then do i need to manually change the collation using ALTER for each column..:w00t:

    _______________________________________________________________
    To get quick answer follow this link:
    http://www.sqlservercentral.com/articles/Best+Practices/61537/