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 - 2000-11-05 : 13:48:51
|
andy writes "When you use xp_sendmail, one of the parameter is @set_user. This parameter let you set up the security environment in which you execute your sent query.
I had a problem with that. When I try to execute a sql query with set user set to one of the user, i got error message back said that there are no such user or group. But from the output of sp_helpuser i do see my user name in that database. if I re-execute the xp_sendmail with dbo as user, there is no problem.
can any one help me?
andy"
|
|
|
|
|
|
xp_sendmail