Wednesday, April 15, 2009

Software Update Point on a Secondary Site

Software Update Point on a Secondary Site

The client computers assigned to secondary sites will automatically be configured to use the software update point at the parent site until an active software update point site system is configured for the secondary site. Creating an active software update point at the secondary site is recommended when there is limited network bandwidth from client computers to the software update point site system running WSUS or when the number of client computers connecting to the software update point is approaching capacity. Internet-based software update points are not supported on secondary sites.

Note
Generally, if you have decided that a proxy management point is necessary at the secondary site, you might want to consider an active software update point at the site as well.

After the active software update point is successfully installed and configured on the secondary site, the Group Policy is updated on client computers and they will start using the new software update point. For more information about how to install the software update point on a secondary site, see How to Create and Configure an Active Software Update Point on a Secondary Site.


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

Thursday, April 2, 2009

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/