<P> Reports can be designed using recent versions of Microsoft Visual Studio (Visual Studio.NET 2003, 2005, and 2008) with Business Intelligence Development Studio, installed or with the included Report Builder . Once created, RDL files can be rendered in a variety of formats, including Excel, PDF, CSV, XML, BMP, EMF, GIF, JPEG, PNG, and TIFF, and HTML Web Archive . </P> <P> Originally introduced as a post-release add - on for SQL Server 2000, Notification Services was bundled as part of the Microsoft SQL Server platform for the first and only time with SQL Server 2005 . SQL Server Notification Services is a mechanism for generating data - driven notifications, which are sent to Notification Services subscribers . A subscriber registers for a specific event or transaction (which is registered on the database server as a trigger); when the event occurs, Notification Services can use one of three methods to send a message to the subscriber informing about the occurrence of the event . These methods include SMTP, SOAP, or by writing to a file in the filesystem . Notification Services was discontinued by Microsoft with the release of SQL Server 2008 in August 2008, and is no longer an officially supported component of the SQL Server database platform . </P> <P> SQL Server Integration Services (SSIS) provides ETL capabilities for SQL Server for data import, data integration and data warehousing needs . Integration Services includes GUI tools to build workflows such as extracting data from various sources, querying data, transforming data--including aggregation, de-duplication, de - / normalization and merging of data--and then exporting the transformed data into destination databases or files . </P> <P> SQL Server Full Text Search service is a specialized indexing and querying service for unstructured text stored in SQL Server databases . The full text search index can be created on any column with character based text data . It allows for words to be searched for in the text columns . While it can be performed with the SQL LIKE operator, using SQL Server Full Text Search service can be more efficient . Full allows for inexact matching of the source string, indicated by a Rank value which can range from 0 to 1000--a higher rank means a more accurate match . It also allows linguistic matching ("inflectional search"), i.e., linguistic variants of a word (such as a verb in a different tense) will also be a match for a given word (but with a lower rank than an exact match). Proximity searches are also supported, i.e., if the words searched for do not occur in the sequence they are specified in the query but are near each other, they are also considered a match . T - SQL exposes special operators that can be used to access the FTS capabilities . </P>

Ms sql server 2008 enterprise edition free download