mercredi 29 juin 2016

Error restoring SQL Server 2005 db to a 2012 instance - Statistics 'colid' is dependent on column 'colid'

We're upgrading from a SQL Server 2005 instance to SQL Server 2014. Because SQL Server 2014 doesn't play with SQL Server 2005, I'm using an instance of 2012 as an interim to bring the compatibility level up to where SQL Server 2014 will play with it.

Have a small database with only 1 table but a load of views and stored procedures that, upon restoring to SQL Server 2012, is throwing the error:

System.Data.SQLClient.SQLError: The statistics 'colid' is dependent on column 'colid'.

I ran DBCC on it and no errors were indicated. Did an Update Statistics on the only table.

Aucun commentaire:

Enregistrer un commentaire