I can't make your sample data for dbo.account fit into the table defintion you posted.

I get "string or binary data would be truncated".