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
Printable 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
Not as I aware.
are those user created / owned?
Yes, SQL will let me delete the views.
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.