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 |
|
ratheeshknair
Posting Yak Master
129 Posts |
 Posted - 2007-10-31 : 06:45:23
|
| Hi all, We are planning to create a new application which is used to send email to more that 5million users.My question is that waht will be effect on database when such a large transaction occurs.Thanks In AdvanceRKNAIR |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2007-10-31 : 11:33:20
|
| How is this an urgent question? Is production down as a result?Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/ |
 |
|
|
ratheeshknair
Posting Yak Master
129 Posts |
Posted - 2007-10-31 : 13:17:15
|
| No but its so urgent as we have to give our suggestion today itself....RKNAIR |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2007-10-31 : 13:27:48
|
| We don't have enough information to assist you with your problem.Please be respectful of these forums in that we answer questions for free. If something is due today, you should have better planned out your time so that this "problem" was not urgent.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/ |
|
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2007-10-31 : 13:49:43
|
| Depends how it is implemented.Which database do you mean, how do you access it, what info to you get and update, how are the emails sent.==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
|
|
|
|
|
|
urgent