not ab le o find sql mail section under manag

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.

All Forums

General SQL Server Forums

New to SQL Server Administration

not ab le o find sql mail section under manag

Author

Topic

kirank
Yak Posting Veteran

58 Posts

Posted - 2011-05-16 : 14:24:07

hi,

i m using sql 2008 i want to send database mail to everyone.

i want to configure sql 2008 management (mail) section

but it is not available under the management section not it shows

Management
- sql server log
- Legacy

but nt able to find sql mail. where i can get that i have sql 2008
os - window 7 home basic and sql details

Microsoft SQL Server Management Studio 10.0.1600.22 ((SQL_PreRelease).080709-1414 )
Microsoft Data Access Components (MDAC) 6.1.7600.16385 (win7_rtm.090713-1255)
Microsoft MSXML 3.0 5.0 6.0
Microsoft Internet Explorer 8.0.7600.16385
Microsoft .NET Framework 2.0.50727.4927
Operating System 6.1.7600

http://webdevlopementhelp.blogspot.com

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2011-05-16 : 14:27:25

What does SELECT @@VERSION show?

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog

nigelrivett
Master Smack Fu Yak Hacker

3385 Posts

Posted - 2011-05-16 : 14:27:25

Are you an administrator?
There seems to be a lot missing there.

Was it installed?

That shows what your client is not the server.

==========================================
Cursors are useful if you don't know sql.
SSIS can be used in a similar way.
Beer is not cold and it isn't fizzy.

kirank
Yak Posting Veteran

58 Posts

Posted - 2011-05-16 : 14:34:03

Microsoft SQL Server 2005 - 9.00.3042.00 (Intel X86) Feb 9 2007 22:47:07 Copyright (c) 1988-2005 Microsoft Corporation Express Edition on Windows NT 6.1 (Build 7600: )
SELECT @@VERSION ---

i m also login with sa

http://webdevlopementhelp.blogspot.com

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2011-05-16 : 14:49:03

You are using Express edition: http://www.google.com/search?rlz=1C1GPMD_enUS313US313&sourceid=chrome&ie=UTF-8&q=sql+express+database+mail

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog

kirank
Yak Posting Veteran

58 Posts

Posted - 2011-05-17 : 02:10:03

here they are saying SQL server 2005 express edition don't support this feature
wht i can do in this case . plz help

http://webdevlopementhelp.blogspot.com

kirank
Yak Posting Veteran

58 Posts

Posted - 2011-05-17 : 10:43:00

any idea?

http://webdevlopementhelp.blogspot.com

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2011-05-17 : 11:28:01

The solution is to use a different email program and not Database Mail.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog

kirank
Yak Posting Veteran

58 Posts

Posted - 2011-05-17 : 11:32:22

can u plz suggest me which sort of" different email program "

any idea?

http://webdevlopementhelp.blogspot.com