Post reply

How to change the size of a user defined data type in SQL Server 2000 Enterprise Manager.

  • September 14, 2004 at 3:36 pm

    #59981

    I would like to find a utility that would allow changing the size of a user defined datatype, and have that change applied to the files that use that data type.

    Anyone know of a way to do this?

  • September 16, 2004 at 12:20 am

    #523265

    Using SQL-DMO objects, you can access the ListBoundColumns method on the UserDefinedDatatype Object.

    Read BOL and check out the Samples directory for details about using DMO. The object heirarchy is displayed in BOL under "Application Object (SQL-DMO)"

    Julian Kuiters
    juliankuiters.id.au

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply