Important Notice: Our web hosting provider recently started charging us for additional visits, which was unexpected. In response, we're seeking donations. Depending on the situation, we may explore different monetization options for our Community and Expert Contributors. It's crucial to provide more returns for their expertise and offer more Expert Validated Answers or AI Validated Answers. Learn more about our hosting issue here.

Does SQL# (SQLsharp) work with Microsoft SQL Server 2000 (or before)?

April 26, 2017Microsoft SQL Server

0

Posted

Does SQL# (SQLsharp) work with Microsoft SQL Server 2000 (or before)?

1 Answer

0

Posted

Unfortunately, no. SQL Server 2005 is the first version to incorporate the .Net CLR inside the database engine so the previous versions would have no way to make use of .Net code. If you are stuck using SQL Server 2000 (or before) for a while and need to do complicated, procedural logic, the only way is to create a COM DLL and register it as an Extended Stored Procedure (xp). See Books Online (BOL) for more detailed information on creating and registering xp DLLs in SQL Server 2000.