If I attach a 2005 database to a 2008 instance and run it at compatibility level 90 (i.e. 2005) does the orignal 2005 database service pack level make any difference? In other words if I had two identical 2005 databases X and Y with X running on a server with no service pack (RTM) and Y running on a 2005 SP3 instance will they be treated any differently if they are both attached/restored to a 2008 instance?
asked Oct 04, 2010 at 05:56 AM in Default
No, because the compatibility level you're running under is 2008. So while you still have the databases in something resembling 2005, they're not in 2005, they're in 2008, just running under the compatibility level.
answered Oct 04, 2010 at 06:01 AM
Grant Fritchey ♦♦