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

> 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.

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 s.

Dan Guzman
SQL Server MVP

"Om" <bubu.prakash@gmail.com> wrote in message
news:220fc714-9eda-4424-ab59-43b23237b2e6@i12g2000prf.googlegroups.com...
> 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