Unloading an Extended Stored Procedure

• Steve Jones - SSC Editor

  SSC Guru

  Points: 738337

  More actions

  September 22, 2021 at 12:00 am

  #3927263

  Comments posted to this topic are about the item Unloading an Extended Stored Procedure

• Solomon Rutzky

  SSCoach

  Points: 16430

  More actions

  September 23, 2021 at 3:24 am

  #3932042

  Hi Steve. Good question. Looking at the linked documentation, it seems that there is a slight syntax correction needed in your explanation of the answer. The "FREE" should be in parenthesis, not the DLL name, as in:

   

  DBCC <dllname> ( FREE ) [ WITH NO_INFOMSGS ]

  Example from the doc:

  DBCC xp_sample (FREE);

   

  I would suggest changing the answer option from "DBCC FREE" to "DBCC <dllname> (FREE)".

   

  Take care,

  Solomon..

   

  • This reply was modified 3 years, 9 months ago by Solomon Rutzky.

  SQL# — https://SQLsharp.com/ ( SQLCLR library ofover 340 Functions and Procedures)
  Sql Quantum Lift — https://SqlQuantumLift.com/ ( company )
  Sql Quantum Leap — https://SqlQuantumLeap.com/ ( blog )
  Info sites — Collations     •     Module Signing     •     SQLCLR

• Steve Jones - SSC Editor

  SSC Guru

  Points: 738337

  More actions

  September 23, 2021 at 2:18 pm

  #3932235

  Thanks, I've updated the question.