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.
Nagesh

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
SELECT SERVERPROPERTY(‘collation’)
SELECT DATABASEPROPERTYEX(‘pubs’,’collation’)
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’.
—
–Frank
http://www.insidesql.de

SELECT @@MAX_PRECISION
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
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided â€œAS ISâ€ with no rights for the sake of knowledge sharing.

or sp_helpsort Luis Martin
Moderator
SQL-Server-Performance.com All postings are provided â€œAS ISâ€ with no warranties for accuracy.

Thank You very much. It helps me very lot.
Thanks once again. Nagesh

]]>