Re: Entity Relationship Diagram
"Patrick Prince" <PatrickPrince@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:B97A70C5-1091-4A3C-B5A3-55FEFBE04D67@xxxxxxxxxxxxxxxx
> Does anyone know of an Entity Relationship Diagram, ERD, for the SMS 2003
> schema? I'm a sql user and prefer to use Query Analyzer over WQL.
>
Doesn't exist, at least not publicly... it is recommended to use the sms
views associated with the database for any data retrieval. You can get an
idea of the schema by dissecting the views.
Steve
.
Relevant Pages
- Re: replacing a sms server
... Domain computers that have an sms 2003 client installed can have it ... Windows Server System MVP - SMS ... It is advised to follow the procedure below, before any schema modifications ...
(microsoft.public.sms.setup) - Re: replacing a sms server
... Domain computers that have an sms 2003 client installed can have it upgraded to sccm 2007 clients without you needing to manually uninstall the clients, so you should be fine there. ... Deactivating the server can be as simple as uninstalling it, make sure the objects are removed from the system management container in AD. ... It is advised to follow the procedure below, before any schema modifications are made, not just sms 2003 schema extentions. ...
(microsoft.public.sms.setup) - Re: Schema Update Problem
... rebooting the SMS server and re-running extadsch.exe from the sms server. ... I have confirmed the Schema Master is also my Master AD Server. ... Error code = 8245. ...
(microsoft.public.sms.setup) - Re: error 5436 & 4913
... You can extend the schema afterwards by running extadsch.exe. ... >> Requirements to Publish SMS Information to Active Directory ... >> Hierarchy Manager and SMS Site Component Manager use the SMS Service ...
(microsoft.public.sms.setup) - Re: replacing a sms server
... to keep from the previous SMS server. ... domain computers that have the sms client installed. ... this is the safest way of extending your schema. ... Locate the server that is the schema master ...
(microsoft.public.sms.setup) |
|
