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) 

Microsoft SQL Server 2008:

SELECT … FROM master.dbo.spt_datatype_info spt_dtp 

For this table also required creation of the additional object:

USE master
GO
IF EXISTS (SELECT * FROM sys.objects WHERE object_id = object_id(N'[dbo].[spt_datatype_info]') AND OBJECTPROPERTY(object_id, N'IsUserTable') = 1)
DROP TABLE [dbo].[spt_datatype_info]
GO
 
CREATE TABLE [dbo].[spt_datatype_info] (
 [TYPE_NAME] [sysname] NOT NULL ,
 [DATA_TYPE] [SMALLINT] NOT NULL ,
 [PRECISION] [INT] NULL ,
 [LITERAL_PREFIX] [VARCHAR] (32) COLLATE Japanese_CA_AS NULL ,
 [LITERAL_SUFFIX] [VARCHAR] (32) COLLATE Japanese_CA_AS NULL ,
 [CREATE_PARAMS] [VARCHAR] (32) COLLATE Japanese_CA_AS NULL ,
 [NULLABLE] [SMALLINT] NOT NULL ,
 [CASE_SENSITIVE] [SMALLINT] NOT NULL ,
 [SEARCHABLE] [SMALLINT] NOT NULL ,
 [UNSIGNED_ATTRIBUTE] [SMALLINT] NULL ,
 [MONEY] [SMALLINT] NOT NULL ,
 [AUTO_INCREMENT] [SMALLINT] NULL ,
 [LOCAL_TYPE_NAME] [sysname] COLLATE Japanese_CA_AS NULL ,
 [MINIMUM_SCALE] [SMALLINT] NULL ,
 [MAXIMUM_SCALE] [SMALLINT] NULL ,
 [SQL_DATA_TYPE] [SMALLINT] NOT NULL ,
 [SQL_DATETIME_SUB] [SMALLINT] NULL ,
 [RADIX] [SMALLINT] NULL ,
 [INTERVAL_PRECISION] [SMALLINT] NULL ,
 [USERTYPE] [SMALLINT] NULL
)
GO
INSERT [dbo].[spt_datatype_info] EXEC sp_datatype_info
GO
 
ALTER TABLE [dbo].[spt_datatype_info] ADD [ss_dtype] [SMALLINT] NULL
GO
 
UPDATE [dbo].[spt_datatype_info] SET [ss_dtype] = user_type_id FROM sys.types WHERE [name] = CASE
 WHEN charindex('(', [TYPE_NAME]) > 0 
  THEN LEFT([TYPE_NAME], charindex('(', [TYPE_NAME])-1)
 WHEN charindex(' ', [TYPE_NAME]) > 0 
  THEN LEFT([TYPE_NAME], charindex(' ', [TYPE_NAME])-1)
 ELSE [TYPE_NAME] END
GO
 
ALTER TABLE [dbo].[spt_datatype_info] ADD [charbin] [SMALLINT] NULL
GO
 
UPDATE [dbo].[spt_datatype_info] SET [charbin] = 0
  WHERE LOWER([TYPE_NAME]) IN ('char', 'varchar', 'text', 'ntext', 'nvarchar', 'nchar', 'binary', 'varbinary', 'sql_variant', 'image', 'timestamp')
GO

Column conversion: