I am in the proces of moving my client over onto a dedicated web server solution. We have developed an ASP.Net aplication which currently connects to a SQL Server 2000 standard edition database.
The database is mainly used just for data storage and receiving data updates via DTS packages from another SQL Server database hosted externally from elsewhere. An my ASP.Net application queries the data via stored procedures.
As part of the Dedicated solution I am looking to purchase their own copy of SQL Server (processor license) too.
Based on the information above, would SQL 2005 Workgroup edition sound appropriate rather than standard?... i'm thinking of the cost.
Is there anything I would need to consider regarding Workgroup edition within a hosting environment?
I see that Workgroup is a little more cost effective so I am tempted to go for that edition.