Problem getting information form system tables

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • bkelly1977
    New Member
    • Mar 2008
    • 1

    Problem getting information form system tables

    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.
Working...