Use sp_configure to display or change server-level settings. To change the database-level settings, use ALTER DATABASE. To change settings that affect only the current user session, use the SET statement.
e.g.
sp_CONFIGURE
'show advanced'
,
0
GO
RECONFIGURE
GO
sp_CONFIGURE
GO
You can run the following command and check the advanced global configuration settings.
sp_CONFIGURE
'show advanced'
,
1
GO
RECONFIGURE
GO
sp_CONFIGURE
GO
Share This Post
No comments:
Write comments