SQL Server 2005 Performance Dashboard (Difference of two datetime values caused an overflow at runtime) error Message
Saya mengalami error "Difference of two datetime values caused an overflow at runtime" pada saat membuka "performance_dashboard_main_report"
untuk mengatasinya ganti potongan script di bawah ini
sum(convert(bigint, datediff(ms, login_time, getdate()))) - sum(convert(bigint, s.total_elapsed_time)) as idle_connection_time,dengan script ini
sum(convert(bigint, CAST ( DATEDIFF ( minute, login_time, getdate()) AS BIGINT)*60000 + DATEDIFF ( millisecond, DATEADD ( minute, DATEDIFF ( minute, login_time, getdate() ), login_time ),getdate() ))) - sum(convert(bigint, s.total_elapsed_time)) as idle_connection_time,
~~>>Terima Kasih<<~~
Komentar
Posting Komentar