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<<~~

Subscribe to receive free email updates:

0 Response to "SQL Server 2005 Performance Dashboard (Difference of two datetime values caused an overflow at runtime) error Message"

Posting Komentar