Ispirer Website
Ispirer Capabilities - Microsoft SQL Server Migration
Free Trial
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 |