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 |
|
sushma patle
Starting Member
15 Posts |
 Posted - 2008-06-11 : 02:59:58
|
 using this side i create one procedure for sending mail as it is, only change mail id on excute time , but this is give error that is http://www.sqlteam.com/article/sending-smtp-mail-using-a-stored-procedure Msg 15281, Level 16, State 1, Procedure sp_OACreate, Line 1SQL Server blocked access to procedure 'sys.sp_OACreate' of component 'Ole Automation Procedures' because this component is turned off as part of the security configuration for this server. A system administrator can enable the use of 'Ole Automation Procedures' by using sp_configure. For more information about enabling 'Ole Automation Procedures', see "Surface Area Configuration" in SQL Server Books Online. how i resolve this errorspatle |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2008-06-11 : 03:28:21
|
Do as the error suggests?Open "Surface Area Configuration" application and enable 'Ole Automation Procedures'.
E 12°55'05.25"N 56°04'39.16" |
 |
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2008-06-11 : 03:56:30
|
| note that if you're using sql server 2005 you should use database mail component to send emails._______________________________________________Causing trouble since 1980Blog: http://weblogs.sqlteam.com/mladenpSpeed up SSMS development: www.ssmstoolspack.com <- version 1.0 out! |
|
|
|
|
|
|
Pls solve this error