Microsoft
MB3-700 · Question #77
You configure database options to resolve connectivity issues with the database. Which two settings should be set to False? (Each correct answer presents a complete solution. Choose two.)
The correct answer is A. Auto Shrink B. Auto Close. Step 1: Verify that the SQL database options AutoClose and AutoShrink are set to FALSE. Copy the following script to the New Query 1 window: ALTER DATABASE DYNAMICS SET AUTO_SHRINK OFF, AUTO_CLOSE OFF Step 2: Verify that the ODBC System DSN data source connection on each…
Configure Microsoft Dynamics GP 2013
Question
You configure database options to resolve connectivity issues with the database. Which two settings should be set to False? (Each correct answer presents a complete solution. Choose two.)
Options
- AAuto Shrink
- BAuto Close
- CAuto Create Statistics
- DAuto Update Statistics
How the community answered
(21 responses)- A86% (18)
- C10% (2)
- D5% (1)
Explanation
- Step 1: Verify that the SQL database options AutoClose and AutoShrink are set to FALSE. Copy the following script to the New Query 1 window: ALTER DATABASE DYNAMICS SET AUTO_SHRINK OFF, AUTO_CLOSE OFF * Step 2: Verify that the ODBC System DSN data source connection on each computer tests successfully for connectivity with the SQL Server holding the Dynamics GP or the Great Plains
Topics
#database options#Auto Shrink#Auto Close#SQL Server settings
Community Discussion
No community discussion yet for this question.