Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
gangadhara.ms
Aged Yak Warrior
549 Posts |
 Posted - 2013-02-22 : 05:34:01
|
| Hi,I am doing in-place upgrade from 2005 to 2008.Upgrade adviser shows 2 issues.Please help me to fix these issues.1.Invalid object name "sys.symmetric_keys"2.Full-text search has changed in SQL Server 2008.Thanks,Gangadhara |
|
|
jackv
Master Smack Fu Yak Hacker
2179 Posts |
Posted - 2013-02-23 : 02:12:30
|
| For the first one - what service pack are you running on sql server 2005? are you on at ;east on service pack 3?Jack Vamvas--------------------http://www.sqlserver-dba.com |
 |
|
|
prett
Posting Yak Master
212 Posts |
Posted - 2013-02-25 : 00:07:00
|
| For this error message: Full-text search has changed in SQL Server 2008: Please refer to In-Place Upgrade and Side-by-Side Upgrade sections in SQL Server 2008 Upgrade Technical Reference Guide, which listed detailed actions to upgrade Full-Text Search to SQL Server 2008 (applies to SQL Server 2008 R2 as well). |
|
|
|
gangadhara.ms
Aged Yak Warrior
549 Posts |
Posted - 2013-02-27 : 00:01:10
|
| Yes for the first issue i am on SQL server 2005 with SP3 but still its showing in upgrade advisor report with "when to fix -before"Thanks,Gangadhara MSSQL Developer and DBA |
|
|
|
|
|
|
SQL 2008 Upgradation - upgrade advisor issues