SQL Server Books Online

Switch on low bandwidth view

Community Content

In this section

Statistics Annotations (644)

Click here to expand

Collapse All

Other versions are also available for the following:

SQL Server 2005

SQL Server Books Online

Welcome to Microsoft SQL Server Books Online. This set of documentation helps you understand SQL Server, and how to implement data management and business intelligence projects. SQL Server includes several data management and analysis technologies. To learn more about these technologies, click the following links.

Categories

Database Engine The Database Engine is the core service for storing, processing and securing data. The Database Engine provides controlled access and rapid transaction processing to meet the requirements of the most demanding data consuming applications within your enterprise. The Database Engine also provides rich support for sustaining high availability.

Analysis Services - Multidimensional Data Analysis Services supports OLAP by allowing you to design, create, and manage multidimensional structures that contain data aggregated from other data sources, such as relational databases.

Analysis Services - Data Mining Analysis Services enables you to design, create, and visualize data mining models. These mining models can be constructed from other data sources by using a wide variety of industry-standard data mining algorithms.

Integration Services Integration Services is a platform for building high performance data integration solutions, including packages that provide extract, transform, and load (ETL) processing for data warehousing.

Replication Replication is a set of technologies for copying and distributing data and database objects from one database to another, and then synchronizing between databases to maintain consistency. By using replication, you can distribute data to different locations and to remote or mobile users by means of local and wide area networks, dial-up connections, wireless connections, and the Internet.

Reporting Services Reporting Services delivers enterprise, Web-enabled reporting functionality so you can create reports that draw content from a variety of data sources, publish reports in various formats, and centrally manage security and subscriptions.

SQL Server Service Broker Service Broker helps developers build scalable, secure database applications. This new Database Engine technology provides a message-based communication platform that enables independent application components to perform as a functioning whole. Service Broker includes infrastructure for asynchronous programming that can be used for applications within a single database or a single instance, and also for distributed applications.

General Information

Additional Information

Tags

: 2008 (x) bol (x) contents (x) Add a tag

Community Content

Add new content

Annotations

How to stop sql monitor from monitoring a sql 2005 database Publication which is offline

dutto | Edit | Show History

We had to take the db offline, we can put it back on line as it was corrupt, now the sql monitor is still reporting on the publication for replication although there is no reference to the publication except in the distributor, about three tables which list it, hense sql monitor thinks its still there. We have put the db back online, but replication is not referenced anywhere other than in sql monitor

Does anyone know a way to remove this from the distributor, so that the sql monitor stops throwing up the error message

Its baffling me

Regards

Paul