This is a mirror of official site: http://jasper-net.blogspot.com/

SQL SERVER – Check Advanced Server Configuration

| Monday, August 2, 2010
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

Posted via email from .NET Info

0 comments: