We are getting this error Could not load file or assembly 'Microsoft.SqlServer.BatchParser, Version=15.100.0.0 and we need the SMO package for SQL 2019

Question

We are getting this error Could not load file or assembly 'Microsoft.SqlServer.BatchParser, Version=15.100.0.0 and we need the SMO package for SQL 2019

Rashmi Mahesh 11

We Downloaded ‘Microsoft.SqlServer.SqlManagementObjects’ with version 150.18208.0 from nuget package manager.

Used following dlls:
Microsoft.SqlServer.BatchParserClient.dll
Microsoft.SqlServer.ConnectionInfo.dll
Microsoft.SqlServer.Management.Sdk.Sfc.dll
Microsoft.SqlServer.Smo.dll
Microsoft.SqlServer.SqlClrProvider.dll
Microsoft.SqlServer.SqlEnum.dll

Getting below exception:
Could not load file or assembly 'Microsoft.SqlServer.BatchParser, Version=15.100.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91' or one of its dependencies. An attempt was made to load a program with an incorrect format.

Please give us the SMO package for SQL 2019

Seeya Xi-MSFT 16,586 Reputation points

2022-04-01T08:48:26.127+00:00

Hi @Rashmi Mahesh ,

We have not received a response from you. Did the reply could help you? If the response helped, do "Accept Answer". If it doesn't work, please let us know the progress. By doing so, it will benefit all community members who are having this similar issue. Your contribution is highly appreciated.

Best regards,
Seeya
Zarate, Martin 10 Reputation points

2023-03-02T00:44:46.3266667+00:00

I just hit the same bug. I'd like to use SQL 2019 SMO package since that's the version of SQL our server runs, but it looks like I'll have to switch to a newer SMO for a newer SQL server and hope it works.
Zarate, Martin 10 Reputation points

2023-03-03T22:30:07.81+00:00

Following up on this further, moving to a newer version of SMO means migrating to Microsoft.Data.SqlClient, which is not practical for my team at this time.

1 answer

Your answer

Seeya Xi-MSFT 16,586 Reputation points

2022-04-01T08:48:26.127+00:00

Hi @Rashmi Mahesh ,

We have not received a response from you. Did the reply could help you? If the response helped, do "Accept Answer". If it doesn't work, please let us know the progress. By doing so, it will benefit all community members who are having this similar issue. Your contribution is highly appreciated.

Best regards,
Seeya
Zarate, Martin 10 Reputation points

2023-03-02T00:44:46.3266667+00:00

I just hit the same bug. I'd like to use SQL 2019 SMO package since that's the version of SQL our server runs, but it looks like I'll have to switch to a newer SMO for a newer SQL server and hope it works.
Zarate, Martin 10 Reputation points

2023-03-03T22:30:07.81+00:00

Following up on this further, moving to a newer version of SMO means migrating to Microsoft.Data.SqlClient, which is not practical for my team at this time.

Answer 1

Hi @Rashmi Mahesh ,

Welcome to Microsoft Q&A!
Please read this ducument: https://learn.microsoft.com/en-us/sql/relational-databases/server-management-objects-smo/getting-started-in-smo?view=sql-server-ver15

Best regards,
Seeya

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".
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Share via

We are getting this error Could not load file or assembly 'Microsoft.SqlServer.BatchParser, Version=15.100.0.0 and we need the SMO package for SQL 2019

1 answer

Your answer