It is possible to query a relational datatable from DMX using call systemopenquery([Data_Source]'SELECT.....').
Is it possible to make queries of the mining model in the opposite direction from T-SQL on Database engine by any of the functions?

In TSQL how to use OPENXML to open an ntext field in a table? I can not read
the ntext into a local var as TSQL does not allowe ntext local variables.

If I do a plain Regression model, no splits, against a group of test
numbers that have a linear relationship, I get the precise
coefficent/intercept I would expect to see.
If I start playing with the data to make it fit less well, and the

I am told in a webcast today that SPSS 14 can be fully plugged into SQL
server 2005, anyone has more information or experience on this? Thanks
in advance.

Has anyone seen this error before?
"An unexpected error occurred (file 'dmcorrcountutils.cpp', line 2045, function 'DMCC_WorkerJobCaseProcessor::CacheCase')."

Jamie wrote in the other post:
<Jamie>
In the nested table, you need to skip the foriegn key, not the data.  In the
model, the column CustomerID shouldn't exist in the nested table.

Lets consider structure being created and trained as follows:
CREATE MINING STRUCTURE myst
(
CustomerId long key,

Can someone please point me the way to determing the strength of the
relationships between clusters? In the Cluster diagram the connectors
between the clusters are shaded according to the strength of the
relationship. I can't see any way (DMX) of determing a Centroid for the

One q.. Does anybody has experience with MCDBE certificates? Is it worth
doing it? Avg salary? DO u know some link where I can download matherials
for learning for exams? Thanks

Can anyone here point me to a web site with detailed information
comparing Oracle and Sql Server Data mining?

I'm using the TreeView viewer and would like to set the Tree, Default Expansion and Show Level properties programmatically.
I figure it has something to do with the following method, but I have no idea what the arguments would need to be.
public void SetSetting(string viewerName, ...

Using sequence cluster can find out the similar seuence pattern in transaction history.
such as
PC --> Printer --> ...
If I use the transaction basket as sequence key,can Microsoft sequence cluster find the rule as :

I have a few questions...
1.) Is it possible to browse different schema rowsets in SQL managment studio except Mining_Model_Content schema using DMX in a way like "SELECT * FROM MyModelName.CONTENT"? For example Mining_Services Schema Rowset? Or is the only way to get schema ...

I have a table with 10000 records:
PatientID (discrete),
Age (continous),
Sex,

What do I need to do to convert and then run the datavalidation mining example from visual studio 2003 to 2005. I can only convert it but then nothing shows on my screen, so I cannot rebuild the application or debug it