Results 1 to 5 of 5

Thread: sysconstraints view

  1. 05-16-2003, 09:32 AM #1
    knicholson
    knicholson is offline Registered User
    Join Date
    Sep 2002
    Posts
    51

    sysconstraints view

    I'm not quite sure how this happened but the type for the sysconstraints and syssegments views are no longer System, they are user. Is there a Stored Procedure or some command to change this back?

    Thanks,
    Ken Nicholson
    Reply With Quote Reply With Quote
  2. 05-16-2003, 10:25 AM #2
    rmiao
    rmiao is offline Registered User
    Join Date
    Sep 2002
    Posts
    5,938
    Not as I aware.
    Reply With Quote Reply With Quote
  3. 05-16-2003, 11:07 AM #3
    MAK's Avatar
    MAK
    MAK is offline Registered User
    Join Date
    Sep 2002
    Location
    Fantasy
    Posts
    4,254
    are those user created / owned?
    My Site:http://www.mssqlengineering.com
    My Book:http://www.wiley.com/WileyCDA/WileyT...470477288.html
    Reply With Quote Reply With Quote
  4. 05-16-2003, 11:26 AM #4
    knicholson
    knicholson is offline Registered User
    Join Date
    Sep 2002
    Posts
    51
    Yes, SQL will let me delete the views.
    Reply With Quote Reply With Quote
  5. 05-16-2003, 11:29 AM #5
    rmiao
    rmiao is offline Registered User
    Join Date
    Sep 2002
    Posts
    5,938
    They are created by sql installation, and you can change type to user by modifying system tables but can't change it back to system.
    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