Hi
This query works on QA, but fails on DEV with "Arithmetic overflow occurred".
SELECT lct_admin('num_logpages', dbid) UsedPages, lct_admin('logsegment_freepages',dbid) FreePages,100.0 - lct_admin('num_logpages', dbid) * 100.0 /(lct_admin('logsegment_freepages',dbid) + lct_admin('num_logpages', dbid)) PctFree FROM master..sysdatabases WHERE name = 'MED'
I need to get it working, as it is build into a script that need to execute.
Please advise?