Answered by:
Which Database table holds all announcements,calenders and email alerts

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
-
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 -
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
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