Help in Finding out | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Help in Finding out

Hi How to find out the following settings from the SQL SERVER database? 1. sorting and case sensitivity of a database ? is it collation?
2. What is the decimal places set for <DB> ? Thanks In Advance.
1. Correct.
2. AFAIK, you set the number of decimals wherever you define a field with decimals, or declare a variable with decimals. Not sure if there’s a default for the number of decimals.
1: You might find
useful to determine collation. 2: Not sure what you exactly mean by it, but default precision is 18 with a maximum precision of 38. You can read it in BOL at ‘precision of data type’.


Returns the precision level used by decimal and numeric data types as currently set in the server
I think the default will be precision of 5 and a scale of 2. Satya SKJ
This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
or sp_helpsort Luis Martin
Moderator All postings are provided “AS IS” with no warranties for accuracy.
Thank You very much. It helps me very lot.
Thanks once again. Nagesh