SQL Server Performance

Analysis Services in SQL Server 2008

Discussion in 'SQL Server 2008 General DBA Questions' started by max_yogesh2002, Jul 27, 2010.

  1. max_yogesh2002 New Member

    I want to retrive the Current running value of the Following Analysis Service using SQL Query.
    1.Ad Hoc data mining
    2.Anonymous connection
    3.Linked Objects
    4/User Defined Functions
    Please help me
    Thank You.
  2. satya Moderator

    Welcome to the forums.
    Using AMO you can get information and Books OnLine has got such details to get you what you want. Such as what BOL referred here:
    In SQL Server 2008, many of the existing OLE DB data mining schema rowsets are exposed as a set of system tables that you can query by using Data Mining Extensions (DMX) statements. By creating queries against the data mining schema rowset, you can identify the services that are available, get updates on the status of your models and structures, and find out details about the model content or parameters.

Share This Page