Empty Result Set with show "Actual Execution Plan" = on but with off I get rows

• Gerhard P.

  Right there with Babe

  Points: 756

  More actions

  August 11, 2021 at 11:12 am

  #3918730

  Hello everybody,

  I have a CLR table vlaued function, which recursively determines the "linked" databases using the sys.synonyms and sys.sql_expression_dependencies.

  If I select the function in SSMS with "Show Actual Execution Plan" switched on, I get an empty result set. If I set it to OFF I get rows. Both same statement!

  Does anyone know a reason that would explain this behavior? Is there a special setting needed in the CLR to avoid this behavior or is it maybe a bug in SQL-Server?

  SQL-Server 2019 (RTM-CU8-GDR) (KB4583459) - 15.0.4083.2 (X64)

  thanks in advance, and

  greetings from Tyrol

  • This topic was modified 3 years, 4 months ago by  Gerhard P.. Reason: add Server Version; alter title

  Gerhard P.Advanced BI DeveloperAustria

• Site Owners

  SSC Guru

  Points: 80325

  More actions

  August 12, 2021 at 12:10 pm

  #3919211

  Thanks for posting your issue and hopefully someone will answer soon.

  This is an automated bump to increase visibility of your question.

• kaj

  SSCommitted

  Points: 1607

  More actions

  August 12, 2021 at 8:55 pm

  #3919403

  Could theoretically also be caused by a bug in SSMS. Are you using the latest version, i.e. 18.9.2?

• Gerhard P.

  Right there with Babe

  Points: 756

  More actions

  August 20, 2021 at 4:12 pm

  #3922191

  Back from vacation - therefore answered so late.

  Yes, the latest SSMS.

  I thought(hope) maybe there is a constallation in .Net c#, which provokes something like that

  Gerhard P.Advanced BI DeveloperAustria