April 8, 2011 at 12:07 pm
HI,
We had sql server 2000 last year and now some time back changed to sql 2005..
We have a procedure whcih runs and sends email :-
EXEC msdb.dbo.sp_send_dbmail
@recipients = ' Person's name'
....
So we used to receive email earlier when sql 2000 was in use... as it connected the person's name to the email address from microsoft outlook
Now in sql 2005, we arent been able to receive the email....
If i write whole address in--
@ recipients = 'xyz@abcd.com'
Then iam able to receive the mail but not when I just mention then name ...
IS there a compatiblity issue with sql 2005 and outlook??
I dont know wats wrong...
Regards,
Sushant
Regards
Sushant Kumar
MCTS,MCP
April 8, 2011 at 12:17 pm
The two versions function differently. SQL 2005 no longer requires Outlook be installed so is not plugged into the address book like 2000 was. In 2005, just enter the entire email address and you will be fine.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
April 8, 2011 at 12:58 pm
CirquedeSQLeil (4/8/2011)
The two versions function differently. SQL 2005 no longer requires Outlook be installed so is not plugged into the address book like 2000 was. In 2005, just enter the entire email address and you will be fine.
So is it possible to link database mail to use the outlook?
Regards,
Sushant
Regards
Sushant Kumar
MCTS,MCP
April 8, 2011 at 1:33 pm
well you could continue to use xp_sendmail but SQL 2005 and Outlook 2003 don't play nicely. Also, that means installing application software on the server - which isn't an optimal solution.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
April 8, 2011 at 1:44 pm
CirquedeSQLeil (4/8/2011)
well you could continue to use xp_sendmail but SQL 2005 and Outlook 2003 don't play nicely. Also, that means installing application software on the server - which isn't an optimal solution.
I am using sql 2005 and outlook 2007...
btw
But I am confused about 1 thing..
If i send like -->
@recipients = 'xyz@abcd.com'
I receive the mail in outlook but in the TO section it says 'X Y Z',
why doesn't it say TO:- 'xyz@abcd.com'
That means it comes through outlook right?
Why isnt it opposite then..??
just wondering..
Regards,
Sushant
Regards
Sushant Kumar
MCTS,MCP
April 8, 2011 at 1:50 pm
No it means that the email reached your exchange server and you opened the email in your Outlook. In your Outlook it translates the fully qualified name (in the TO field) to a recognized contact in your address book - as you are viewing the received email.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply