Hi All,

Can anyone explain me, why we have Resource and Distribution System
Database in SQL Server 2005. Whether they were also available in
previous versions also.

Thanks in Advance.

Regards,
Om

The Resource database (mssqlsystemresource) was introduced in SQL 2005. The
mssqlsystemresource is a read-only database that contains system objects
that were stored in master in previous versions. It is modified only during
service packs and upgrades.

The Distribution database is created when a server is configured as a
distributor for replication. This database is available in previous
versions.


--
Hope this helps.

Dan Guzman
SQL Server MVP

"Om" <bubu.prakash (AT) gmail (DOT) com> wrote