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 MoreTag: sp_configure
SQL Server Error Message 6263 – Enable SQL Server for CLR Support
The SQL Server Error Message 6263 occurs when you try to execute a CLR/.Net procedure and it is disabled. The complete error message somewhat looks like as below Msg 6263, Level …
Read MoreRecursive triggers in SQL Server
In this blog we’ll look at Recursive triggers in SQL Server. Triggers are said to be recursive/nested when a trigger on a table calls another trigger on same or different table …
Read MoreGet SQL Server configuration information
The 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 MoreT-SQL script to delete files
Many a times need arises to access/modify windows folder structures from SQL server. Though SQL Server is not meant for this purpose, however here is a T-SQL script to delete files …
Read MoreSQL Server: What all changes require a restart of SQL Service?
Question of the day: What all changes require a restart of SQL Service? Let’s say you get a request to change a SQL Server setting and you don’t know whether it …
Read More