sp_configure [configname[,configvalue]] : sp_configure « System Functions « SQL Server / T-SQL Tutorial






  1. SQL Server / T-SQL Tutorial
  2. System Functions
  3. sp_configure
Running this procedure with no parameters provides you with the current configuration. 
 
sp_configure "user connections",300 
GO








25.27.sp_configure
25.27.1.Limiting Trigger Nesting
25.27.2.Changing SQL Server Configurations
25.27.3.sp_configure [configname[,configvalue]]
25.27.4.EXEC sp_configure 'allow updates', 1