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 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 …
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 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 …
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 …
Read More