I have some customers that can afford nothing but SQL express. So I thought no problem, they won't exceed the filegroup limit anyway.
Scheduling jobs is the only problem. What would you do?
- I could build a simple scheduling agent using the service broker ( but naaah, really?)
- Use Scheduling Tasks and SQLCMD ( embarrassing )
- Pay for, or use a freeware, third party SQL Scheduling Agent ( the easy way )
Many of you ought to have faced this problem before I thought...