Missing XML comment for publicly visible type or member

April 17th, 2013

Missing XML comment for publicly visible type or member. This error happend when you treat warning as error.

Links Used:

SQL Server: Adding a linked Server

September 14th, 2012

Adding a Linked Analysis Server Using Transact-SQL

Use the system stored procedure sp_addlinkedserver to add a linked Analysis server using SQL commands.

Syntax

Linking to Microsoft® SQL Server™ 2000 Analysis Services requires more specific syntax than that provided in the SQL Server documentation. Note the required program ID MSOLAP.

sp_addlinkedserver @server = 'server', @srvproduct = 'product_name',
@provider = 'MSOLAP', @datasrc = 'data_source',
@catalog = 'catalog'

Arguments

@server'server'

This is the name of the Analysis server as it is referenced in SQL Server. This name is used to identify the linked server in pass-through queries.

@srvproduct = 'product_name'

The product name of the OLE DB data source to be added as a linked server. Leave the product_name value NULL.

@provider = 'MSOLAP'

The progID of the OLE DB Provider for Analysis Services.

@datasrc = 'data_source'

The network name of the computer hosting Analysis Services.

@catalog = 'catalog'

The name of the Analysis Services database that contains cubes to be queried.

Example

Use the following example to create a linked server reference using SQL Server:

/* Remove any previous references to the linked server */
EXEC sp_dropserver 'LINKED_OLAP'

EXEC sp_addlinkedserver
     @server='LINKED_OLAP',   /* local SQL name given to the 
                                 linked server */
     @srvproduct='',          /* not used */
     @provider='MSOLAP',      /* OLE DB provider */
     @datasrc='OLAPSRV',      /* analysis server name (machine name) */
     @catalog='foodmart'      /* default catalog/database */

/* Two additional procedures obtain information about the
   tables and columns available in the cube. It is not
   necessary to use them to complete the link.*/

/* This provides schema rowset information about
   the dimensions available from the linked server */
EXEC sp_tables_ex
   @table_server='LINKED_OLAP'

/* This provides schema rowset information about the 
   measures and levels of the dimensions 
   available from the linked server */
EXEC sp_columns_ex 
   @table_server='LINKED_OLAP',
   @table_name='Sales'

SQL Server: Registering a Server

September 14th, 2012

In this blog post, I am writing about how to register a new server in SQL Server Management Studio.

The server you need to connect must alreasy be connected.

To register a connected server

  • In Object Explorer, right-click a server to which you already are connected, and then click Register.
  • Server name Enter the name you want to use for the registered server. Registering a local or remote server using SQL Server Management Studio lets you store the server connection information for future connections. This field defaults to the server name entered when you were connecting to the server. You can retain this server name or enter another easy-to-use name for the server.
  • Server description Enter an optional description of the server. The maximum number of characters allowed is 250.
  • Select a server group Select the server group where you want to save the server registration.
  • New Group Click to launch the New Group dialog box, where you can create a new server group for the registered server.
  • Save Click to save the information you have entered and create a registered server.

Links:

ozlu Sozler GereksizGercek Hava Durumu Firma Rehberi Tv de bugun E-okul Veli Firma Rehberi