Earlier versions of SQL had an icon in the system tray - which was very useful. I cannot seem to find how you activate this in 2005.
Also you could schedule a job MSDE 2000 to, say, backup a database. I can't find how you do this in SQL Express.
The system tray feature is no longer a component of SQL Server, Express contains no scheduler, please use the windows task scheduler to call sqlcmd instead.|||While SQL 2005 no longer provides a system tray icon for the previous Server Manager applet, here is a link to a .NET application created as a replacement. (Usual craveats implied...)
SQL Server 2005 Service Manager Alternative
http://www.sqldbatips.com/showarticle.asp?ID=46
Also, SQL 2005 Express does not include the SQL Agent Job Scheduling service. You can verify at this version comparision:
SQL Server 2005 Features, Version Comparison
http://www.microsoft.com/sql/prodinfo/features/compare-features.mspx
However, you could combine the use of Windows Scheduler and SQLCmd.exe to create a replacement and similar functionality with SQL 2005 Express.
