Yesterday, one of my teammate was facing an issue while enabling a server level parameter using T-SQL command sp_configure. He was trying to enable extended procedure xp_cmdshell using sp_configure command but he received error 15123. Full description of error is given below....
Have you ever thought how SQL Server controls the size of packets which are send over the network. There is a server configuration option network packet size in SQL Server. The value of this configuration are used to control the...
Today, I got a requirement to limit the number of concurrent user connections on a SQL Server Instance. SQL Server provides an option user connections in server level configurations to set or limit the maximum number of simultaneous user connections...
