<div>
run this command and check sp_configure again<br />
<br />
sp_configure 'show advanced option',1<br />
reconfigure<br />
<br />
sp_configure
</div>


run this command and check sp_configure again

sp_configure 'show advanced option',1
reconfigure

sp_configure

<div>
if you want to run full command at a time rather than two separate than use this<br />
<br />
<br />
sp_configure 'show advanced option',1<br />
reconfigure<br />
go<br />
sp_configure<br />
<br />

</div>


if you want to run full command at a time rather than two separate than use this


sp_configure 'show advanced option',1
reconfigure
go
sp_configure



<div>
Hi,<br />
Its working now :) I have no idea why last time it didn't work at all, after several hours then when I executed same command it worked as intended.
</div>


Hi,
Its working now :) I have no idea why last time it didn't work at all, after several hours then when I executed same command it worked as intended.

<div>
Maybe you were logged into MSSQL and you thought you were logged into Sybase.<br />

</div>


Maybe you were logged into MSSQL and you thought you were logged into Sybase.


<div>
<div class="content wysiwyg-content">
Hi,<br />
When I execute sp_configure, it only return me few below as per screenshot, where is the others? which I saw many configuration from sybase central tool. what I can do in order to run sp_configure only to display me disk io or any related group?
</div>
</div>


Hi,
When I execute sp_configure, it only return me few below as per screenshot, where is the others? which I saw many configuration from sybase central tool. what I can do in order to run sp_configure only to display me disk io or any related group?

Sybase sp_configure

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.

Microsoft SQL Server

Sybase, a subsidiary of SAP, builds a client/server relational database management system. Products include Adaptive Server Enterprise (ASE), Adaptive Server Anywhere (ASA), Sybase Unwired Platform (SUP) for mobile applications, Afaria for enterprise mobile device management and IQ for data warehouse and big data applications.