SQL Server 2005

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Article Discussions » Article Discussions by Author » Discuss content posted by ginni.ashok » SQL Server 2005

13 posts, Page 1 of 2

1 2 »»

SQL Server 2005

Rate Topic

Display Mode

Topic Options

Author

Message

ginni.sinha

Posted Tuesday, August 19, 2008 12:09 AM

SSC 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

kevriley

Posted Tuesday, August 19, 2008 2:00 AM

SSCrazy

Group: General Forum Members
Last Login: Monday, May 13, 2013 12:01 PM
Points: 2,677, Visits: 2,273

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

WayneS

Posted Tuesday, August 19, 2008 6:06 AM

SSCertifiable

Group: General Forum Members
Last Login: Yesterday @ 9:12 AM
Points: 6,370, Visits: 8,235

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

kevriley

Posted Tuesday, August 19, 2008 6:26 AM

SSCrazy

Group: General Forum Members
Last Login: Monday, May 13, 2013 12:01 PM
Points: 2,677, Visits: 2,273

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

Chris Harshman

Posted Tuesday, August 19, 2008 7:06 AM

SSCommitted

Group: General Forum Members
Last Login: Yesterday @ 12:03 PM
Points: 1,564, Visits: 1,718

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

Post #554975

kevriley

Posted Tuesday, August 19, 2008 7:15 AM

SSCrazy

Group: General Forum Members
Last Login: Monday, May 13, 2013 12:01 PM
Points: 2,677, Visits: 2,273

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

kevriley

Posted Tuesday, August 19, 2008 7:25 AM

SSCrazy

Group: General Forum Members
Last Login: Monday, May 13, 2013 12:01 PM
Points: 2,677, Visits: 2,273

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

SJTerrill

Posted Tuesday, August 19, 2008 9:22 AM

SSC-Addicted

Group: General Forum Members
Last Login: Thursday, June 28, 2012 12:28 PM
Points: 458, Visits: 718

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

Doug Elwood-471888

Posted Tuesday, August 19, 2008 2:23 PM

SSC-Addicted

Group: General Forum Members
Last Login: Saturday, May 11, 2013 12:52 PM
Points: 415, Visits: 108

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

Christian Buettner-167247

Posted Tuesday, August 19, 2008 7:06 PM

SSCrazy

Group: General Forum Members
Last Login: Yesterday @ 6:12 AM
Points: 2,526, Visits: 3,620

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 »

13 posts, Page 1 of 2

1 2 »»

Permissions