Currently I have an SQL stored proc that calls a web service to retrieve data for a report. To pull the data takes a long time. Is there a way in SQL that I can schedule the proc to return all the information and put it into a table every 10 minutes? Then I could just report off that table...
That totally makes sense, but this isn’t something you can do in WSS 2.0. That version doesn’t support Email updates, distribution lists, or user groups from AD. First is you need to upgrade to WSS 3.0 or 2010 foundation.
I know you said you don’t have the funds for exchange server but...
If you give me more about what your trying to do I can be more helpful. But with the limited info of what you want as an end result I would say;
If these several hundred contacts are in your system as AD users they can be imported into SharePoint via SSP. At that point you can setup groups...
Sorry, I meant public groups like an AD security group. Any AD security group can be imported by SharePoint. If you create a distribution group those are not available.
Didnt know you could Dispose the xmltxtreader, the ctx.Undo runs the dispose in sharepoint. When i did that to the xmltxtreader it seems to work. Thank you very much!
You can run 2.0 and WSS 3.0 on server 2003. Both versions are free.
They both do support distribution lists, but you must make them pub available for sharepoint to see them.
My function requires an iis reset every 15-20 requests.
I created this CLR class to pull data from my web service. Every 15-20 times it run it requires an IIS reset. Am I missing a dispose someplace? See code below
public class SharePointCalendar
{
[SqlFunction(SystemDataAccess...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.