I even recommend that the developers modify the code in the programs to check for invalid date format with no prevail.

I agree with you hundred percent but this is a legacy system and management is afraid to change the data type in fear that it may cause other problems.

Did you find a solution? I have the same problem. I am using transferring login from SQL Server 2008 r2 to 2012

sorry about that I was testing the query earlier and I forgot to change the 5 to @dbid

I am trying to defrag indexes on user databases. I don't believe heap tables have indexes.