Hello,
I have installed SQL Server 2005 Express Edition Advanced Services. I would
like to use Server Agent. I read in a book that I should use Surface Area
Configuration to switch Agent on (is it true?), but I don't know how to do
it. I don't see Agent in Object Explorer of my SQL Server Management Studio
Express.
Please help.
/RAM/

Express doesn't come with Agent. Use some other scheduler (if that is what you are after), like the
one that comes with the OS.

Show quoteHide quote

Tibor already answered your question but these may come in handy if you are
just starting out:

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsse/html/sseoverview.asp
Express Overview
http://msdn2.microsoft.com/en-us/library/ms165672.aspx  Comparing Express
with MSDE
http://msdn.microsoft.com/sql/default.aspx?pull=/library/en-us/dnsse/html/sqlexpuserinst.asp
User Instances
http://www.datamasker.com/SSE2005_NetworkCfg.htm       Configuring Express
for Remote Access
https://blogs.msdn.com/sqlexpress/archive/2005/05/05/415084.aspx
Configuring Remote Access
http://www.kbalertz.com/Feedback_914277.aspx    Configuring SQL2005 for
remote access
http://msdn.microsoft.com/sql/express/default.aspx?pull=/library/en-us/dnsse/html/emsqlexcustapp.asp
Embedding Express in Apps
http://blogs.msdn.com/rogerwolterblog/archive/2006/04/13/575974.aspx
Backing up Express

Automating Database maintenance in SQL 2005 Express Edition Part I
http://www.sqldbatips.com/showarticle.asp?ID=27

Automating Database maintenance in SQL 2005 Express Edition Part II
http://www.sqldbatips.com/showarticle.asp?ID=29

Show quoteHide quote

As far as I'm aware none of the versions of SQL Server 2005 Express
Edition include SQL Agent.

Andrew Watt MVP

Requirement to use Management Studio for local instances
Stored Procedures in Integration Services
Cannot filter members in Management Studio Browsing a Cube
Sql 2005 can't update maintenance plans?
backup remote database to local hard drive or local database?