Jun 12
If you have been using SQL Server 2005 express you will no doubt have noticed the lack of any backup options in SQL Web Studio Express or an SQLAgent, which is a big issue as you should be keeping backups of your databases.
Thankfully there is a solution using the expressmaint utility and windows scheduled tasks, and I found this handy article on how to use this solution to overcome this limitation of SQL Server 2005 express.
Now I just need to find a solution for the lack of import/export facilities, which I think is a major exclusion from the Web Studio Express and really limits its usefulness.
Jun 12, 2008 at 2:50 PM Russ,
If you need the import/export capabilities, install the "Microsoft SQL Server 2005 Express Edition Toolkit SP2". It's also a free download from Microsoft listed on the same page where you download 2005 express.
Once that it's installed, you can look at the comparable location on your machine for the following file: C:\Program Files\Microsoft SQL Server\90\DTS\Binn\DTSWizard.exe
I believe it's part of the "Business Intelligence Development Studio" so you should be able to install just that part to get it. Otherwise, install the whole thing and it should give you the feature.
Aug 21, 2012 at 4:02 AM If purchasing a new sestym, take a look at the latest version (no point in starting out on an operating sestym that will end of life sooner than the other). Also keep in mind that you'll need to purchase Terminal Server Client Access Licenses (CAL)for each sestym connecting to the server.$999 Windows Server 2008 Standard$749 Windows Server 2008, TS Client Access License 5-pack (you'll need 2 of these if you go this option)$2,979 Windows Server 2008, TS Client Access License 20-pack (only 1 of these if you go this option)I'm not sure if this includes the software so you can remotely connect or just a license to connect so you may have an additional fee for the Mac portion of the Terminal client software.As an alternative, take a look at running Apple Parallels if you need to run Windows applications on the Macs. Not sure of pricing, but the above seems pretty steep.** Edit **Bishop While it is true that you can connect to Terminal Server without additional licenses, this is only for 2 licenses for Administrative Access. To access with more than 2 users, you'll need to enable the licensing option and install the license packs.