Ispirer Migration Knowledge Base sqlways:sql-server:upgrade:systemobjects https://wiki.ispirer.com/ 2026-04-08T08:51:13+00:00 Ispirer Migration Knowledge Base https://wiki.ispirer.com/ https://wiki.ispirer.com/lib/tpl/dokuwiki/images/favicon.ico text/html 2025-03-04T08:59:04+00:00 Anonymous (anonymous@undisclosed.example.com) System table – master.dbo.spt_datatype_info https://wiki.ispirer.com/sqlways/sql-server/upgrade/systemobjects/spt_datatype_info?rev=1741078744&do=diff User Documentation Ispirer Capabilities - Microsoft SQL Server Migration Pricing System table – master.dbo.spt_datatype_info Compatability view should be upgraded to catalog view. Microsoft SQL Server 2000: select … from master.dbo.spt_datatype_info spt_dtp where (spt_dtp.ODBCVer IS NULL OR spt_dtp.ODBCVer = 2) text/html 2025-03-04T08:59:04+00:00 Anonymous (anonymous@undisclosed.example.com) System table – syscolumns https://wiki.ispirer.com/sqlways/sql-server/upgrade/systemobjects/syscolumns?rev=1741078744&do=diff User Documentation Ispirer Capabilities - Microsoft SQL Server Migration Pricing System table – syscolumns Compatability view should be upgraded to catalog view. Microsoft SQL Server 2000: Select … from syscolumns Microsoft SQL Server 2008: Select … from sys.columns Column convesion: Microsoft SQL Server 2000 (syscolumns) text/html 2025-03-04T08:59:04+00:00 Anonymous (anonymous@undisclosed.example.com) System table – syscomments https://wiki.ispirer.com/sqlways/sql-server/upgrade/systemobjects/syscomments?rev=1741078744&do=diff User Documentation Ispirer Capabilities - Microsoft SQL Server Migration Pricing System table – syscomments Compatability view should be upgraded to catalog view. Microsoft SQL Server 2000: select text from syscomments where id = syscolumns.cdefault and colid = 1 Microsoft SQL Server 2008: select definition from sys.default_constraints where object_id = sys.columns.default_object_id text/html 2025-03-04T08:59:04+00:00 Anonymous (anonymous@undisclosed.example.com) System table – sysindexes https://wiki.ispirer.com/sqlways/sql-server/upgrade/systemobjects/sysindexes?rev=1741078744&do=diff User Documentation Ispirer Capabilities - Microsoft SQL Server Migration Pricing System table – sysindexes Compatability view should be upgraded to catalog view. Microsoft SQL Server 2000: Select name from sysindexes where name = '<index_name>' Microsoft SQL Server 2008: Select name from sys.indexes where name = '<index_name>' text/html 2025-03-04T08:59:04+00:00 Anonymous (anonymous@undisclosed.example.com) System table – sysmessages https://wiki.ispirer.com/sqlways/sql-server/upgrade/systemobjects/sysmessages?rev=1741078744&do=diff 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) text/html 2025-03-04T08:59:04+00:00 Anonymous (anonymous@undisclosed.example.com) System table – sysobjects https://wiki.ispirer.com/sqlways/sql-server/upgrade/systemobjects/sysobjects?rev=1741078744&do=diff User Documentation Ispirer Capabilities - Microsoft SQL Server Migration Pricing System table – sysobjects Compatability view should be upgraded to catalog view. Microsoft SQL Server 2000: select … from dbo.sysobjects Microsoft SQL Server 2008: select … from sys.objects Column conversion: Microsoft SQL Server 2000 (sysobjects) text/html 2025-03-04T08:59:04+00:00 Anonymous (anonymous@undisclosed.example.com) System table – systypes https://wiki.ispirer.com/sqlways/sql-server/upgrade/systemobjects/systypes?rev=1741078744&do=diff User Documentation Ispirer Capabilities - Microsoft SQL Server Migration Pricing System table – systypes Compatability view should be upgraded to catalog view. Microsoft SQL Server 2000: select … from systypes Microsoft SQL Server 2008: select … from sys.types Column conversion: Microsoft SQL Server 2000 (systypes)