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 - 2003-05-20 : 08:24:13
|
| Rakesh writes "Hi,I have SQL 2000 installed with 6 Databases.I want to configure one SQL Mail profile for 4 Databases.and another SQL Mail profile for the remaining 2 Databases.Can the SQL Mail profile be tied at the Database level.This is necessary as,based on the mail profile I will be processing the mails.ThanksRakesh" |
|
|
efelito
Constraint Violating Yak Guru
478 Posts |
Posted - 2003-05-20 : 11:40:40
|
| This is not possible. The only way I can think of to get something like this working is to Install a second instance of SQL Server and move 2 of the databases to it. That way you'd have two sets of SQL Server Services on which you could create seperate accounts and mail profiles for.Jeff Banschbach, MCDBA |
 |
|
|
chadmat
The Chadinator
1974 Posts |
Posted - 2003-05-20 : 12:32:39
|
| You could do all of the SQLMail manually for each database. xp_startmail allows you to specify the profile you want to use. You could start and stop mail with the appropriate profile depending on the database. I'm not sure this is a good idea, but you could try it.-Chadhttp://www.clrsoft.comSoftware built for the Common Language Runtime. |
|
|
|
|
|
|
Configure SQL Mail Profile for each Database