SQL Server 2008 Upgrade Advisor 不會掃描 Agent Job Step的相容性

例如 Step 如下

image

雖然 SQL Server 2008 不允許使用 *= 來做 Left outer join

select * from customers c,orders o
where c.customerid *=o.customerid

但 Upgrade Advisor 不會掃描到這一步不相容

或許,你可以透過 msdb 內的 sysjobsteps 資料表,將 command 的內容存檔後,交給 Upgrade Advisor 工具程式掃描

image

發表迴響

在下方填入你的資料或按右方圖示以社群網站登入:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / 變更 )

Twitter picture

You are commenting using your Twitter account. Log Out / 變更 )

Facebook照片

You are commenting using your Facebook account. Log Out / 變更 )

Google+ photo

You are commenting using your Google+ account. Log Out / 變更 )

連結到 %s

%d 位部落客按了讚: