Feature Comparison of MSDE and SQL Server 2005 Express

Feature Comparison of MSDE and SQL Server 2005 Express

While the core database capabilities of MSDE and SQL Server 2005 Express are similar, the set of features and database capabilities of MSDE and SQL Server 2005 Express are different. The following table provides a feature comparison between MSDE and SQL Server 2005 Express.

Feature	MSDE	SQL Server 2005 Express Edition
Maximum number of instances	16	16
Maximum # of processors	2	1
Maximum RAM	2 GB	1 GB
Maximum database size	2 GB	4 GB
Workload governor	Yes	No
Graphical management tool	No	Yes
User instances	No	Yes
SQL Agent	Yes	No
DTS runtime	Yes	Yes (Web download)
Replication	Merge only	Merge subscription Snapshot subscription Transactional subscription
BI features (Analysis Services, Integration Services)	No	No
Report Server	No	Yes (Installed with SQL Server 2005 Express with Advanced Services)
Service Broker	No	Client only
Full-text search	No	Yes (Installed with SQL Server 2005 Express with Advanced Services)
Windows 9x support	Yes	No
MDAC Required	Yes	No
Business Intelligence Development Studio (BIDS)	No	Yes (Installed with SQL Server 2005 Express Toolkit)

-------------------
Thanks,
http://sccm07.blogspot.com/

Feature Comparison of MSDE and SQL Server 2005 Express

Feature Comparison of MSDE and SQL Server 2005 Express

While the core database capabilities of MSDE and SQL Server 2005 Express are similar, the set of features and database capabilities of MSDE and SQL Server 2005 Express are different. The following table provides a feature comparison between MSDE and SQL Server 2005 Express.

Feature	MSDE	SQL Server 2005 Express Edition
Maximum number of instances	16	16
Maximum # of processors	2	1
Maximum RAM	2 GB	1 GB
Maximum database size	2 GB	4 GB
Workload governor	Yes	No
Graphical management tool	No	Yes
User instances	No	Yes
SQL Agent	Yes	No
DTS runtime	Yes	Yes (Web download)
Replication	Merge only	Merge subscription Snapshot subscription Transactional subscription
BI features (Analysis Services, Integration Services)	No	No
Report Server	No	Yes (Installed with SQL Server 2005 Express with Advanced Services)
Service Broker	No	Client only
Full-text search	No	Yes (Installed with SQL Server 2005 Express with Advanced Services)
Windows 9x support	Yes	No
MDAC Required	Yes	No
Business Intelligence Development Studio (BIDS)	No	Yes (Installed with SQL Server 2005 Express Toolkit)

-------------------
Thanks,
http://sccm07.blogspot.com/

Systems part of what collections?

SELECT v_R_System.Name0, v_Collection.Name FROM v_FullCollectionMembership INNER JOIN v_R_System ON v_FullCollectionMembership.ResourceID = v_R_System.ResourceID INNER JOIN v_Collection ON v_FullCollectionMembership.CollectionID = v_Collection.CollectionID WHERE (v_R_System.Name0 = 'Systemname')

for Webbased reports:--

Here is the main section:
SELECT v_FullCollectionMembership.Name as 'Computer Name', v_Collection.Name as 'Collection Name'
FROM v_Collection v_Collection, v_FullCollectionMembership v_FullCollectionMembership
WHERE v_FullCollectionMembership.CollectionID = v_Collection.CollectionID AND (v_FullCollectionMembership.Name=@prompt)

Here is the "prompt" section:
begin
 if (@__filterwildcard = '')
  SELECT DISTINCT v_FullCollectionMembership.Name from v_FullCollectionMembership
Order by v_FullCollectionMembership.Name
 else
  SELECT DISTINCT v_FullCollectionMembership.Name from v_FullCollectionMembership
  WHERE v_FullCollectionMembership.Name like @__filterwildcard
  Order by v_FullCollectionMembership.Name
end

-------------------
Thanks,
http://sccm07.blogspot.com/

Systems part of what collections?

SELECT v_R_System.Name0, v_Collection.Name FROM v_FullCollectionMembership INNER JOIN v_R_System ON v_FullCollectionMembership.ResourceID = v_R_System.ResourceID INNER JOIN v_Collection ON v_FullCollectionMembership.CollectionID = v_Collection.CollectionID WHERE (v_R_System.Name0 = 'Systemname')

for Webbased reports:--

Here is the main section:
SELECT v_FullCollectionMembership.Name as 'Computer Name', v_Collection.Name as 'Collection Name'
FROM v_Collection v_Collection, v_FullCollectionMembership v_FullCollectionMembership
WHERE v_FullCollectionMembership.CollectionID = v_Collection.CollectionID AND (v_FullCollectionMembership.Name=@prompt)

Here is the "prompt" section:
begin
 if (@__filterwildcard = '')
  SELECT DISTINCT v_FullCollectionMembership.Name from v_FullCollectionMembership
Order by v_FullCollectionMembership.Name
 else
  SELECT DISTINCT v_FullCollectionMembership.Name from v_FullCollectionMembership
  WHERE v_FullCollectionMembership.Name like @__filterwildcard
  Order by v_FullCollectionMembership.Name
end

-------------------
Thanks,
http://sccm07.blogspot.com/