I was recently asked following question:
“How I check all the advanced configuration of the SQL Server?”
EXEC sp_configure 'Show Advanced Options', 1;
GO
RECONFIGURE;
GO
EXEC sp_configure;
Running above script will return all the advanced server configurations.
Read more: Journey to SQL Authority with Pinal Dave
“How I check all the advanced configuration of the SQL Server?”
EXEC sp_configure 'Show Advanced Options', 1;
GO
RECONFIGURE;
GO
EXEC sp_configure;
Running above script will return all the advanced server configurations.
Read more: Journey to SQL Authority with Pinal Dave