Archive for December, 2007
Is SQL Mail and Database Mail supported in sql server 2005 express?
by chintan prajapati on Dec.05, 2007, under Sql Server 2005
Answer is No.
Few days before I was trying to send database mail via sql server 2005 Express with SP2.BUt it didn’t Work.
as Procedure [dbo].[sp_send_dbmail] requires a Parameter @profile_name which is of datatype sysname .
@profile_name sysname = NULL,
@profile_name can be found in table sysmail_profile( select * from sysmail_profile)
but Procedure is not accepting default ProfileName ‘DBMailProfile’
and After a little bit of google i found below article.
http://msdn2.microsoft.com/en-us/library/ms165636.aspx
which clearly says that
SQL Server 2005 Features Not Supported in SQL Server Express
The following table lists the additional SQL Server 2005 database features that are not supported in this version of SQL Server Express. It also lists database features from previous versions of SQL Server that are not supported.
| SQL Server 2005 features not supported in SQL Server Express | SQL Server features from previous versions not supported in SQL Server Express |
|---|---|
| Database mirroring | SQL Mail |
| Online restore | Fail-over clustering |
| Database snapshot | Distributed partitioned views |
| Parallel index operations | VIA protocol support |
| Mirrored media sets | Log shipping |
| Partitioning | Parallel DBCC |
| Address Windowing Extensions (AWE) | Parallel Create Index |
| Hot-add memory | Enhanced Read Ahead and Scan |
| Native HTTP SOAP access | Indexed views (materialized views) |
| SQL Mail and Database Mail | Partitioned views |
| Online Index Operations | |
| SQL Server Agent and SQL Server Agent Service |
Thanks.
