Problem getting information form system tables

[bkelly1977]

Hi all,

I am trying to create a program in VB.NET that will go through the system tables of an SQL Server 2000 database and recreate it.

I am making good progress but I have a couple of problems and need a bit of help.

Firstly, when recreating the tables float type values are seen as real type values, why is this?

Secondly, I need to know the scale and precision values for decimals like MyDecimalField (18,2). Where do I find the 18 and 2 parts?

Any help would be greatly appreciated.

Thank you.