Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase 12»»

SQL Server 2005 Expand / Collapse
Author
Message
Posted Tuesday, August 19, 2008 12:09 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Thursday, February 21, 2013 2:41 AM
Points: 271, Visits: 97
Comments posted to this topic are about the item SQL Server 2005
Post #554756
Posted Tuesday, August 19, 2008 2:00 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Thursday, September 18, 2014 7:56 AM
Points: 2,716, Visits: 2,458
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
Post #554796
Posted Tuesday, August 19, 2008 6:06 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Yesterday @ 8:59 PM
Points: 5,357, Visits: 8,912
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
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, How to ask a question, Performance Problems, Common date/time routines,
CROSS-TABS and PIVOT tables Part 1 & Part 2, Using APPLY Part 1 & Part 2, Splitting Delimited Strings
Post #554925
Posted Tuesday, August 19, 2008 6:26 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Thursday, September 18, 2014 7:56 AM
Points: 2,716, Visits: 2,458
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
Post #554942
Posted Tuesday, August 19, 2008 7:06 AM


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: 2 days ago @ 2:13 PM
Points: 1,889, Visits: 2,036
Ugh... yet another typically bad worded question. Technically there's a difference between a feature being disabled and not being setup.
Post #554975
Posted Tuesday, August 19, 2008 7:15 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Thursday, September 18, 2014 7:56 AM
Points: 2,716, Visits: 2,458
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



Post #554987
Posted Tuesday, August 19, 2008 7:25 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Thursday, September 18, 2014 7:56 AM
Points: 2,716, Visits: 2,458
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
Post #554997
Posted Tuesday, August 19, 2008 9:22 AM


SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Wednesday, March 5, 2014 10:14 AM
Points: 477, Visits: 727
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--



Post #555102
Posted Tuesday, August 19, 2008 2:23 PM
SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Thursday, September 18, 2014 10:16 AM
Points: 416, Visits: 112
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.
Post #555345
Posted Tuesday, August 19, 2008 7:06 PM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Wednesday, September 17, 2014 1:05 AM
Points: 2,842, Visits: 3,875
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
Post #555435
« Prev Topic | Next Topic »

Add to briefcase 12»»

Permissions Expand / Collapse