PrepAway - Latest Free Exam Questions & Answers

Which command should you use?

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?

PrepAway - Latest Free Exam Questions & Answers

A.
DBCC SHOW_STATISTICS [<Company Name>$< Table Name>]

B.
sp_helpindex [<Company Name>S< Table Name>]

C.
sp_helpindex ([<Company Name>$< Table Name>],[$<Key Number>])

D.
DBCC SHOW_STATISTICS ([<Company Name>$< Table Name>],[$<Key Number>])


Leave a Reply