September 14, 2016 at 7:07 am
I received the following instructions to display the Database Configuration Settings.
I'm not clear with respect to the step by step actions that need to be taken.
Could someone please provide additional details and/or clarify the actions that need to be taken?
"Provide database configuration settings. This can be generated by performing the following steps:
STEP 1: From the [START] menu open SQL Server Management Studio and click on [New Query] and select the [Results to File] icon or from the command line (click on [START] - [RUN] - type CMD in the ‘Open:’ text box) type sqlcmd -o 'filename' to launch the SQL Query utility outputting the results to the filename entered.
STEP 2: Run the following query from within the SQL query window:
sp_configure"
Thank you.
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
September 14, 2016 at 7:14 am
Shouldn't a Path for the file name be specified?
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
September 14, 2016 at 7:25 am
The instructions look clear enough? What's the problem?
A path is only needed if you want the file written somewhere other than the directory you run the command from (by default your Users folder). But you can follow the first option's steps and then you don't have to worry about a path.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply