locked
Which Database table holds all announcements,calenders and email alerts RRS feed

  • Question

  • Hi,

    I wouls like to know which table holds all announcements,calenders and email alerts

     

    Thanks


    CRM Manager
    • Changed type Mike Walsh FIN Tuesday, March 15, 2011 7:19 PM q
    • Moved by Mike Walsh FIN Tuesday, March 15, 2011 7:20 PM Nothing to do with BI (From:SharePoint - Business Intelligence (pre-SharePoint 2010))
    Tuesday, March 15, 2011 4:11 PM

Answers

All replies

  • First, I'll make the obligatory comment that you shouldn't query the database directly.  I believe that even running a readonly query jeopardizes your microsoft support contract.

    That said, this link is old but maybe useful: http://manish-sharepoint.blogspot.com/2008/06/some-important-tables-with-sharepoint.html

    Most of the links here are about managing the sql database, but you may find something useful as well: http://www.delicious.com/pagalvin/sql

    What's your goal? There is a chance you can do what you need without hitting the SQL db directly.


    --Paul Galvin, BrightStarr
      Microsoft MVP - SharePoint
      Blogging @ http://www.mstechblogs.com/paul
      Twitter @ http://www.twitter.com/pagalvin
    • Marked as answer by David HM Wednesday, March 23, 2011 6:00 AM
    Tuesday, March 15, 2011 8:34 PM
  • Hi flashyjunior,

     

    Like Paul said above, Microsoft recommends that customers do not directly operate or modify the database. Because improper operation will cause a lot of known or unknown issues. You can tell us your needs if it is convenient, so that we can find workable solutions for you.

     

    Thanks & Regards,

    Peng Lei

    • Marked as answer by David HM Wednesday, March 23, 2011 6:01 AM
    • Unmarked as answer by Mike Walsh FIN Tuesday, May 3, 2011 4:56 PM
    Wednesday, March 16, 2011 7:02 AM
  • I want a situation where when I create an announcement email message will be sent automatically to everyone or  different groups that I have set up

    Currently I have set up outgoing mail service which is working

     

    Thanks


    CRM Manager
    • Marked as answer by flashyjunior Thursday, March 24, 2011 10:58 AM
    • Unmarked as answer by Mike Walsh FIN Tuesday, May 3, 2011 4:56 PM
    Wednesday, March 16, 2011 3:10 PM
  • That should be easy.  Set up alerts on the list.

    Alternatively, a sharpeoint designer workflow would do the trick.

    There's really no reason here to query the database directly.


    --Paul Galvin, BrightStarr
      Microsoft MVP - SharePoint
      Blogging @ http://www.mstechblogs.com/paul
      Twitter @ http://www.twitter.com/pagalvin
    • Marked as answer by David HM Wednesday, March 23, 2011 6:01 AM
    Wednesday, March 16, 2011 11:16 PM