Is there a way to script Database maintenance plans for documentation purposes? If so, can you post or send me the code? Thanks in advance, Steven sabt@mail.de.state.az.us...more >>

How can I automate the scripting of all database objects?...more >>

Hi there, I'm an ASP and SQL newbie as well. I'm trying to write a script that inserts fields into a database and so far that's working perfect. The problem is, I need to restrict number of entries into the table on the database to e.g 20. Where do I put the script? It's currently sitting...more >>

Respected sir, i have a database called student.mdf. unfortunately my sql server was corrupted. and i have not taken the database back up of it. but i have the student.mdf file and student.log files. my question is can i get back the data from these two files. if possible , would you please...more >>

I have a table with multiple extended properties. I am using fn_listextendedproperty to return the properties in query analyzer. Does anyone know an easy way to return all extended properties at one time? Thanks in advance...more >>

Referring to FAQ # 13 and an explanation given here by Peter Kim (as of March 8th 2003) I would like to compare dependency link strongness (weight) between two analogic DM models with the same DM model (conceptual) definiton but different data set ( for example, as a result of different manually ...more >>

Hi, Thanks for all the help I have received from the Microsoft Analysis Services Team, I think the DM framework is fantastic. I'm developing a number of algorithms within the MS Data Mining framework, one of which is a clustering algorithm. I've got to the stage where I want to use the Clus...more >>

Hi, i managed to get the VB code to create a mining model. My question is, how am i make use of this VB code 'coz i am quite new to VB. Do i need to add a module or class module for the code? and how can i view the result through VB after the mining process? or maybe i should add a button a...more >>

Hi, i tried to learnt the Analysis Services by following the tutorial online in SQL Analysis Manager. First, i was asked to add a data source in ODBC Data Source Administrator under the System DSN. I followed the instruction and successfully added the System Data Source. After that, i op...more >>

SQL 2K I created my cube, process data and played with it. My question is , how to make this accessible to my users?? will they have to get into Analysis Manager ?? Is there any automated job to refresh (process) my cube on a daily basis. ?? Thanks Sh ...more >>

In win2k sql , "query analyzer", executed a "stored procedure". Checked the "write result to file". It created a ".rpt" file. Then, in Crystal Report 9, tried to open the rpt file, got "Can not open document", "Invalid report schema". -- Sent by msg_2222 from yahoo part of com ...more >>

I have 2 databases within SQL Server 2000. What I want to do is create a view in database A that references tables in database B. Is that possible and how? Thanks in advance ...more >>

Dear All I have a problem need your help during creating new data mining model wizard : select case tables ,after clicking next button the error message appear with the following "Analysis Manager Unable to get list of Data mining Algorithmss.Operation not allowed when the object closed"...more >>

I'm a former Oracle user who has changed jobs and is starting out in SQL Server. In Oracle 8i and beyond there are extended "Analytical" SQL functions that can only be found in Oracle Enterprise. These include functions like ranking, inter- row comparison, etc. Are there similar "Analy...more >>

Here are the basics of my problem: My company has some data that needs to be broken up. There are many columns, but they want to break up the data based on clusters in one dimension. They want to be able to not specify the number of clusters for each pass, but to have the application look at t...more >>

Hi, I am aware that the Microsoft Clustering Algorithm handles missing data, and I am curious how it achieves this. Does anyone have any info on the techniques involved? Thanks in advance for any help John Sandiford...more >>