SQL Server 2005

Question

Post reply

SQL Server 2005

ginni.sinha

Old Hand

Points: 343
More actions
August 19, 2008 at 12:09 am

#211341

Comments posted to this topic are about the item SQL Server 2005

Viewing 13 posts - 1 through 12 (of 12 total)

You must be logged in to reply to this topic. Login to reply

Kev Riley SSCrazy Eights Points: 9075 More actions · Answer 1

Also in addition to the links provided, here's a link to a more complete list of disabled features

http://msdn.microsoft.com/en-us/library/ms183753(SQL.90).aspx

Kev

WayneS SSC Guru Points: 95460 More actions · Answer 2

The links for Database Mail and SQL Mail are the same.

I thought that Database Mail replaced SQL Mail?

Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes

If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!

Links:
For better assistance in answering your questions
Performance Problems
Common date/time routines
Understanding and Using APPLY Part 1 & Part 2

Kev Riley SSCrazy Eights Points: 9075 More actions · Answer 3

WayneS (8/19/2008)
The links for Database Mail and SQL Mail are the same.

That's true!

I guess these should have been used:

Database Mail: http://msdn.microsoft.com/en-us/library/ms175887(SQL.90).aspx

SQL mail: http://msdn.microsoft.com/en-us/library/ms177418(SQL.90).aspx

WayneS (8/19/2008)
I thought that Database Mail replaced SQL Mail?

Database Mail is the newer, improved, more stable email solution version of SQL Mail, but you can still use SQL Mail if you really must!

Again those links above will tell you more

Kev

Chris Harshman SSC-Forever Points: 42192 More actions · Answer 4

Ugh... yet another typically bad worded question. Technically there's a difference between a feature being disabled and not being setup.

Kev Riley SSCrazy Eights Points: 9075 More actions · Answer 5

Also noticed that these links take you to SQL 2008 pages (I guess the default links always refer to the latest version). You can follow the links at the top right of those pages for SQL2005, or use these modified links: put '(SQL.90)' before the '.aspx'

CLR - http://msdn.microsoft.com/en-us/library/ms345099(SQL.90).aspx

Database Mail - http://msdn.microsoft.com/en-us/library/ms175887(SQL.90).aspx

SQL mail: http://msdn.microsoft.com/en-us/library/ms177418(SQL.90).aspx

Web Assistance - http://msdn.microsoft.com/en-us/library/ms175576(SQL.90).aspx

Kev

Kev Riley SSCrazy Eights Points: 9075 More actions · Answer 6

charshman (8/19/2008)
Ugh... yet another typically bad worded question. Technically there's a difference between a feature being disabled and not being setup.

I guess your issue is with SQL Mail?

Technically yes - but practically, none of these are enabled, so the end result is the same.

In fact MSDN/BOL regards them to be 'disabled' (MS words not mine)....http://msdn.microsoft.com/en-us/library/ms183753(SQL.90).aspx

Kev

SJTerrill SSCrazy Points: 2938 More actions · Answer 7

I guess your issue is with SQL Mail?
Technically yes - but practically, none of these are enabled, so the end result is the same.
In fact MSDN/BOL regards them to be 'disabled' (MS words not mine)....http://msdn.microsoft.com/en-us/library/ms183753(SQL.90).aspx

True. But this article indicates it's not even installed by default: http://msdn.microsoft.com/en-us/library/ms177418(SQL.90).aspx

--SJT--

Doug Elwood-471888 SSC Eights! Points: 953 More actions · Answer 8

You have to consider all platforms, this question does not.

The "correct" answer is not valid.

The official "Security note" from BOL is below:

Security Note:

SQL Mail is not installed by default in SQL Server 2005. For more information, see Surface Area Configuration. SQL Mail is not supported on 64-bit versions of SQL Server. SQL Mail stored procedures cannot be installed on 64-bit versions.

This feature is not just disabled, it isn't present. For those of us that know the difference, it's huge.

Christian Buettner-167247 SSChampion Points: 13729 More actions · Answer 9

I think the QOD is just fine. The default for these features is disabled - whether they are installed or not is a different question. Just my opinion.

Best Regards,

Chris Büttner

Anipaul SSC-Insane Points: 24681 More actions · Answer 10

Anipaul

SSC-Insane

Points: 24681

August 20, 2008 at 12:57 am

#860426

The question is ok in my opinion...:)

Scott Klein-508332 Right there with Babe Points: 752 More actions · Answer 11

This question is worded poorly. It asks for things "disabled" by default. SQL Mail is NOT INSTALLED by default. That is entirely different than disabled.

Ash DBA SSC Enthusiast Points: 170 More actions · Answer 12

This question is worded poorly. Web Assitant should have been Web Assistant stored procedures...:w00t: