SQL Server Performance Forum – Threads Archive
Default Precision in SQL Server 7How 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.
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.