11-20-2017 01:09 AM
I am trying to retrieve the number of archived items pending to be indexed by referring to the following article:
https://www.veritas.com/support/en_US/article.HOWTO59167
However, our directory database is on a different server so I am replacing the following part of query:
INNER JOIN EnterpriseVaultDirectory.dbo.ArchiveView ON ArchiveView.VaultEntryId = SQ.ArchivePointId
Like this:
INNER JOIN Server-name.EnterpriseVaultDirectory.dbo.ArchiveView ON ArchiveView.VaultEntryId = SQ.ArchivePointId
However, because of the hyphen (-), the query doesn't working.
How do I specify the server name with hyphen in the name for this query?
Solved! Go to Solution.
11-20-2017 05:12 AM
Antoine's on the right track with the brackets, but each element in the fully-qualified name should get its own set of brackets. I think this is the format you want:
[Server-name].[EnterpriseVaultDirectory].[dbo].[ArchiveView]
Although only the hyphenated server name requires them in your case, so this should also work:
[Server-name].EnterpriseVaultDirectory.dbo.ArchiveView
--Chris
11-20-2017 01:52 AM
Hi,
HAve you try something like this :
INNER JOIN [Server-name.EnterpriseVaultDirectory.dbo.ArchiveView] ON ArchiveView.VaultEntryId = SQ.ArchivePointId
Antoine
11-20-2017 01:59 AM
Yes, just did.
But query doesnt work:
Msg 208, Level 16, State 1, Line 1
Invalid object name 'server-name.EnterpriseVaultDirectory.dbo.ArchiveView'.
Also tried with single quotes, but no luck.
11-20-2017 05:12 AM
Antoine's on the right track with the brackets, but each element in the fully-qualified name should get its own set of brackets. I think this is the format you want:
[Server-name].[EnterpriseVaultDirectory].[dbo].[ArchiveView]
Although only the hyphenated server name requires them in your case, so this should also work:
[Server-name].EnterpriseVaultDirectory.dbo.ArchiveView
--Chris