I note another change that should be made regarding get_column_details.

xtype for nvarchar and sysname are the same in the systypes table, so you should make the following change or you...

Actually, this is a better way to show the column type

alter procedure [dbo].[get_column_details] @table_name nvarchar(128)

as

select

cast(o.[name] as char(30)) as 'table_name',

...

This should work for what I think you want.

go

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

create procedure [dbo].[makeDataDictionary] as

DECLARE @table_name nvarchar(128)

DECLARE @strTable nvarchar(256)

SET NOCOUNT ON

DECLARE tablenames_cursor CURSOR...