Enable CLR in SQL Server
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 …
Read MoreSQL 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 …
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 …
Read More