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:

SELECTFROM master.dbo.sysmessages 

Microsoft SQL Server 2008:

SELECTFROM sys.messages 

Column conversion:

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

© 1999-2024, Ispirer Systems, LLC. All Rights Reserved.