Wednesday, March 7, 2012

Please post setup and installation questions in the Setup forum

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.

No comments:

Post a Comment