Why i'm getting error for the Microsoft.SqlServer.Server namespace?

Question

I'm writing this code:

string sqlConnectionString = conn1;

//string sqlConnectionString = "Data Source=(local);Initial Catalog=AdventureWorks;Integrated Security=True";
FileInfo file = new FileInfo("d:\\behzadBULK.sql");
string script = file.OpenText().ReadToEnd();

SqlConnection conn = new SqlConnection(sqlConnectionString);
Microsoft.SqlServer.Server server = new Microsoft.SqlServer.Server(new ServerConnection(conn));
server.ConnectionContext.ExecuteNonQuery(script);

but I'm getting an error in this line

Microsoft.SqlServer.Server = ....

I added the Microsoft.SqlServer.Smo reference, but I get this error:

'Microsoft.SqlServer.Server' is a 'namespace' but is used like a 'type'

What happen? Thanks.

My error:

enter image description here

@Jamel hi ,why i get error in the Microsoft.SqlServer.Server server = new Microsoft.SqlServer.Server(new ServerConnection(conn)); line? — behzad razzaqi
– behzad razzaqi, Commented Jul 4, 2015 at 5:33
Because you are using a namespace as a class and making an object of it. — Jam
– Jam, Commented Jul 4, 2015 at 5:35

Jam · Accepted Answer · 2015-07-04 05:43:50Z

4

Change your namespace from Microsoft.SqlServer.Smo to Microsoft.SqlServer.Management.Smo

answered Jul 4, 2015 at 5:43

Jam

3381 gold badge7 silver badges27 bronze badges

Sign up to request clarification or add additional context in comments.

7 Comments

behzad razzaqi Over a year ago

Hi jamal,but i can not found the Microsoft.SqlServer.Management.Smo

Jam Over a year ago

Your sql have the library Microsoft.SqlServer.SmoExtended.dll. Search that and add it to your project.

Jam Over a year ago

Mostly its in C:\Program Files\Microsoft SQL Server\100\SDK\Assemblies. Tell me when you found it!

behzad razzaqi Over a year ago

i found that and add the reference but so get error!

behzad razzaqi Over a year ago

But i use the Microsoft.SqlServer.SmoExtended.dll

|

SenthilPrabhu · Accepted Answer · 2018-01-10 10:44:22Z

2

While using visual studio 2017 & above solutions did not work for me.

Simply I recreated a new project as SQL Server Database Project
and choose SQL CLR C# User Defined Function type
Automatically the namespace got added without any issues.

Previously i tried all nuget packages which did not work for me.

answered Jan 10, 2018 at 10:44

SenthilPrabhu

6676 silver badges30 bronze badges

Comments

Hemal · Accepted Answer · 2015-07-04 05:38:35Z

0

You are initializing a namespace, not a class, that's why error occurred.

Use a class from Microsoft.SqlServer.Server namespace

answered Jul 4, 2015 at 5:38

Hemal

3,7722 gold badges27 silver badges57 bronze badges

Collectives™ on Stack Overflow

Why i'm getting error for the Microsoft.SqlServer.Server namespace?

3 Answers 3

7 Comments

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

7 Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related