Ispirer Website Ispirer Capabilities - Microsoft SQL Server Migration Free Trial


System table – systypes

Compatability view should be upgraded to catalog view.

Microsoft SQL Server 2000:

SELECTFROM systypes

Microsoft SQL Server 2008:

SELECTFROM sys.types

Column conversion:

Microsoft SQL Server 2000 (systypes) Microsoft SQL Server 2008 (sys.types)
xusertype user_type_id
xtype system_type_id
name name

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