what/how do install to my VS 2023 so that I have Microsoft.SQLServer.Management available

Question

hi all,

I am trying to write a method that launches an Agent job from an asp.net page, I need:

using Microsoft.SqlServer.Management.Common;
using Microsoft.SqlServer.Management.Smo;
using Microsoft.SqlServer.Management.Smo.Agent;

I tried Project-> Add Reference, but found nothing when Searching for Microsoft.SqlServer.Management.

Any idea what I need to install and where do I get it?

Thanks,
elsvieta

Answer 1

write a method that launches an Agent job

Easier way is with a SQL command + plain SQL with sp_start_job (Transact-SQL)

Answer 2

Try to use the “Manage NuGet Packages...” command for your project, go to Browse tab, find and install the Microsoft.SqlServer.SqlManagementObjects package.

Answer 3

Hi @elsvieta,

Beginning with SQL Server 2017 SMO is distributed as the Microsoft.SqlServer.SqlManagementObjects NuGet package to allow users to develop applications with SMO.

Installing SMO

Creating a Visual C# SMO project in Visual Studio.NET

Best regards,
Lan Huang

---

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.