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) Microsoft SQL Server 2008 (sys.objects)
id object_id
xtype type
uid schema_id
name name