Hi, I have C# code that uses the Microsoft.AnalysisServices namespace to create OLAP databases. I can see the databases in C:\Program Files \Microsoft SQL Server\MSSQL.2\OLAP\Data. How do I open them with BIDS? Since I don't have a VS project, I can create a new one in BIDS but then I can't s...more >>

> > is there a step by step guide on build and register the assembly? thanks. > Yes - take a look at the "Creating Stored Procedures (Analysis Services)" chapter in BOL (http://msdn2.microsoft.com/en-us/library/ms175340.aspx). -- Dejan Sarka http://blogs.solidq.com/EN/dsarka/ ...more >>

Hi, I'm trying to incrementally train an associative model with Adomd.NET. Before having a nested table in the model I was able to have an INSERT INTO statement of the form INSERT INTO MiningStruct(c1, c2) @MyTabularContent binding a System.Data.DataTable to the MyTabularContent parameter. How...more >>

Briefly, like this: INSERT INTO MiningModel ( [Key], [Movies] ( SKIP, [Movie Title] ) ) SHAPE { @Table1Parameter } APPEND ( { @Table2Parameter } RELATE [User ID] TO [UID] ) Full details are available here: http://www.sqls...more >>

>i know how to find the database version liked using tsql > > select serverproperty('ProductVersion') > or > select @@version > > how can i find the version of the cube or the analysis services? thanks. I created myself a CLR procedure. Here is the main part you need: using System; usin...more >>

that is great. is there a step by step guide on build and register the assembly? thanks. "Dejan Sarka" wrote: > >i know how to find the database version liked using tsql > > > > select serverproperty('ProductVersion') > > or > > select @@version > > > > how can i find the version of ...more >>

i know how to find the database version liked using tsql select serverproperty('ProductVersion') or select @@version how can i find the version of the cube or the analysis services? thanks. ...more >>

Hi, what is the scalability of the Association Rules and Decision Tree algorithms at testing time? All comments are welcome: theoretical order of complexity and bounds, or benchmark results, or informal impressions. thanks, Gustavo...more >>

dziunzian networks algorithm is best feature you can find there > > What are some of the enhancement and new features related to Data Mining that I can expect in SQL Server 2008? > > thank you, > Gustavo Frederico...more >>

> Hi, I have two questions. The first one: is there a way to have > hierarchical input features in a model? For example, a location feature > that would be city/state/country/continent. I'm aware of the nested cases > but I'm not sure if they are equivalent. In the few examples I have seen >...more >>

"tdstr" <tdstr@booger.net> wrote in message news:uzD3d4%23FIHA.484@TK2MSFTNGP06.phx.gbl... > Total SQL newbie here. Hope I'm posting in the correct group. > > I have a Exchange 2003 server that archives all email to a large(55GB) SQL > database. I have a situation where I have to export sev...more >>

Hi, I think one the most important new feautures in katmai is the new algorith ARIMA, it will improve long term predictions. There are also new features to divive the trainig and testing tables. cheers -- Francisco A. Gonzalez fgonzalez@solidq.com "Gustavo Frederico" <gusta...more >>

> What are some of the enhancement and new features related to Data Mining > that I can expect in SQL Server 2008? The most important one is the ARIMA algorithm support for Time Series. -- Dejan Sarka http://blogs.solidq.com/EN/dsarka/ ...more >>

What are some of the enhancement and new features related to Data Mining that I can expect in SQL Server 2008? thank you, Gustavo Frederico...more >>

Total SQL newbie here. Hope I'm posting in the correct group. I have a Exchange 2003 server that archives all email to a large(55GB) SQL database. I have a situation where I have to export several emails from that database. However at this point I am clueless on how to accomplish this. A...more >>

Hi, I have two questions. The first one: is there a way to have hierarchical input features in a model? For example, a location feature that would be city/state/country/continent. I'm aware of the nested cases but I'm not sure if they are equivalent. In the few examples I have seen the nested cases ...more >>

You can find presentations on SQL Server 2005 Data Mining here: http://www.sqlserverdatamining.com/DMCommunity/Whitepapers+and+Articles/Whitepapers/default.aspx And there's a whitepaper on the add-ins here: http://www.sqlserverdatamining.com/DMCommunity/_DMAddinLaunch/default.aspx -- Raman...more >>

Hello Daniel, One of the tools you could consider is SSIS, it has a transformation called Term lookup, it looks for terms in an input that are stored in a database and returns the terms and number of ocurrences. term lookup is availablie only in enterprise. cheers -- Francisco A. G...more >>

Hi together, I have a lot of emails incoming and based on the categorie I should take action on them. We have a little keyword-database (at the moment an Excel Sheet). Each keyword (or more) would classify the email to a category. An example... members want to close an account and write an ...more >>

Unable to start TSQL Debugging. Could not attach to SQL Server Process on 'srvname'. The RPC server is unavailable. I get this error when I try to run a SQL Server Project with a CLR stored Procedure in it. The target DB is SQL Server 2005 and im using VS 2005. I simply create a new SQL Ser...more >>

Hi, I collect unmoderated base of forums. I do not wish to create problems. I respect work of moderators. Please if this forum moderated by human , remove this topic and I shall remove you from the base. Thanks ;)...more >>

Hello, I have an algo plug-in installation issue : When I start Analysis Services with a command like "msmdsrv -c -v", some dll needs by my Datamining plug-in are well found (they are in C:\Program Files\Microsoft SQL Server\MSSQL.2\OLAP\bin). But if I start Analysis Services as a Windows s...more >>

Hello, Victor I'm assuming you load your DLLs with LoadLibrary and simple DLL name. When an EXE runs as a services, its current directory is Windows\System32. This is why most likely why the DLLs are not found. Here is what I suggest: - Call GetModuleHandle(NULL) to get the module handle ...more >>

Hi, We are using Sql server 2005 std edition on a IBM Xeon sever with Windows 2000 server. Regularly we notice the unusual delay in the responce time of the server. In many times the cpu usage on the server is at minimum level (say 7-10%), but still the responce from the server is very slow. ...more >>

Hi, I need to some presentations on SQL Server 2005 Data Mining and Data Mining Add-ins for Office 2007. I tried downloading a few stuff from Microsoft Events and got some videos but no ppts. Can anyone assist with some ppts or pointers on the above 2 topics? Thanks Amit ...more >>

> what is the best way to store passwords and credit card information in SQL > Server 2005? This article shouldd give you some good ideas: http://www.microsoft.com/technet/prodtechnol/sql/2005/multisec.mspx. -- Dejan Sarka http://blogs.solidq.com/EN/dsarka/ ...more >>

what is the best way to store passwords and credit card information in SQL Server 2005? ...more >>

Hello, Indeed there is a problem in handling of custom algorithm's modeling flags. The issue has been fixed but was discovered too late for the fix to appear in SP2. If this is urgent, you could escalate this with Microsoft Customer Support to get a fix -- -- -- This posting is p...more >>

As Dejan mentions, SP2 of SQL Server 2005 contains fixes for multiple issues, including better memory management with neural Networks (so you may try raising MAXIMUM_INPUT_ATTRIBUTES back to the original value) as well as fixes in the Neural Net viewer -- -- -- This posting is provide...more >>

> > Thanks for the post ZhaoHui. I followed the steps in your example, but I get errors when I process the model. > > These are: > > OLE DB error: OLE DB or ODBC error: . > > Errors in the high-level relational engine. A connection could not be made to the data source specified in the qu...more >>