Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
revelator
Starting Member
32 Posts |
 Posted - 2009-01-14 : 06:29:37
|
| Does anyone know if there is a way to constrain SQL Server Developer Edition (2005 or 2008) to only allow use of features that are in the Standard Edition? This is the Edition on a clients server and we want to make sure that no-one makes use of any Enterprise-only features.-----------------------------------Waiting for the Great Leap Forwards |
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2009-01-14 : 09:33:06
|
| there's no method to do this other than checking the docs what is in dev edition that is not in standard and not using those features.however, note the differences are mainly for admins. i don't think that there are any T-SQL or other featuress for SQL developers that in dev edition are not in standard edition.___________________________________________________________________________Causing trouble since 1980Blog: http://weblogs.sqlteam.com/mladenpSpeed up SSMS development: www.ssmstoolspack.com <- version 1.1 out! |
 |
|
|
revelator
Starting Member
32 Posts |
Posted - 2009-01-14 : 11:20:42
|
| Thanks, I thought that might be the case.The kind of features I was thinking were mainly around SSIS (fuzzy lookups/grouping) and SSRS (data driven subscriptions). Possibly online indexing too.-----------------------------------Waiting for the Great Leap Forwards |
|
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2009-01-14 : 11:30:02
|
Do partitioned table count?
E 12°55'05.63"N 56°04'39.26" |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2009-01-14 : 12:08:28
|
quote:
Originally posted by revelator
Thanks, I thought that might be the case.The kind of features I was thinking were mainly around SSIS (fuzzy lookups/grouping) and SSRS (data driven subscriptions). Possibly online indexing too.-----------------------------------Waiting for the Great Leap Forwards
if you want to avoid people using integration services and reporting services you can disable them from configuration manager |
|
|
|
|
|
|
Developer Edition - use only Standard Features