SQL Server Education (by the geeks, for the geeks)
The Common language runtime (CLR) feature allows you to write stored procedures/trigger/functions in .NET managed code and execute the same from SQL Server. However, in order to enable the execution of …
Enable CLR in SQL Server Read MoreThe sys.configurations view can be used to get SQL Server configuration information. Let’s analyze the output of sys.configurations view. As shown in above snapshot, the sys.configuration view lists down different server …
Get SQL Server configuration information Read More