Which Database table holds all announcements,calenders and email alerts
Hi,
I wouls like to know which table holds all announcements,calenders and email alerts
ThanksCRM Manager
March 15th, 2011 12:16pm
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
Free Windows Admin Tool Kit Click here and download it now
March 15th, 2011 4:39pm
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
March 16th, 2011 3:03am
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
ThanksCRM Manager
Free Windows Admin Tool Kit Click here and download it now
March 16th, 2011 11:11am
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
March 16th, 2011 7:16pm