How can we help you today? How can we help you today?

SQL Prompt 10.4.2 in SSMS 18.6 error with "Find Invalid Object", "Smart Rename" and "Split Table"

Find Invalid Object: fizzes the screen and then after fews seconds SSMS closes

Smart Rename and Split Table: blocking error -> The file or assembly 'Microsoft.Data.SqlClient, Version = 2.0.20168.4, Culture = neutral, PublicKeyToken = 23ec7fc2d6eaa4a5' or one of its dependencies could not be loaded. Cannot find the specified file.

matpez
0

Comments

7 comments

  • Andrea_Angella
    Thank you for reporting the issue and sorry for the inconvenience. We'll fix this asap. Thanks
    Andrea_Angella
    0
  • matpez
    Hi, do you have any timing for fix it?
    matpez
    0
  • matpez
    Hi, I just updated to "SQL Prompt 10.4.3"

    I make these considerations:
    • Smart Rename: no longer has the assembly not found error. However, it has another problem: when you press the "view" key which should open a new screen with the query, the "new query" is tried to open with the connection in "Windows Authentication" mode. Since I use the "SQL Authentication" mode it is very inconvenient and previously worked correctly!

    • Split Table: here too the assembly error is gone. Too bad there is the same connection problem written above. The screen on opening reports an error saying that it cannot connect with my windows user. Being a blocking error, I can only close the screen.

    • Find Invalid Object: unfortunately it still remains unusable. The screen does not locate the database and does not even have an entry in the drop-down list. So it can't be used.
    -----------------------------------------------------------------------------------------------------------------------

    I am attaching images



    -----------------------------------------------------------------------------------------------------------------------


    matpez
    0
  • ostandage
    Hi @matpez

    Thank you for your feedback and screenshots. We are currently working on this fixing these issues (unfortunately not ready for releasing this week).

    We can't guarantee a time frame, but we aim to fix this early next week.

    Thanks, 

    Owen
    ostandage
    0
  • Tianjiao_Li
    Thanks @matpez

    The development team is working on those issues and I'll make sure to update here once the fixes are done.

    Our apologies for the inconvenience it's causing.
    Tianjiao_Li
    0
  • AdrianB
    This issue has now been fixed. The fix is available in SQL Prompt v10.4.4.
    AdrianB
    0
  • matpez
    Thanks a lot... all fixed!!  :)
    matpez
    0

Add comment

Please sign in to leave a comment.