SQL Query Help
Created: 12 Oct 2012 • Updated: 12 Oct 2012 | 2 comments
This issue has been solved. See solution.
I'm trying to run following where Directory DB in one SQL server and Vault Store DB in another SQL server, how can we run this query in this scenario?
select COUNT(*), SUM(SS.ItemSize)/1024 'size in MB' from saveset SS
inner join ArchivePoint AP on SS.ArchivePointIdentity = AP.Archivepointidentity
inner join EnterpriseVaultDirectory.dbo.ArchiveView EVDAV on AP.ArchivePointId = EVDAV.VaultEntryId
where EVDAV.ArchiveName = 'archive'
and SS.ArchivedDate > '2012-10-11'
and SS.ArchivedDate < '2012-12-08'
Msg 208, Level 16, State 1, Line 1
Invalid object name 'EnterpriseVaultDirectory.dbo.ArchiveView'.