Way to find registered classes/functions for the Assemblies added in Analysis Service.

SQL Server Analysis Services

Index ‹ SQL Server

- Previous
  - 1
    - User Defined Function Help Needed Sample Query: select * from umr . dbo . medicalclaimlineitem where paiddate <=dbo. CURRENT_DATE Result: Msg 156, Level 15, State 1, Line 1 Incorrect syntax near the keyword 'CURRENT_DATE'. Tag: Way to find registered classes/functions for the Assemblies added in Analysis Service.
  - 2
    - Locking table DBT wrote: select 1 from dbo.Department with(TABLOCKX HOLDLOCK) Excelent that is what I needed !! Thanks Tag: Way to find registered classes/functions for the Assemblies added in Analysis Service.
  - 3
    - Managing SQL 2000 databases on Vista... The BCP utility is part of the database install disk for SQL server. I only have the 2000 version, not the 2005 version. Downloading Eval version isnt' a permanent solution... I did purchase MS Office Excel 2007... and I can create an ODBC link to the database and grab table data... but if I edit the table I can't seem to find a way to get it to save those changes back to the table directly Tag: Way to find registered classes/functions for the Assemblies added in Analysis Service.
  - 4
    - i got an err msg ************** JIT Debugging ************** To enable just-in-time (JIT) debugging, the .config file for this application or computer (machine.config) must have the jitDebugging value set in the system.windows.forms section. The application must also be compiled with debugging enabled. For example: <configuration> <system.windows.forms jitDebugging="true" /> </configuration> When JIT debugging is enabled, any unhandled exception will be sent to the JIT debugger registered on the computer rather than be handled by this dialog box. ------------------------------- so what i should do to mach for a biginer, where is this file thanks Tag: Way to find registered classes/functions for the Assemblies added in Analysis Service.
  - 5
    - Third Party .NET Charting packages Can SSRS be configured to use any third party .NET charting components or only ones that have been specifically designed for SSRS I have seen a couple of third party charting software (Dundas, etc.) and while they are nice, they sell at a real premium and there are not many vendors offering SSRS charting. I was hoping for a bit better value and more of a selection to choose from. R Tag: Way to find registered classes/functions for the Assemblies added in Analysis Service.
  - 6
    - Sql Server Express - Shared Hosting - Connection String - What do you guys do? Hey, I have a asp.net 2.0 app that has a sql server express backend. I have been scratching my head for weeks trying to find a good wasy to encrypt my connection string. I store the string in web.config (which in itself is in theory "safe" because it's not servable) and I have scoured the web to try to find a simple way to encrypt the connection string. Even using user store would require running aspreg_iis.exe on the host with a command prompt (which clearly I cannot do). It seems that everyone's solution requires running a command prompt executable on the server. So I am left to wonder what everyone else does. I am not comfortable using just the web.config because a determined hacker could get to that info. Then again, a determined hacker could get into any system , I guess. There are no credit card #'s stored in this app, but in theory there must be a way. I run all access to the db through stored procedures with permissions, for whatever it's worth. Thanks in advance! David Tag: Way to find registered classes/functions for the Assemblies added in Analysis Service.
  - 7
    - Stored Proc. With Multiple Database Reads I am trying to write stored procedures that deny table-level read/write to the sproc_user login. Here is what I want to do: Make a sproc_user login and allow public access to a database called KM. Within KM database, write stored procedures that query and update tables that may exist on either of three databases: KM, QM, or REP. However, I can get the stored procedure to read/write to tables on KM database, where sproc exists, as long as I grant execute rights to the login. However, how do I allow my stored procedures to SELECT, INSERT, and UPDATE to tables within QM and REP Tag: Way to find registered classes/functions for the Assemblies added in Analysis Service.
  - 8
    - Display Analysis Services Server-Based Formatting in RS 2005 Report 1. No, such an extension doesn't exists. 2. If you decide to stick with the SSAS 2005 data provider, you can add a Companies parameter which depends on the Country parameter. You could use a dataset for the default values of the companies dataset to pre-select them. You could also hide the Companies parameter if you don't want the user to see it. The companies parameter will be passed to the query. "Query expressions" probably means expression-based query text, e.g.; = Code.MyMethod (@Parameters!Country.Value) Here, MyMethod is a static method in .NET assembly. Then, your custom code can query the database and return the MDX query text. HTH Tag: Way to find registered classes/functions for the Assemblies added in Analysis Service.
  - 9
    - Connection Error: (provider: Shared Memory Provider, error: 0 - No process is on the other end of the pipe. I checked the SQL Server log (message 2 above) and realised there were too many connections opened. The error description was verbose. Closed them and it worked. Cheers Tag: Way to find registered classes/functions for the Assemblies added in Analysis Service.
  - 10
    - Security required to run deployment utility I would like to have my developers responsible for deploying their SSIS packages to the Test/QA environment. I tried granting access to several of the stored procedures in msdb and the sysdtspackages90 table. The only thing that seems to work is granting sysadmin priviliges. Is there a server or database role that will grant the appropriate access thanks Tag: Way to find registered classes/functions for the Assemblies added in Analysis Service.
  - 11
    - sql query Still very close, but not per spec. He seemed to want the "top of the hour", so need to remove the minutes. Not sure if the space is significant to him or not. select ltrim ( stuff (right( convert ( varchar ( 25 ), dateadd ( mi , datepart ( mi , getdate ())*- 1 , getdate ())), 7 ), 6 , 0 , ' ' )) Tag: Way to find registered classes/functions for the Assemblies added in Analysis Service.
  - 12
    - Debug tsql Ohhhh. You are correct. I had never tried that method. That does give a simple debugger version that might do what he wants. Tag: Way to find registered classes/functions for the Assemblies added in Analysis Service.
  - 13
    - Calling a package at Runtime I am working on a package that will sense a text file in a folder. From this text file I will be extracting the file name which will tell me what task I need to run. How can I create a package that, depending upon what the file name is, call a specific package. To be more clear, I will have 3 different flat files that is each in a standard form. Their names will be unique. To transform their data will require different ETL logic. I will be using a loop to constantly check to see if a file has been put into the directory. I just need to know how I can direct the input file to the proper ETL task. Tag: Way to find registered classes/functions for the Assemblies added in Analysis Service.
  - 14
    - define a default value ?? hallo i am on the very beginning with sql.s, how can i define a default value for the table field like its possible in access, for example: the if the user not gonna enter a val so there is a default val predefined in the table field, for example i would like to predefine the date now on the smalldate field.... thanks Tag: Way to find registered classes/functions for the Assemblies added in Analysis Service.
  - 15
    - Irritating issue in Reporting Services 2005 SP2. We don't face this problem in SP1. When we have a matrix and want to freeze some row-groups(columns), it does so. But when we drag the horizontal scroll bar of IE, the alignment of the row is completely screwed up. The text in the columns which are set to float, either shifts up or down. I guess this has to do with the wraping of the text in the row group cells. This is a great irritant and is stopping us from moving to SP2. Please let me know if this has been fixed or there is a workaround. Thanks Tag: Way to find registered classes/functions for the Assemblies added in Analysis Service.
  - 16
    - Accuracy of Host column on SS 2000 Enterprise Manager Current Activity Process Info Screen Yesterday and today, the Process Info screen in Enterprise Manager indicates that the "Host", a single workstation on our network, is generating around 50 connections to the database. This particular application is well-behaved and typically generates only 2 to 5 connections per instance. Furthermore, we cannot find this particular workstation/host on our network because we retired it off the network some time ago. Anyone know of the accuracy of the Hosts column on this Enterprise Manager screen We're suspecting that the network address column is correct but the Hosts column is incorrect. There are about 10 different network addresses pertaining to this particular Host (1-5 connections per network address). Tag: Way to find registered classes/functions for the Assemblies added in Analysis Service.
- Next
  - 1
    - Problem with AuthenticationExtension Hi, I got SSRS2005 with FormsAuthentication working for a while now without any problems. I decided to create some kind of 'Account Enabled' functionality and therefore I modified my AuthenticationExtension.cs. But what happened, the new functionality does not work. After adding some logging stuff to this file nothing changed. So it looks as if AuthenticationExtension.css is not being used at all in my security extension. I verified this by removing the file from the project and still...no changes! Other files in my security extension module are being used however. When I make a change to AuthenticationUtilities I can see it in my results. Does anyone know how this can happen Why is my extended IAuthenticationExtension not been used Thanks, Hans Tag: Way to find registered classes/functions for the Assemblies added in Analysis Service.
  - 2
    - Help with finding last record! Thanks guys, Will try these over the weekend when things quiten down here. No Xmas slowdown for us... Tag: Way to find registered classes/functions for the Assemblies added in Analysis Service.
  - 3
    - SAC Command Line utility doesn't start SQLBrowser Service I've exported surface area configuration settings from a server and tried importing them onto another server. The remote connection settings are imported but the SQLBrowser service remains Disabled. Am I doing something wrong The command line command I ran (in the C:\Program Files\Microsoft SQL Server\90\Shared directory) is "sac.exe in sacconfig.xml". The following is my config file: < xml version="1.0" encoding="utf-8" > <CommandArguments xmlns:xsi=" http://www.w3.org/2001/XMLSchema-instance " xmlns:xsd=" http://www.w3.org/2001/XMLSchema "> <Components> <anyType xsi:type="Component"> <Type>SqlServer</Type> <InternalType>DatabaseEngine</InternalType> <Instances> <anyType xsi:type="Instance"> <Name>SQLEXPRESS</Name> <Service> <Name>MSSQL$SQLEXPRESS</Name> <StartMode>Auto</StartMode> <ServiceState>Running</ServiceState> </Service> <Features> <anyType xsi:type="Pair"> <Key>AdhocRemoteQueries</Key> <Value xsi:type="xsd:int">0</Value> </anyType> <anyType xsi:type="Pair"> <Key>CLRIntegration</Key> <Value xsi:type="xsd:int">0</Value> </anyType> <anyType xsi:type="Pair"> <Key>DedicatedAdministrator</Key> <Value xsi:type="xsd:int">0</Value> </anyType> <anyType xsi:type="Pair"> <Key>DatabaseMail</Key> <Value xsi:type="xsd:int">0</Value> </anyType> <anyType xsi:type="Pair"> <Key>HTTPAccess</Key> <Value xsi:type="ArrayOfAnyType" /> </anyType> <anyType xsi:type="Pair"> <Key>OLEAutomation</Key> <Value xsi:type="xsd:int">0</Value> </anyType> <anyType xsi:type="Pair"> <Key>ServiceBroker</Key> <Value xsi:type="ArrayOfAnyType" /> </anyType> <anyType xsi:type="Pair"> <Key>SQLMail</Key> <Value xsi:type="xsd:int">0</Value> </anyType> <anyType xsi:type="Pair"> <Key>WebAssistant</Key> <Value xsi:type="xsd:int">0</Value> </anyType> <anyType xsi:type="Pair"> <Key>XP_cmdshell</Key> <Value xsi:type="xsd:int">0</Value> </anyType> </Features> <Protocol> <anyType xsi:type="Pair"> <Key>NamedPipes</Key> <Value xsi:type="xsd:boolean">true</Value> </anyType> <anyType xsi:type="Pair"> <Key>TCPIP</Key> <Value xsi:type="xsd:boolean">true</Value> </anyType> </Protocol> </anyType> </Instances> </anyType> <anyType xsi:type="Component"> <Type>SqlBrowser</Type> <InternalType>SqlBrowserService</InternalType> <Service> <Name>SQLBrowser</Name> <StartMode>Auto</StartMode> <ServiceState>Running</ServiceState> </Service> </anyType> </Components> <Version>9.0.242.0</Version> </CommandArguments> Tag: Way to find registered classes/functions for the Assemblies added in Analysis Service.
  - 4
    - Which Data Flow task to use? I have a table which has been loaded from various source feeds. The SourceId relates to the source name and the SourceCompanyId is the sources primary key for the company. I am basically trying to create one row with all the SourceCompanyIds in my column headers. What data flow tasks would be necessary in SSIS The structure of the final table is: CREATE TABLE [dbo] . [Company] ( [CompanyId] [int] IDENTITY ( 1 , 1 ) NOT NULL, [CompanyName] [varchar] ( 75 ), [CIK] [varchar] ( 10 ), [Ticker] [varchar] ( 10 ), [Source1CompanyId] [int] NULL, [Source2CompanyId] [int] NULL, [Source3CompanyId] [int] NULL, [Source4CompanyId] [int] NULL, [Source5CompanyId] [int] NULL, [Source6CompanyId] [int] NULL, CONSTRAINT [PK_Company] PRIMARY KEY CLUSTERED ( [CompanyId] ASC ) WITH ( IGNORE_DUP_KEY = OFF ) ON [PRIMARY] ) ON [PRIMARY] ================================= The table in which contains all the company data CREATE TABLE [dbo] . [SourceCompany] ( [SourceId] [int] NOT NULL, [SourceCompanyId] [varchar] ( 10 ) , [SourceCompanyName] [varchar] ( 75 ) , [CIK] [varchar] ( 10 ) , [Ticker] [varchar] ( 10 ) , CONSTRAINT [PK_SourceCompany] PRIMARY KEY CLUSTERED ( [SourceId] ASC , [SourceCompanyId] ASC ) WITH ( IGNORE_DUP_KEY = OFF ) ON [PRIMARY] ) ON [PRIMARY] Tag: Way to find registered classes/functions for the Assemblies added in Analysis Service.
  - 5
    - Reporting Services 2000 Installation Problems. Hello every1. I have been trying to install Reporting Services 2000 on a Windows Server 2003 machine with SQL Server 2000 and Framework 2.x for a couple of days now. When i run Reporting Services setup it tells me that Asp.Net is not installed or is not running, i know this could be caused becouse i have Asp.Net 2.x running instead of 1.x, but what ever i do, changing all IIS settings and website settings so the server uses Asp.Net 1.x the problem still exists, is there any solution besides a reinstallition and installing RS2000 be4 the Framework 2.0 Tag: Way to find registered classes/functions for the Assemblies added in Analysis Service.
  - 6
    - 64-bit Separate Install?? One 'quick and dirty' way to confirm that your server is running all 64bit applications is to examine the services applet ([Control Panel], [AdministrativeTools], [Services]). If you see WOW in the list, some application is running in 32 bit. Tag: Way to find registered classes/functions for the Assemblies added in Analysis Service.
  - 7
    - Is there 1 default instance per OS Server or per SQL Server? On a Server 2k3 x64, I've installed SQL Server 2000 x32 SP4 and SQL Server 2005 x64. When installing both SQL Server 2000 and 2005 on the same server, does each SQL Server have it's own "default instance" or there can only be one "default instance" per server TIA, Gary. Tag: Way to find registered classes/functions for the Assemblies added in Analysis Service.
  - 8
    - SSMS Help Hi, I'm not sure this is the right discussion room that I'm looking for my problem. In fact, the problem is very simple though I don't know how to deal with it. I accidentatly clicked some buttons on my SSMS IDE. And, my IDE seems bad. I uncheck 'Dockable' click box of SSMS's Object Explorer. And, is there anybody who know how to put that back to the original format Thanks. Myo Zaw Tag: Way to find registered classes/functions for the Assemblies added in Analysis Service.
  - 9
    - Creating an Windows Rdl on the fly using .net programming You are welcome and I hope that the Report Build is what you are looking for. Tag: Way to find registered classes/functions for the Assemblies added in Analysis Service.
  - 10
    - Datamigration to MS CRM PedroCGD wrote: Dear Smilebey, Send me the CREATE Table statment of your tables in source and destination to pedro.perfeito@cgd.pt . I will try to help you, and give you the better option to resolve it! Thanks! Actually, Pedro, that's what we do here in the forums... We try to help individuals here so that others can see the results. Tag: Way to find registered classes/functions for the Assemblies added in Analysis Service.
  - 11
    - SQL server replication connection problem Hi I have a problem when trying to setup replication between two SQL servers on different networks. My publication server is SQL Server 2005 Standard Edition. My subscription server is SQL server 2005 Express Edition I have setup the publication no problem but am now trying to create my subscriber. However, when trying to connect to the server, I receive the following error: SQL Server replication requires the actual server name to make a connection to the server. Connections through a server alias, IP address, or any other alternate name are not supported. Specify the actual server name, 'W2M-RDC-01'. (Microsoft.SqlServer. However, because the servers are not on the same network, I cannot use the server name. Why does it not allow you to connect to an IP Is there a way to create an alias I have read that you can but am unsure how to do this. Do I need to change the hosts file If so, where can I find this and what exactly do I need to change Kind Regards Dan Rostron Tag: Way to find registered classes/functions for the Assemblies added in Analysis Service.
  - 12
    - Aggregation Types Can anyone briefly describe all aggregation types available in SQL Server Analysis Services Thanks, Shyam Tag: Way to find registered classes/functions for the Assemblies added in Analysis Service.
  - 13
    - the procedure 'sp_addrolemember' cannot be executed within a transaction I use sp_addrolemember inside a DML trigger and every thing goes well in my computer; I can insert or update into my table and sp_addrolemember is executed successfully, but my customer get this error every time he tries to insert or update into the table. "the procedure 'sp_addrolemember' cannot be executed within a transaction" Can anybody help me solve this funny error. Tag: Way to find registered classes/functions for the Assemblies added in Analysis Service.
  - 14
    - Get Culture for Multilanguage in Reporting Service Hi Nick. Thanks for your response and suggestion. I read the link that you provide and I recheck my config file. Duh! I make mistake in the config file. No wonder my report display #Error because it cannot do some access that it want. Just like what you said. Now, I'm working on getting the right culture to pass in my code. Anyway, Thanks a lot. Tag: Way to find registered classes/functions for the Assemblies added in Analysis Service.
  - 15
    - using case statement to determine Order by field and direction (asc or desc) when using Row_number Thanks Mani and OJ. I started writing a solution and this helped me confirm that I need to break down into several case statements this way. Also yeah I need it to be compatible with various datatypes while sorting. Thanks again! Tag: Way to find registered classes/functions for the Assemblies added in Analysis Service.
  - 16
    - Reporting Services 2005 with SQL 2000 Database Hi friends, i have some questions about Reporting Services 2005: Can i use RS 2005 with a SQL 2000 Database Can i create a report with RS 2005 (with a SQL 2K Database) a show it in a webform What do i need to install (in the webserver and in the Database server) in order to start designing reports in RS 2005 against a SQL 2K DB Thanks in advance. Regards Eduardo Tag: Way to find registered classes/functions for the Assemblies added in Analysis Service.

Santosh Ransubhe

Hi,

Is there some way through which we can find the classes and function registered with Analysis Services, when we add Assembly code for Stored procedures

Thanks,
Santosh.

Top

Re: Way to find registered classes/functions for the Assemblies added in Analysis Service.

Thomas Ivarsson

Have you not found this in SQL Server Management Studio. Look under the object explorer for Analysis Services. I can see two folders under the SSAS2005 server: Databases and Assemblies.

Regards

Thomas Ivarsson

Top

Re: Way to find registered classes/functions for the Assemblies added in Analysis Service.

Santosh Ransubhe

Yes, i could see that. But what I was looking for is the classes and functions registered within those Assemblies registered. Basically, the stored procedures supported inside the Assemblies. Because all the time i get the error saying "This function XYZ does not exist".

Top