This month's discount Comprehensive Database Performance Health Check · Testimonials
SQLAuthority with Pinal Dave
Home
  • Consulting
    • Health Check
  • Free Videos
  • All Articles
    • AI
    • SQL Performance
    • SQL Tips and Tricks
    • Interview Questions and Answers
    • SQL Puzzle
    • SQL Video
    • SQLAuthority News
    • Personal
  • Books
  • Consulting
An old cast iron mincer clamped to a farmhouse kitchen table, a bowl waiting beneath it.

CLR Integration in SQL Server: When It Still Makes Sense

October 6, 2021
Pinal Dave
SQL Tips and Tricks
CLR, SQL Server, SQL Server Configuration, SQL Server Security

Review CLR integration uses, inventory existing assemblies, preserve strict security, and compare SQL Server 2025 built-in alternatives.

Read More
Gouache painting of a worker checking a blocked bridge between two database towers

ISSERVER Assembly Upgrade Error: Cannot Drop the Assembly (Msg 15151 and 6528)

February 22, 2019
Pinal Dave
SQL Tips and Tricks
CLR, SQL Error Messages, SQL Upgrade, SSIS

An ISSERVER assembly error during a SQL Server upgrade needs the surrounding SSISDB messages before you choose a repair. The tests here trigger both errors in a throwaway database, show how they differ and run the catalog checks safely when SSISDB is missing or unreadable.

Read More
SQL Server project new project dialog box.

SQL SERVER – Introduction to CLR – Simple Example of CLR Stored Procedure

October 19, 2008
Pinal Dave
SQL Performance
CLR, Software Development, SQL Scripts, SQL Stored Procedure, SQL Utility

An introduction to CLR in SQL Server 2005 and later, with a simple CLR Stored Procedure built in Visual Studio that prints the current system datetime.

Read More
Diagram of CLR inside SQL Server: a SQL query enters the query processor, which uses the SQL CLR module and the CLR hosting module; SAFE code reaches the database through the engine, EXTERNAL_ACCESS reaches files, registry and network, and UNSAFE reaches native and COM DLLs

SQL Server CLR: The Common Language Runtime Inside the Engine

March 14, 2008
Pinal Dave
SQL Tips and Tricks
CLR, SQL Function, SQL Server, SQL Server Architecture, SQL Stored Procedure

SQL Server CLR means running .NET code, such as C# stored procedures, inside SQL Server. A diagram shows how the pieces fit, and why CLR helps with the cursors and loops that slow down T-SQL.

Read More
CLR Support

SQL SERVER – Fix : Error : Msg 6263, Level 16, State 1, Line 2 Enabling SQL Server 2005 for CLR Support

May 12, 2007
Pinal Dave
SQL Tips and Tricks
CLR, SQL Error Messages, SQL Scripts, SQL Server, SQL Server Configuration

Error:
Fix : Error : Msg 6263, Level 16, State 1, Line 2 Enabling SQL Server 2005 for CLR Support

1) Enable Server for CLR Support.

Read More
SQL SERVER - 2005 Enable CLR using T-SQL script

SQL SERVER – 2005 Enable CLR using T-SQL script

May 5, 2007
Pinal Dave
SQL Tips and Tricks
CLR, SQL Scripts, SQL Server Configuration, SQL Server Security

In SQL Server 2005 the CLR is off by default. Here is the sp_configure script to enable CLR, turning on show advanced options and then clr enabled.

Read More
  • Books
  • Testimonials
  • Privacy Policy

© 2006 – 2026 All rights reserved. pinal @ SQLAuthority.com