Arithmetic overflow error and isdate sql

Executing a t-sql statement with a convert function

 convert(datetime, my_date_column)            ,           

 threw an arithmetical overflow error with the message :

Message
 Arithmetic overflow error converting expression to data type datetime. [SQLSTATE 22003] (Error 8115)  The statement has been terminated. [SQLSTATE 01000] (Error 3621).  The step failed.

Use  the ISDATE function  , to identify invalid dates (or valid dates). Clean up as necessary.

Returns 1 if the expression is a valid date, time, or datetime value; otherwise, 0.

select seq_number
from   dbo.STAGING_TABLE 
where  ISDATE(my_date_column ) = 0
and  my_date_column  

 Read More

SQL Server – Send email using Powershell - SQL Server DBA

SQL Server - Powershell and SQL Error Logs

SQL Server DBA Top 10 automation tasks

SQL Server - Top 10 DBA mistakes