Go SQL Server functions explained by some common DLLs

Transferred from: Leo_wlcnblogs

SQL Server functions explained by some common DLLs

If your SQL Server is installed in the C drive, the following path is the storage path of the corresponding SQL Server version of the common DLL

SQL2005

C:\Program Files\Microsoft SQL Server\90\sdk\assemblies\

SQL2008

C:\Program Files\Microsoft SQL Server\100\sdk\assemblies\

SQL2012

C:\Program Files\Microsoft SQL Server\110\sdk\assemblies\

You can see that as the SQL Server version is upgraded, these public DLLs are getting more and more, because SQL Server functions more and more.

What is the use of these DLLs??

These DLLs are intended for SQL Server, because these public DLLs are useful in many of the SQL Server components, so SQL Server puts these

DLL put to X: \program Files\Microsoft SQL Server\x\sdk\assemblies\ folder for other SQL Server components to invoke

For example, SSIS, SSAS, Database engine, and other tools

In fact, from the folder path name we can know the role of these DLLs:sdk\assemblies\

We do not know the meaning of the SDK can Baidu a bit, but maybe everyone is more dependent, I will put it out

The SDK (software Development Kit, or software development kit) is typically used by software engineers for specific packages, software frameworks, hardware platforms, operating systems, etc.

A collection of development tools to build the application software.

Senior programmers must know the role of the SDK, he is a software provided to us programmers to develop some of the interface or API

I think X: \program Files\Microsoft SQL Server\x\sdk\assemblies\ folder These DLLs are not just provided to SQL Server calls

We can also call these DLLs to develop some related software and tools for SQL Server database

Example one:

In the garden, the contacts Warrior uses the following two DLLs to make: (blood sharing) use. NET Generate database table creation script, similar to SQL Server writing table's create statement

Microsoft.SqlServer.ConnectionInfo.dll

Microsoft.SqlServer.Management.Sdk.Sfc.dll

Example two:

Another example of this post: in C # do a, sqlServer2005 inside that event monitor the same program, start the problem please help to see

Use the Microsoft.SqlServer.ConnectionInfo.dll DLL as a tool similar to SQL Trace to see the executed scripts and other information in real time

Example three:

Sqldoc Sharp (SQL Server database document generation tool)

This tool can be downloaded on CodeProject:http://www.codeproject.com/Articles/35790/SQLDoc-Sharp

The following DLL is used

Microsoft.SqlServer.ConnectionInfo.dll

Microsoft.SqlServer.Management.Sdk.Sfc.dll

Microsoft.SqlServer.Smo.dll

Microsoft.SqlServer.SmoExtended.dll

Microsoft.SqlServer.SqlEnum.dll

What languages are common DLLs written in?

We can see that the tools in the three examples above are used. NET-written tools, including Sqldoc Sharp are Winfrom software written in. Net

We use Ilspy this software to decompile each SQL Server version of the next DLL

Drag all DLLs into the Ilspy.

SQL2005

SQL2008

SQL2012

SQL2008 There are two DLLs are not able to decompile, respectively, are redist_tsqllanguageservice.dll and Redist_dacframework.dll

SQL2012 inside only one DLL is not able to decompile, is redist_tsqllanguageservice.dll

DLLs that cannot be deserialized are probably written in C or C + +

I estimate that these DLLs that cannot be deserialized will not provide the API functionality to the user, only to SQL Server, and these DLLs are critical to the performance of SQL Server

So write in C or C + +

From the above to decompile these DLLs, SQL Server has a large part of the components or code is written in. Net.

In addition to some key features or performance-related functional components written in C or C + +

Here, from the other side, you can see that Microsoft is right. NET, from SQLSERVER2005 began to use. NET to write a number of component code

It can be seen from the above three examples why they are preferred. NET to write these tools, because these common DLLs are inherently. NET DLLs (managed code)

Simple Introduction to DLLs

Limited to my ability is limited, I will simply introduce more familiar DLLs, other unfamiliar you can check MSDN or Baidu

I will give some DLL information and check Baidu, MSDN results

I only introduce SQLSERVER2012, because SQLSERVER2012 is quite complete, but some features will change in different SQL Server versions.

For example, in the second example above: in C # do a, sqlServer2005 inside that event monitor the same program, boot problems please help to see

It says TMO. This class changes in the SQL2005 version of the SDK and the SQL2008 version of the SDK, resulting in a run-time error

Using trace Management object to monitor and diagnose SQL Server (i)

In SQL Server 2005, the TMO object is implemented in the Microsoft.SqlServer.ConnectionInfo.dll,

In SQL Server 2008, the TMO object is moved to the Microsoft.SqlServer.ConnectionInfoExtended.dll,

But still in the Microsoft.SqlServer.Management.Trace namespace.

Similar to the above changes in the API I will not say, we develop the time must be clear MSDN and Baidu, do not make mistake, because these SDK documents relatively few

Most of them are e-text, and they're more likely to develop headaches.

Don't talk nonsense, start ~

Microsoft.AnalysisServices.DLL

Microsoft.DataWarehouse.Interfaces.DLL

SSAS, Data Warehouse-related interfaces

Kpi class: Http://technet.microsoft.com/zh-cn/library/microsoft.analysisservices.kpi.aspx

http://technet.microsoft.com/zh-cn/magazine/ Microsoft.datawarehouse.interfaces.idesignertoolwindowservice.gettoolwindow.aspx

Microsoft.ExceptionMessageBox.DLL

This DLL is called by various exception dialogs in SQL Server

Http://technet.microsoft.com/zh-cn/library/microsoft.sqlserver.messagebox.exceptionmessagebox.showcheckbox.aspx

http://social.msdn.microsoft.com/Forums/sqlserver/en-US/138794c0-228f-4d8e-91d8-6ffb704f828c/ Microsoftexceptionmessageboxdll?forum=sqltools

Microsoft.ReportingServices.Interfaces.DLL

Related interfaces for SSRS

Http://support.microsoft.com/kb/873267/zh-cn

Microsoft.SqlServer.Smo.DLL

Microsoft.SqlServer.SmoExtended.DLL

Microsoft.SqlServer.Management.Sdk.Sfc.DLL

Microsoft.SqlServer.ConnectionInfo.DLL

Microsoft.SqlServer.ConnectionInfoExtended.DLL

Smo:sqlserver managing Objects

Monitor SQL Server or connect to SQL Server for

Provides the SMO object functionality, which is the abbreviation for SQL Server Management ojbects, a management object provided by SQL2005

As long as SQL Server Management Studio can implement something, it can be implemented with SMO, because SQL Server Management Studio is developed with SMO.

If you have enough power, you can develop a tool that defies SQL Server Management Studio, such as the ability to add IntelliSense

To support the management of SQL Server, Integration Services provides an enumerator over the objects that can traverse the SQL Management Object (SMO).

For example, a package can use the SMO enumerator to perform the same management function for each job in a jobs collection in a SQL Server installation.

Http://support.microsoft.com/kb/956026/zh-cn

Http://support.microsoft.com/kb/922214/zh-cn

Http://blogs.msdn.com/b/sqlcrd/archive/2009/01/14/trace-management-object-sql-server.aspx

Http://msdn.microsoft.com/en-us/library/microsoft.sqlserver.management.smo.aspx

Microsoft.SqlServer.Dts.Design.DLL

Microsoft.SqlServer.DTSPipelineWrap.DLL

Microsoft.SQLServer.DTSRuntimeWrap.DLL

Microsoft.SQLServer.ManagedDTS.DLL

Data Transformation Services (DTS) data transfer service-related DLLs

http://bbs.csdn.net/topics/200087190

http://social.msdn.microsoft.com/Forums/sqlserver/zh-CN/916a39c4-c35a-4ba1-8f7a-dde4aadb1675/ Assembilies-microsoftsqlserverdtspipelinewrap?forum=sqlintegrationservices

http://social.msdn.microsoft.com/Forums/zh-CN/10a94835-8913-40c6-82f5-1d4da37da730/ Microsoftsqlservermanageddtsdll-not-working?forum=sqlintegrationservices

Microsoft.SqlServer.Management.RegisteredServers.DLL

DLL required to register the server

http://connect.microsoft.com/SQLServer/feedback/details/369377/ Microsoft-sqlserver-management-registeredservers-dll-missing

http://social.msdn.microsoft.com/Forums/sqlserver/zh-CN/7fa941bd-68d3-4ae2-9673-8ab4f7cb2602/ Microsoftsqlservermanagementregisteredserversdll?forum=sqlsmoanddmo

Microsoft.SqlServer.Management.Utility.DLL

Microsoft.SqlServer.Management.UtilityEnum.DLL

Utility: Utility class represents a control point (UCP)-defined SQL Server to manage the methods and properties of one or more remote SQL instance instances

utilityenum: The Microsoft.sqlserver.management.utility namespace contains classes that represent SQL Server utility objects

http://msdn.microsoft.com/zh-cn/library/ee242093 (v=sql.110). aspx

Http://technet.microsoft.com/zh-cn/magazine/microsoft.sqlserver.management.utility (sql.105). aspx

Microsoft.SqlServer.Management.XEvent.DLL

Microsoft.SqlServer.Management.XEventEnum.DLL

Extended event-related DLLs

XEvent: Creating and Using SQL Server extended events in SQL Server client components and servers-side components through the common object model

Extended event Infrastructure supports dependency of SQL Server event data

In some cases, the infrastructure can also be used to get relevant data from the data viewing applications and operating systems
Http://msdn.microsoft.com/zh-cn/library/microsoft.sqlserver.management.xevent.aspx

Microsoft.SqlServer.OlapEnum.DLL

OLAP system-related DLLs

Microsoft.SqlServer.Rmo.DLL

Microsoft.SqlServer.Replication.DLL

Replication-related DLLs

RMO: Replication Management Objects

http://social.msdn.microsoft.com/Forums/sqlserver/zh-CN/fd02b8ad-db40-4785-993f-1adfd00d5a0e/ Sql-server-2008-r2-replication-management-objects-sqlrmomsi-?forum=sqlreplication

http://social.msdn.microsoft.com/Forums/sqlserver/en-US/07a89afe-50ba-4133-bfa5-e5f9a7a03bcb/ Rmo-replication-between-sql-server-2005-amd-sql-server-2005-express?forum=sqlreplication

IIS exception thrown by Microsoft.SqlServer.Replication.dll

http://social.msdn.microsoft.com/Forums/zh-CN/ff657b77-8a6e-4602-9903-9c4fca11e3b5/ Microsoftsqlserverreplicationdll-not-found?forum=sqlreplication

Microsoft.SqlServer.ServiceBrokerEnum.DLL

Servicebroker DLLs for related technologies

Http://msdn.microsoft.com/en-us/library/microsoft.sqlserver.management.smo.broker.servicebroker.aspx

Microsoft.SqlServer.SqlWmiManagement.DLL

Microsoft.SqlServer.WmiEnum.DLL

DLLs related to WMI (Windows Management Instrumentation,Windows Management Instrumentation )

http://support.microsoft.com/kb/967199

Open the SQL Server Configuration Manager prompt: Unable to connect to the WMI provider. You do not have permission or the server cannot access it.

Note that you can only use SQL Server Configuration Manager to manage SQL Server 2005 servers.

How to add WMI alert in SQL Server

Microsoft.SqlServer.SString.DLL

SecureString This class has a lot of string-related C # functions

http://social.msdn.microsoft.com/Forums/sqlserver/zh-CN/22131a3d-f63b-42dc-a211-fdef785886ae/ Sql-server-2008-management-studio-error-when-connecting-to-server-method-not-found-int32

The code inside this class

Class: Sqlsecurestring

View Code

Microsoft.SqlServer.Types.DLL

Handling DLLs related to SQL Server data types

The Microsoft.SqlServer.Types namespace contains classes that handle hierarchies and special data types, such as geometry and geographic data types

Ask how to apply Microsoft.SqlServer.Types namespaces

Microsoft.SqlServer.Types namespaces

Summarize

There are many management objects in SQL Server, such as SMO, RMO, TMO

Tmo:trace Tracking Management Objects

You can invoke the APIs provided by these management objects during development to develop the corresponding database functions.

Unfortunately, I haven't found out how many of these management objects are in SQL Server

The features of each object, no detailed documentation, and little information on the web

Related articles:

In C # do a, sqlServer2005 inside that event monitor the same program, start the problem please help to see

Dedicated connection DAC for SQL Server database administrator

SQLSERVER2005 installation directory structure (bottom)

Add:

You can see some of SQL Server's functional component DLLs under X:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Binn Path

Some are not very important functional components such as Database Mail (DatabaseMailengine.DLL) are written using. Net

And some important functional components such as batch interpreter (BATCHPARSER90. DLL) is written in a non-. NET language, so the components you use Ilspy are not compiled

In fact, we are free to study these DLLs

such as Dbghelp. DLL This DLL should be used to generate a dump file memory dump file and cannot be deserialized

Have time to study the SQL Server code written in. NET you'll reap the rewards.

If there is a wrong place, welcome everyone to shoot brick O (∩_∩) o

Go SQL Server functions explained by some common DLLs