|
|
|
|
||||||
![]() |
|
|
LinkBack | Outils de la discussion |
|
|
#1 |
|
Messages: n/a
Hébergeur: |
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 |
|
|
|
#2 |
|
Messages: n/a
Hébergeur: |
> 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 |
|
![]() |
| Outils de la discussion | |
|
|