Default Precision in SQL Server 7 | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Default Precision in SQL Server 7

How can I tell whether a running SQL Server 7 is using default precision 28 or has been changed besides checking the registry or test it out? I don’t find the information in SQL Server Log.
SELECT @@MAX_PRECISION will give you the information and I think the default precision is 38.
Satya SKJ
This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
Hi Satya, Thanks for the info. The default is 28 in SQL 7 and 38 in SQL 2000.