December 5, 2008 at 9:18 am
How can I check if the sort order of a database is binary? Also is it possible to change the sort order at database level, when the server default level is different? If so how ?
December 6, 2008 at 5:18 pm
Run sp_helpsort under that database.
Mj
December 7, 2008 at 5:20 am
In regards to your first question and since you are looking for binary sort order, please follow previous advise and check sort order is in the *_BIN form.
Answering your second question: No, you can't. Database should be rebuilt and data reloaded.
_____________________________________
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at Amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply