You need to get the list of indexes for a Microsoft Dynamics NAV table from the Microsoft SQL Server Management Studio. Which command should you use?

The correct answer is B. sp_helpindex [<Company Name>S< Table Name>]. Use the SQL Server command sp_helpindex to get information about the index ID associated with indexes on a given table. The following example looks for index information about the Item Ledger Entry table. sp_helpindex 'CRONUS International Ltd_$Item Ledger Entry'

Understand the Dynamics 365 for Talent Environment

Question

Options

ADBCC SHOW_STATISTICS [<Company Name>$< Table Name>]
Bsp_helpindex [<Company Name>S< Table Name>]
Csp_helpindex ([<Company Name>$< Table Name>],[$<Key Number>])
DDBCC SHOW_STATISTICS ([<Company Name>$< Table Name>],[$<Key Number>])

How the community answered

(53 responses)

A
13% (7)
B
75% (40)
C
8% (4)
D
4% (2)

Explanation

Use the SQL Server command sp_helpindex to get information about the index ID associated with indexes on a given table. The following example looks for index information about the Item Ledger Entry table. sp_helpindex 'CRONUS International Ltd_$Item Ledger Entry'

Topics

#sp_helpindex#SQL Server Management Studio#NAV indexes#database commands

Community Discussion

No community discussion yet for this question.

Full MB7-702 Practice