Results 1 to 3 of 3

Thread: Alter an UDD without dropping

  1. 07-06-2006, 12:12 PM #1
    ganesann
    ganesann is offline Registered User
    Join Date
    Jul 2006
    Posts
    2

    Alter an UDD without dropping

    How to Alter an UDD (user defined data types) without dropping it & recreating it (as it has many dependencies now). In SQL 2000 some script exists, it is giving error that "No direct update to system catalogues is allowed". Is there a way to do this in SQL 2005.
    Reply With Quote Reply With Quote
  2. 07-06-2006, 03:09 PM #2
    rmiao
    rmiao is offline Registered User
    Join Date
    Sep 2002
    Posts
    5,938
    No, you can't modify them.
    Reply With Quote Reply With Quote
  3. 07-06-2006, 11:55 PM #3
    ganesann
    ganesann is offline Registered User
    Join Date
    Jul 2006
    Posts
    2
    Thanks for your response.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules