.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
david stephan
Gaurav Pal
Post New Web Links

Alerts for users

Posted By:      Posted Date: October 09, 2010    Points: 0   Category :Sql Server

Hi all I need an box to pop up telling the users its time to renew a pariticpants applications.  I need it to pop up every 3 months, it would be based off.  I wanted to use the and the Referral Date is how I would know its been three months.  Not sure how to code that its on Access 2007 as the Guil but its a SQL Server 2005



CREATE TABLE [dbo].[People_tbl](
	[Parent ID] [nvarchar](50) NOT NULL,
	[Family ID] [nvarchar](50) NULL,
	[StudentID] [nvarchar](50) NULL,
	[ReferralLocation] [nvarchar](50) NULL,
	[RegistrationDate] [nvarchar](50) NULL,
	[FirstName] [nvarchar](50) NULL,
	[LastName] [nvarchar](50) NULL,
	[SS#] [nvarchar](50) NULL,
	[____] [nvarchar](50) NULL,
	[Grade] [nvarchar](50) NULL,
	[Age] [nvarchar](50) NULL,
	[DOB] [nvarchar](50) NULL,
	[EventID] [nvarchar](50) NULL,
	[TANFreferral] [nvarchar](255) NULL,
	[Enrollmentstatus] [nvarchar](255) NULL,
	[EmailAddress] [nvarchar](100) NULL,
	[ScannedDocuments] [nvarchar](50) NULL,
	[ParentRelease] [nvarchar](50) NULL,
	[StudentRelease] [nvarchar](50) NULL,
	[DateReleased] [nvarchar](50) NULL,
	[TribalAfflilation] [nvarchar](50) NULL,
	[StateStudentID] [int] NULL,
	[TanfStaffMakeReferal] [nvarchar](50) NULL,
	[TypeOfParticipant] [nvarchar](50) NULL,
	[RequiredHours] [nvarchar](50) NULL,

View Complete Post

More Related Resource Links

Users not receiving alerts


At some point over the last 2 weeks, the alert functionality in our MOSS 2007 environment stopped working.  Users will receive the "You have setup a new alert" email when configuring a new Alert, but not any actual alerts when an item is added/changed.  I investigated the Timer Service on the front end web server and noticed it was Stopped.  I restarted the Service and some of the users received upwards of 200 backlogged alerts.

I can understand why the user received so many alerts, these would be the alerts that SHOULD have been sent over the last 2 weeks.  I just wanted to make sure that this is normal behavior.  If the service fails, then the alert emails are set to a type of "pending" status until the service is restarted?  Is this accurate or am I misunderstanding something.

E-Mail Alerts for users on Task List


Is there any way to send e-mail alerts to a specific user wihtout assigning them the task or having them subscribe to the list.

It's a Task List on WSS 3 on Win2k3 Enterprise'


Cannot create email alerts for multiple users

Hello, I created an email alert for a document in a library. In the "Send Alerts To" box, I added multiple user names separated by semicolons and saved the alert. However, when I open the alert again, only my user name appears and the additional user names are gone. Why is this happening and how do I fix this problem?  Thank you in advance.

How do I get all the users are set for alerts to a document library using C#.net


Hi All,

I want to get all the users set for alerts to a SharePoint document library using C# code. Please guide me to do this. I would appreciate your help.

For Example: If my site collection having 5 sites. I want to get user names of a document library of one site.



SharePoint 2007 alerts are undeliverable to some users !


We have MOSS 2007 environment, there we have some alerts setup for some users. The problem is that there are some user to whom alerts are undeliverable and we receive failure messege in specified incomming mailbox. Most of these users are repeated. I have checked the profile of these users and found they are imported perfectly in sharepoint and these users are active users.

Thanks in advance

Supriya Ghosh



Alerts sent to users have a broken link when a document name has a space in it

I have setup several alerts on several different lists and libraries in SharePoint 2010. When I receive the alerts by email several of the links are broken due to the name of the document or list item having a space in it. I have found an article on google that fixes this, but it is changing some code, which I'm not good comfortable doing. Does anyone know of an easy fix to this that doesn't involve renaming all the list items and documents? Also, is this a bug in SharePoint or by design? From my reading it seemed that maybe it was to accommodate all browsers, but wasn't real clear on that. Thanks

Setup alerts for multiple users



I am trying to figure out how to manage alerts for users of a Sharepoint site collection...

Essentially, we have a site collection - one main site and many subsites. Each subsite relates to a specific customer account. We have assigned various salespersons access to the sites based on what customer account they are assigned to. We are just using the site visitors group for this. In each one of these (sub)sites, we have 5 document libraries. What I would like to do is find an easy way where I can setup alerts so that if anything changes in any of the document libraries in subsite "A", that all users in the Site Visitors group will receive an alert (and so on for all of the sites). While we can certainly instruct the salespersons to add their own alerts for each of the libraries in each of the sites they have access to, this is perceived as very cumbersome.

Does anyone know of a way to manage (add/change/delete) alerts for users at a site level?

Thanks in advance...


MS SQL Server: Disconnect Users From Database - Kill User Session

If you ever wanted to restore your database from a SQL backup file (.bak), but there are still users connected to your database, the backup operation will fail causing the error: Exclusive access could not be obtained because the database is in use.

Enabling Users to Maintain SharePoint Content

When SharePoint is installed as a corporate intranet, there is a considerable amount of effort involved in maintaining the content to keep the site relevant. As we discussed in the first few parts of this series, SharePoint has many built-in features to reduce the burden on the site administrator.

Some areas of the site usually contain less-dynamic information. Internal memos and corporate policies are common examples of this information. One option for this information is to post these documents in a document library. Documents in a library are often stored in a few different formats: Word, Acrobat (PDF), or HTML. Each of these formats has its drawbacks.

Enabling Users to Maintain SharePoint Content

When SharePoint is installed as a corporate intranet, there is a considerable amount of effort involved in maintaining the content to keep the site relevant. As we discussed in the first few parts of this series, SharePoint has many built-in features to reduce the burden on the site administrator.

Need help redirecting users to personalized page


 Hi, first timer here so be gentle.


I've been able to create a cool little website, it's up and running with users logging in and out, I created roles so my administrative team can see sensitive data that's not available to regular and anonymous users.

Now they would like me to create a page specific to each user.  For instance when user A logs in they are redirected to a page that has information that pertains to user A only (like a list of their benefits/ their remaining vacation time). This page needs to be accessible only to user A. 

I've watched a ton of the videos but have yet to see one that covers this topic, any help would be great!!!





Intranet Users Challenged When Using Windows Integrated Security


We've setup an intranet site using Windows Integrated Security. Its up and running and users can access it. However, they are being challenged with a login dialog for the server when they initially access the site.

Isn't is possible to configure the server so that the users aren't challenged AND are recognized as being already authenticated by Windows? We're trying to go with a seamless experience, whereby all they have to do is login to their machine like normal and then go from there.

Users getting logged out because HttpContext.Current is null


We've  been trying to fix this one for a couple years, and I'm just out of ideas, so any help is really appreciated!

We've got a fairly large, complex web application that uses Forms Authentication to authenticate users.  Throughout the application we store and retrieve information about users in the Session object, and in some cases in cookies.  In a couple places we check for the existence of the context, and if it's null we send the user back to the login page to re-establish the session. 

Just a quick run-down of this web app: C#, .NET 3.5, IIS 6, ASP.NET State Service to manage session

As for the session timer, we use our own home-grown timer, which is basically a client-side timer, which is backed up by a check to the SQL database to see when their last activity was.  This seems to work well for us.  It's not perfect, but it allows us to notify the user before the session times out, and allows us to be certain we're not logging a user out before their 60 minutes of inactivity is up.

What's happening is that certain users are being logged out after just a few minutes.  We've eliminated the timer as a cause and believe what's happening is the HttpContext.Current is null, so the user is logged out.  We do not know why the HttpContext.Current is null, and I underst

Getting users list reporting to manager from LDAP


Dear All,

I need to get list of users reporting to a particular manager from the Active directory.

In the active directory there is manager property with contains the data in the following way.


Please help me in building the filter condition.

I am using the following

pUserName="Gegore Lid";

strSearch = "(&(objectClass=user)(objectCategory=user)((Manager cn=" + pUserName + "))";

DirectorySearcher dSearcher = new DirectorySearcher(dEntry, strSearch);

            //Account properites to load
            string[] arrPropertiesToLoad = { "displayName", "department", "manager", "sAMAccountName", "EmployeeNumber", "Title" };

          SearchResultCollection sResultColl = dSearcher.FindAll();

 the above code is not returning any result.

Please help me in this.



Use Membership but bypass / disable password usage for users


I have an application that does LDAP authentication. The authentication is done on the code behind page of my Login.aspx page. Once the user passes LDAP authentication, a cookie is set and I redirect:

FormsAuthentication.RedirectFromLoginPage(UserName.Text, False)

I would like to setup membership in my application and keep track of some user information. But due to company security requirements, I cannot store user passwords on my application. That must stay on the LDAP server only.

Is there a way to store users but disable password storage on the aspnet_membership table?

Getting list of users reporting from specific Manager from Active Directory


Dear All,

I am have requirement like displaying all the user information reporting to specific manager from Active Directory.

Please help me regarding this.



Changing direction of pop-ups/alerts in RTL


Hello All,

I am not able to change the direction of popups/Alerts in Arabic culture which should be RTL direction.

Rest of my application is changed in above culture, only problem is with popups and alerts.

Thanks in advance.

ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend