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 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 …
SQL Server Error Message 6263 – Enable SQL Server for CLR Support Read MoreIn 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 …
Recursive triggers 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 MoreMany 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 …
T-SQL script to delete files Read MoreQuestion 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 …
SQL Server: What all changes require a restart of SQL Service? Read More