2005 schema question

[Catadmin]

We have a weird schema on our 2k5 DB called "sys". I think it's a user schema, but wanted to verify that no one else has this schema on their system.

Also, If I delete the guest schema, do you think it would create a problem?

Thanks,


Catadmin - MCDBA, MCSA
"No, no. Yes. No, I tried that. Yes, both ways. No, I don't know. No again. Are there any more questions?"
-- Xena, "Been There, Done That"

 

[katgirl]

from bol:

Every database you create has a predefined sys XML schema collection in the sys relational schema. It reserves these predefined schemas, and they can be accessed from any other user-created XML schema collection. The prefixes used in these predefined schemas are meaningful in XQuery. Only xml is a reserved prefix.

 

[Catadmin]

Danke, Katgirl! Didn't see that one in BOL. What keyword did you use to pull that up?



Catadmin - MCDBA, MCSA
"No, no. Yes. No, I tried that. Yes, both ways. No, I don't know. No again. Are there any more questions?"
-- Xena, "Been There, Done That"