hi, well, as the title goes, we have to move from sql 2000 to 2008 quickly. We were going to do it some time in the future, we were already replicating the database to make some tests but our sql 2000 has a hardware problem so we have to do it as fast
as we can. We are planning to detach and atach the database on sql 2008. My question is for you all that already went through all this, do you have any advices or good practices to do once we atach our DB? could we have any issue (not query errors, but data
problems) if after ataching the database we set compatibility level to 100? well any advice is really welcome. Thanks!
View Complete Post