Re: Description of SQL tables.



"MaxZ" <MaxZ@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:6521D473-577A-4A96-BCA6-B59811DCAABB@xxxxxxxxxxxxxxxx
>
>
> "Steve Thompson" wrote:
>
> > MaxZ" <MaxZ@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
> > news:196AB65E-D4E7-4D86-8460-77746D1FC5E5@xxxxxxxxxxxxxxxx
> > > Dose anybody know any documentation, which describe structure of SMS
2003
> > > Database (=SQL)? I would be grateful for any references about table
> > structure
> > > and relations.
> >
> > Someone just asked this... the schema is not published or available to
the
> > public.
> >
> > It is recommended to use the views associated with the sms database, and
> > with some digging, it is possible to understand the sms db schema.
> >
> > ST
> Thank you for comment. By the problem is not in query it database. I need
to
> add some additional fileds to tables and some times it is difficult to
> unerstand relationships

I would advise AGAINST adding additional fields to tables in the SMS
database as this clearly places you in unsupported territory. If you ever
have to place an incident call to Microsoft regarding these changes you
could be "stuck".

Steve


.



Relevant Pages

  • Re: Recovery SMS primary site (no backup available)
    ... of synch with your files with your database. ... Check out the SMS Technical FAQ: ... >> the backup work, but it would be in the unsupported realm. ... >>> We had a raid crash during a rebuild of a SMS 2003 primary site server. ...
    (microsoft.public.sms.admin)
  • Re: Moving SMS SQL Database
    ... We have a customer running SMS 2003 in Advanced Security with a remote SMS ... SQL database. ... They need us to move the database to a different server. ... groups and permissions referencing the OLD SQL Server ...
    (microsoft.public.sms.admin)
  • Re: Move SMS Database to new SQL Server
    ... Because you aren't just backing up the database, you're doing a full SMS ... later and move database from a remote server back to the SMS site server.) ... >>> I have SMS running right now on its own SQL server. ...
    (microsoft.public.sms.setup)
  • Re: remote control database could not be found after Windows 2k3 Sp1 update
    ... You could be using a link to an old MMC Console. ... remote control database could not be found after Windows ... 2k3 Sp1 update ... I update my SMS server to Windows 2003 SP1. ...
    (microsoft.public.sms.admin)
  • Re: SMS v2 SP4 to SP5 upgrade error
    ... I see that your SMS database is named "SMS" instead of the default ... > but the database does exist in sql enterprise admin. ... > SQL Server name: COTLEIGH ...
    (microsoft.public.sms.admin)