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
Moderator
http://www.SQL-Server-Performance.Com/forum
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.

]]>