Thursday, March 8, 2012

Data mining Query

Well, maybe it's a fool question.But i'm so confusing.

My question is could i make data mining model using SQL QUERY ANALYZER which is embeded in SQL SERVER 2000 database?

Thank you so much before

Not really. You can use SQL Server Management Studio which comes with SQL 2005 to do so. If you want a query interface for SQL 2000, download the DMX Sample application from www.sqlserverdatamining.com.

Note that due to restrictions on SQL Server 2000 data mining, you can not create a server mining model using DMX. If you connect to a server and create a model with CREATE MINING MODEL, you will be creating a session modle that will disappear when you disconnect. If you use the MINING LOCATION connection string parameter set to a directory on your hard drive, you can create local mining models that will be persisted locally.

No comments:

Post a Comment