Showing posts with label newbies. Show all posts
Showing posts with label newbies. Show all posts

Wednesday, March 7, 2012

Newboe: table containing XML schemas in database

I just created a schema in the AdventureWorks DB (the place for newbies). Where are these schemas stored and what t-sql statement can list all XML Schemas defined in a database\table\column?

TIA,

Barkingdog

select x.name, t.name, c.name
from sys.column_xml_schema_collection_usages cx,
sys.tables t,
sys.columns c,
sys.xml_schema_collections x
where x.xml_collection_id = cx.xml_collection_id
and t.object_id = cx.object_id
and c.column_id = cx.column_id
and c.object_id = t.object_id

The best way to learn this (catalog views) is thru SQL Server Management Studio -> Object Explorer -> Database -> master -> Views -> System views. Just do select * from every one of them.

newbies help 2 questions

There is 1 error when i tried to install msde into my window 2003 server web edition.
1. I use command prompt to enter c:\\sql2ksp3>setup SAPWD=aA1234567
the errors is "go to the control panel to install and configure system components"
How do i install ?

Sql client for 2003 server web edition
2. i tried to install sql client in window 2003 web edition but the msdn cd could not start after i double click on the setupsql.exe. I thought the sql client can be install but not the server on web edition ?I have solve Q1 above by using run the type in
Setup.exe /qb+ INSTANCENAME=NetSDK DISABLENETWORKPROTOCOLS=1 SAPWD=<YOUR SA PASSWORD
It seems you cannot double click on the setup.exe in the extracted folder and you cannot use the ms-dos command prompt becuase both return errors like,
"A strong SA password is required for security reason. Please us SAPWD switch to supplyt he same. Refer to readme for more details. Setup will now exits."
or
"Go to the control panel to install and configure system components"

Hope some one can help on Q2|||I think you can not install sql clinet tools on 2003 WE