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.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2005-09-14 : 06:58:33
|
| Saroj Kumar writes "In Sql server 2000 database, I've a table tbAddress and in that table I've a field E-mail contains e-mails of clients. I want that, WHEN I LOGIN AT A PARTICULAR TIME 10.30am(Say) and start my SQL Server, E-mail should be automatically fetched from the database. In frontend, I've the function to send e-mail to the client, but the problem is how can I fetch that E-mail field at aparticular time interval. Plz do send me ASAP.Thank you." |
|
|
ryanston
Microsoft SQL Server Product Team
89 Posts |
Posted - 2005-09-14 : 12:03:10
|
quote:
Originally posted by AskSQLTeam
Saroj Kumar writes "In Sql server 2000 database, I've a table tbAddress and in that table I've a field E-mail contains e-mails of clients. I want that, WHEN I LOGIN AT A PARTICULAR TIME 10.30am(Say) and start my SQL Server, E-mail should be automatically fetched from the database. In frontend, I've the function to send e-mail to the client, but the problem is how can I fetch that E-mail field at aparticular time interval. Plz do send me ASAP.Thank you."
You could use an auto startup procedure to do this if you want it to be when the server starts up; if you want it at particular time intervals, use a SQL Agent job. But, why do this on the server; this strikes me as a client-side responsibility...Thanks,----------------------Ryan StonecipherDeveloper, Microsoft SQL Server Storage Engine, DBCC(Legalese: This posting is provided "AS IS" with no warranties, and confers no rights.) |
 |
|
|
|
|
|
|
|
Regarding Replication