Is there any way to view the current collation order?

[Redd_Green_At_Hotmail]

On the TOols/Options/General page, you can set the collation order for the
next compact/repair operation.

Where can you view what the value is set to currently? Is this a per-table
setting?

HELP!!!

 

[Allen Browne]

You can read the value with:
GetOption("New Database Sort Order")

1033=General. For the meaning of other values, see:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnacc2k/html/acglobaloptions.asp

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

in message
news:[email protected]...