User Documentation Ispirer Capabilities - Microsoft SQL Server Migration Pricing


System table – sysmessages

Compatability view should be upgraded to catalog view.

Microsoft SQL Server 2000: 

SELECT … FROM master.dbo.sysmessages

Microsoft SQL Server 2008: 

SELECT … FROM sys.messages

Column conversion:

Microsoft SQL Server 2000 (sysmessages) Microsoft SQL Server 2008 (sys.messages)
description text
msglangid language_id
error message_id