0

I have installed SQL Server 2008 R2 Express on my local system. But it does not show Database Mail option under the Management folder. Also once I have tried to start SQL Server Agent from Administrative Tools > Services > Sql Server Agent (SQLEXPRESS). It shows message like some process are not use so SQL Server Agent stop.

Is there any other way to start SQL Server Agent?

I have tried to start Database Mail using XPs option, but it was not work.

Thanks,

Uttam Patel

marc_s
  • 732,580
  • 175
  • 1,330
  • 1,459
Uttam Kasundara
  • 237
  • 3
  • 13
  • 2
    ["Database Mail is not available in SQL Server Express."](http://technet.microsoft.com/en-us/library/ms175887%28v=sql.105%29.aspx) – Martin Smith Dec 20 '14 at 17:36
  • 1
    And SQL Server **Express** also doesn't support SQL Server Agent - see e.g. [this other SO question on the topic](http://stackoverflow.com/questions/7201061/how-to-create-jobs-in-sql-server-express-edition) – marc_s Dec 20 '14 at 17:58

1 Answers1

2

Database Mail is only available in Enterprise Edition, not in Sql Server Express Edition.

Suvradip Roy
  • 21
  • 2