Take the 2-minute tour ×

The following "SQL Server 2008 R2" page about "User Instances for Non-Administrators" has a note at the top that reads:



What is the future of this feature? Will it be dropped entirely? Replaced by a different feature? Is SQL Server Compact edition meant to fill this space?

Bump. Nobody? Does anyone use the User Instance feature?

share|improve this question
add comment

1 Answer

up vote 6 down vote accepted

This feature is deprecated in favor of SQL Server Compact 3.5: http://msdn.microsoft.com/en-us/library/ms143729.aspx

A few explanations on the reasoning from a Microsoft person: http://social.msdn.microsoft.com/Forums/en-US/sqlexpress/thread/6764e959-4a32-49e3-ae84-61471d6a105a

share|improve this answer
Thanks. I appreciate the links. I figured it was dropped in favor of CE but was unable to find an authoritative statement to that affect from Microsoft. –  Parched Squid Mar 13 '11 at 15:39
LocalDB in SQL Server Denail replaces "user instances", not SQL Server Compact –  ErikEJ Sep 22 '11 at 10:51
Why downvote? The question was about SQL Server 2008 R2, not Denali. –  CyberDude Sep 23 '11 at 5:35
add comment

Your Answer


