Share via

SSMS- Get error when creating a table in SSMS (SQL Server Manager Studio)

rohini patel 0 Reputation points
2024-04-14T12:47:17.65+00:00

HI,

I get this error when trying to create a table in SQL Server Studio Manager:

TITLE: Microsoft SQL Server Management Studio


Exception has been thrown by the target of an invocation. (SqlEditors)


ADDITIONAL INFORMATION:

Unable to find the requested .Net Framework Data Provider. It may not be installed. (System.Data)


BUTTONS:

OK


Could you please help?

Thanks!

SQL Server | Other
SQL Server | Other

Additional SQL Server features and topics not covered by specific categories

0 comments No comments

2 answers

Sort by: Most helpful
  1. LiHongMSFT-4306 31,621 Reputation points
    2024-04-15T05:53:30.7+00:00

    Hi @rohini patel

    Please check if the .Net framkwork is properly installed and at the appropriate version and patch levels.

    Also, see this similar thread for some hints.

    Best regards,

    Cosmog Hong


    If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

    Was this answer helpful?

    0 comments No comments

  2. Olaf Helper 47,621 Reputation points
    2024-04-15T05:39:58.29+00:00

    I get this error when trying to create a table

    Do you mean by using the GUI in SSMS => Tables => New?

    But plain T-SQL with "CREATE TABLE .." works?

    Was this answer helpful?

    0 comments No comments

Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.