Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 Stored procedures

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2006-01-18 : 08:56:53
dharma writes "How to write stored procedures for generating mail when the perticularlicence expires on perticular date"

Srinika
Master Smack Fu Yak Hacker

1378 Posts

Posted - 2006-01-18 : 09:12:49
Go thru Books ONline & learn the following
1. How to write a simple Stored Procedure
2. How to generate mail (not necessarily thru SP)
3. How to trigger some event, when something happens (like a record entered to a table ...)
4. Think about how r u going to catch the license expiry (I mean at the time of each, u run a program, a date in a table is changing and that has some value in the begining of the installation in a seperate column ....)

There u go
Go to Top of Page

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2006-01-18 : 09:56:36
Also search for mail in this topic
http://sqlteam.com/forums/topic.asp?TOPIC_ID=55210

Madhivanan

Failing to plan is Planning to fail
Go to Top of Page
   

- Advertisement -