How to change the datasource view of a mining model.

Hi,

I created on model in Business Intelligence Development studio.I wants to change the datasourceview(dsv) assigned for that view.for e.g

My mining Model is StudModel.dmm.

The dsv for that model is StudDSV.dsv.

I wants to change the dsv for that model to marksDSV.dsv.

How to do that in Business Intelligence Development studio.

Thanks,

Karthik.

The BI Dev Studio does not provide you with much support for this task.

You can change the DSV manually. It may be very easy or more difficult, depending on how similar the new DSV is compared to the original DSV.

Here is something you can do, manually:

- close the Mining structure designer window

- open the DMM file in BI Dev Studio (right click and select the View Code option)

- look for the <DataSourceViewID> element in the XML. Replace the content of the element with the id of your new data source view

- close and save the file

- double click on the DMM file to load it in the designer and validate the change

Now, if your new data source view contains different tables, or if those tables have differrent columns, more work needs to be done.

Note that the changes will only be visible after you re-deploy and process fully your mining structure

Hope this helps

sql

How to change the Data Path specified in the "SQL Server (MSSQLSERVER)" service proper

I have connected to the SQL Server 2005 instance usign the SQL Server Management Studio; I have changed the default locations for the database and log files. I have also rebooted the machine. When I look in the SQL Server Configuration Manager in the properties for the SQL Server (MSSQLSERVER) I see that the data path is still set to the old value and this field is read-only. How can this can changed without going through the registry?

What path are you talking about?

Changing the default database path does not change the path of the SQL Server binarys.

|||I am referring to the path that you see in the Service Properties through the SQL Server Configuration Manager, the tooltip and the Online Help is a bit contradictory concerning this path. Nevertheless I figured out where to change it in the registry but instead I did a full reinstall of SQL Server 2005.|||

You don't want to change this path. If you do the SQL Server won't start. The "Binary Path" which is listed is the path to the actualy exe file which is the SQL Server service. The only way to change this would be to uninstall and reinstall the SQL Server.

What is the end result that you are trying to get?

|||If you look closely and the tooltip for that path and the same explanation in the help when you hit F1 then you will notice that it is not really clear what this path is for. This path is not the binary path because I installed SQL Server in C:\Program Files\... and during the installation I changed the location for the databases to D:\Databases. The path I am talking about was set to D:\Databases but afterwards I had to move the data files to E:\Databases so in SQL Server I changed the database location to E:\Databases but for some reason the in the SQL Server it still pointed to D:\Databases which in the meantime no longer existed. I finally had to reinstall SQL Server anyway because the binaries had to be in the D:\Program Files\ and not on the C-drive.

How to change the Data Path specified in the "SQL Server (MSSQLSERVER)" service proper

I have connected to the SQL Server 2005 instance usign the SQL Server Management Studio; I have changed the default locations for the database and log files. I have also rebooted the machine. When I look in the SQL Server Configuration Manager in the properties for the SQL Server (MSSQLSERVER) I see that the data path is still set to the old value and this field is read-only. How can this can changed without going through the registry?

What path are you talking about?

Changing the default database path does not change the path of the SQL Server binarys.

|||I am referring to the path that you see in the Service Properties through the SQL Server Configuration Manager, the tooltip and the Online Help is a bit contradictory concerning this path. Nevertheless I figured out where to change it in the registry but instead I did a full reinstall of SQL Server 2005.|||

You don't want to change this path. If you do the SQL Server won't start. The "Binary Path" which is listed is the path to the actualy exe file which is the SQL Server service. The only way to change this would be to uninstall and reinstall the SQL Server.

What is the end result that you are trying to get?

|||If you look closely and the tooltip for that path and the same explanation in the help when you hit F1 then you will notice that it is not really clear what this path is for. This path is not the binary path because I installed SQL Server in C:\Program Files\... and during the installation I changed the location for the databases to D:\Databases. The path I am talking about was set to D:\Databases but afterwards I had to move the data files to E:\Databases so in SQL Server I changed the database location to E:\Databases but for some reason the in the SQL Server it still pointed to D:\Databases which in the meantime no longer existed. I finally had to reinstall SQL Server anyway because the binaries had to be in the D:\Program Files\ and not on the C-drive.

How to Change Query Type ?(Mangagement Studio)

Why the "Change Type" Button of the "Query Designer Toolbar " is alwayse Disable(gray color) ,then how can i switch the query between "selelct","update","Insert" and "Delete"? I am using Nov 7 released 180 Days Trial Version.(Sql Server Management Studio)

Thannks!

The Query toolbar is associated with Query Designer documents. The only way to display such a document in Management Studio is using the Open Table/Open View functionality for tables or views. The change type drop down is disabled in Open Table because we don't allow the Visual Studio Query Designer (which is displaying the query) to change the query type for Open Table. In Visual Studio, this restriction is lifted for Query Designer documents.

You can do what you want to do by creating a new query (click the New Query button), typing some text (say, "select"), highlighting the text you typed, right-clicking to bring up a context menu, and selecting "Design Query in Editor." In the Query Designer dialog that appears, you can right click in the upper pane and add tables. You can also right click and change the query type from the context menu.|||I see,Thank you for your Reply

How to change default script generation options in SQL 2005 tools or VS 2005

Ok, this has been driving me crazy in both SQL Management Studio and VS 2005 Server Explorer. How do you change the default script generation options?

When I right-click a stored procedure, table, etc. in the SQL Management Studio's Object Explorer, or in the VS 2005 Server Explorer and choose to generate a create script for that object it does not prompt me for any scripting options (like do I want to script dependant objects (where my answer is a resounding NO! but the default that ships with the tools is yes)).

I wouldn't mind complaining that I should be able to select multiple items in these tools and generate scripts for all selected items all at once. This doesn't seem to happen in Management studio at all, and if you do this in VS 2005's server explorer it always throws all your selected objects into one big ugly script file. I know that is more a vs issue than a SQL one, but if anyone has an answer to that I'd appreciate it.

In SQL management studio, in the Generate Scripts Wizard (the only way to gen more than one object at a time) is there a way to 1) make it create different files for each object I script and 2) is there, PLEASE, a way to stop the generated scripts for procs/functions from generating the IF statement to check to see if the object exists before the create statement? The reason for this is that I really do not want my create statement executed via the EXEC command as a string. You loose all your color coding, and if you generated in VS 2005 the editor has really annoying behavior when you use the CTRL + Arrow keys inside a string and you also loose the ability to edit the SQL block using the GUI query builder.

Anyway, any help with this would be appreciated.

Thanks

Hi, did you ever get a solution to this?

(I've come across the same problem)

Thanks,

Steve|||

There is an options page in the RTM version of the Generate Scripts Wizard in SQL Server Management Studio. There is an option for "Generate Script for Dependent Objects", and the default is "False."

There is also an option for "Include If NOT EXISTS", but the default there is "True." Setting the option to "False" makes the wizard omit the check.

The Generate Scripts Wizard can copy the generated SQL to a single file, the clipboard, or to a new SQL editor instance in SSMS.

|||Hi,

My specific problem was the fact that there was no options page if you chose to script the object by right-clicking the object in SQL Mgmt Studio.

I know if you right-click the database, that does open a wizard window and lets you change options but not if you right-click the object, or use VS2005 to script the object.

In the old VS2003, when you dragged an object from the Server Explorer to the Solution Explorer it would pop-up the script wizard window, but now it doesn't and seems to use it's own settings (which I can't change!)

Thanks,

Steve|||

You're right, the script menu items in SSMS for the objects themselves have no configurable options. I've added this as a feature request for a future release of SQL Server Management Studio.

|||Excellent, thanks!

Stevesql

How to change an existing UID to autonumbering?

Hullo!

Doubt it matters too much, but I'll just start off by saying that I'm using C# ASP.NET 2.0 in Visual Studio 2005.

I currently have a UID field entitled "ID", and I'd like to make it autonumbering so that users can input stuff into it through a simple web interface and not have to worry about the user's ID.

Anyone know how I could go about doing this? I can't seem to find a way through VS2005's GUI, and I can't seem to find anything on the internet about doing it through an SQL statement.

Thanks!I may have already figured my own problem out - I just have to test something really quick. If it works, I'll come back and tell ya what I did.

How to build a Management Studio plugin?

Our shop uses subversion for its source control, and since I can't find a SVN plugin for Management Studio I thought I would build one for fun. However, I am unable to find any documentation regarding how to do this or extending the Management Studio environment in general.

Is this documentation available? If so, where?

Thanks

It's accessible through the SCC API. The documentation on this is available through the Visual Studio Industry Partner program. http://msdn2.microsoft.com/en-us/vstudio/aa700860.aspx

Others are using CVS SCC proxy to integrate Subversion and Management Studio. You can find information and download this from: http://www.pushok.com/soft_cvs_proxy.php

-Sue

|||

This is excellent information. The Affiliate level of the VSIP program looks promising. Unfortunately, the site is down for maintenance until 8/15/2007.

Also, I found an updated link for the Push OK SVN plugin: http://www.pushok.com/soft_svn.php

Thanks a ton!

Ray