COMPATIBILITY_LEVEL 100 SQL Server 2008 and SQL Server 2008 R2 SQL Server 2008 through SQL Server 2016
we should use only one of them, not all of them, right? I usually only do the first one.Yes. Use the one you feel more comfortable with.
last night we announced to the whole world that we will upgrade it to SP4I didn't see it on the news :)
"For the upgrade, here is a good list that I found: http://thomaslarock.com/2014/06/upgrading-to-sql-server-2014-a-dozen-things-to-check/
Open in new window
I think we should do it before upgrade, right?
did you follow this to do the upgrade? did you upgraded yet and what is the problem you will see and how you solve that?