Answer Questions

• lushdog Usage of Association Rules

  Hello, I want to score my data by only the assoziation rules I filtered in Mining-Model-Viewer. Is this possible I recognized that MiningModel Predictionquery uses the generated Model (all rules). Is there any way to influence the model at generating time. Thanks a lot.   Hi, I specified the point to solve my problem but I did not understand why MS SQL Server didn't recognize the Association parameters I but in. It uses the Minimum_Probability I put in, but the Minimum_Importance i wrote didn't care it, it use the default value. I want to paste a screenshot here but it isn't possible. By the way I'm using the evaluation version, which should be same as the enterprise edition. Hope for a soon ans ...Show All

• MARCOSEDRALIN Error with setup of SQL Server 2005 Express

  I had Beta 2 of Visual Studio 2005 installed on my computer until the recent release. I followed the uninstall instructions in order, then installed the available 2005 Express editions. Each install showed an error when installing SQL Server 2005 Express. I attempted to install SQL Server 2005 from a fresh download, and it indicated that there were still beta components on the computer. I downloaded and ran the VS Beta Uninstall tool, which did find one component (SQL Server 2005 Express CTP), but it has an error while trying to uninstall it. The message is: The setup has encountered an unexpected error in datastore. The action is RestoreSetupParams. The error is :Failed to read property "Installds" {"MachineConfiguration", "", [computer ...Show All

• Onats Vista "Ultimate" and Sql 2005 Developer's Edition

  Is sql 2005 Developer's Edition\Vista Ultimate OS an officially supported combination Or not yet TIA, Barkingdog I want to clarify one thing here. SQL Server 2005 Developer's Edition can be installed on Vista Ultimate but SQL Server 2005 SP2 must be applied on it while SP1 cannot be applied on it. >>>...SQL Server 2005 SP2 must be applied on it while SP1 cannot .... Is Sql 2005 SP2 released I thought that only the beta SP2 was available. Also, you wrote that SP1 cannot be applied to sql 2005 Dev edition under Windows Vista. But SP2 can Something seems odd about that. Thanks, Barkingdog ...Show All

• Jeff Patton Similar problem

  Hi folks, I’m relatively new to both SQL Reporting Services as well as .Net programming. I come from a Crystal Reports background and I’m running into a problem duplicating a common technique used in my old Crystal reports. The simplified description of the problem I’m having is this… it seems that public shared variables are evaluated in the wrong order when accessing them from code in grouped tables. It seems that the group header is evaluated first, then the group footer and finally all the detail rows. As a result, if I modify a shared variable in the details section of a grouped table, that modification isn’t recognized in the group footer. Here are the details of what I’m trying to accomplish… I have added a table to my report which ...Show All

• Yuki Chen SSIS..Problem Parsing FlatFile Source

  I'm trying to Move data from a FlatFile Source to an SQL destination row delimiter {LF} Column Delimiter is "comma" Number of columns in each row : say 7 Example Rows Example 1: 1,1,1,1,1,1,1{LF}2,2,2,2,2,2,2{LF}3,3,3,3,3,3,3{LF}4,4,4,4,4,4,4{LF} Example 2: 1,1,1,1{LF}2,2,2,2,2,2,2{LF}3,3,3,3{LF}4,4{LF} There is no problem parsing Example 1: With Example 2. The Old DTS used to parse fine..when it encounters a row delimiter it fills the rest of the columns with null... While the New SSIS flat File source is following column count in each row...and is considering " 1{LF}2" as column item rather than a row delimiter... Is there any way around it or is it a bug Thanks for any help in advance ...Show All

• mshvw Need help to Create SSIS package to send mails

  Hi All, I am new to SQL Server 2005, I need Help to create a SSIS package for the below taks, My task is Refer a Column [Status] in the Logtable which is used to maintain the logs for the running processes, When ever any Rows with the "FAIL" status in Status column occurs in the LogTable then get the Respective ErrorRowNumber and get the Details of the Error from other 2, 3 tables which will be a simple SQL statements, when you get the Error Details then mail these details to the given Email id. For this I need a help In creating a SSIS package which will continuously check the Status and if any FAIL status occurs then the Error details need to mail to mail id which are stored in the config files of SSIS package. ...Show All

• Ben Corneau SQL Server Setup failed to retrieve the SSL Certificate Name

    When I try to install SQL 2005 Developer September CTP on Windows XP Professional  it returns an error "SQL Server Setup failed to retrieve the SSL Certificate Name" . I was using a certificate from SelfSSL but removed it. Still no luck This appears to be an issue with SQL Reporting Services. If I don't install Reporting Services then I can install SQL 2005. I'm guessing that Reporting Services is now requiring a certificate and doesn't like the SelfSSL certificates Any ideas When you have a certificate installed, the second step of the Web Server Certificate Wizard (at "[Default]Web Site>>Properties>>Directory Security>>Server Certificate...") should show "Remove Cer ...Show All

• SLV RDA with Identity column.

  Hi Everyone: I am new to Mobile programming. I am now working on a mobile project. I encounter an issue when I sync the data: cause I can't modify the schema, so I have to use RDA instead of Merge replication on sql server 2005. However, There is an identiy column on each table I will pull them down to local mobile database. And I will use those identity columns to connect tables. Even worse, the photo's new name will combine the photoID which is an identity column. There would an issue, if i sync data, the photoID would be same on different local mobile databases. And there would be generate same identity value when users sync data. How can I avoid those issues If you have any good ideas, please help me out so that I can meet ...Show All

• RussP Connection string Problem

  Hi! I have a very silly problem here. i am setting some variables here from c# code. Everything works fine except for Conn string. I understand statements that works fine in SQL does not act same in C# because of string literals. I need an extra qoute \"" ......."/" that would execute in C# \"" Data Source=SE413695\AASQL2005;Initial Catalog=TestDB;Integrated Security=SSPI ;"\" where as in c# setting variable value as : string scriptTaskConnectST = @"Data Source=SE413695\AASQL2005;Initial Catalog=TestDB;Integrated Security=SSPI;"; executing this through c# code jobCommand = new SqlCommand("xp_cmdshell 'dtexec /f \"" + path + "\" /Set ...Show All

• Nick Gravelyn Problem with multiple measure groups

  Hello! I have two measure groups (MG1, MG2) with measures called M1 (inside MG1) and M2 (insideMG2). For example M1 and M2 are sales amount. The total for M1 is 150 and for M2 100. If I start my analyses with a dimension that is only related to measure group M1 I see the following behavior. Dimension M1 M2 Product A 25 100 Product B 75 100 Product C 50 100 Question 1: How can I avoid AS 2005 to repeat the total value for M2 Question 2: If I define a calculated measure that brings the value from M1 and M2 together. How can I avoid that AS 2005 calculates each cell for M2 even though M2 has no realtion to the dimension Thanks in advance ! Ole If a dimension is not related to a MG and yo ...Show All

• Paul Burg SQL Server 2005 and DTC enabling on 2k Server

  I am using SQLServer 2005 and .NET when I use the following statements: using ( TransactionScope objTransaccion = new TransactionScope ( TransactionScopeOption .Required)) ... objTransaccion.Complete(); I get the following error: System.Transactions.TransactionManagerCommunicationException: Network access for Distributed Transaction Manager (MSDTC) has been disabled. Please enable DTC for network access in the security configuration for MSDTC using the Component Services Administrative tool. (Exception from HRESULT: 0x8004D024) I am trying to enable the DTC on Windows 2000 Server but the references seem to be to Windows 2003 Server. Any idea on how to do it on 2k Se ...Show All

• Woyler Failover not work when Principal server is down

  Hi, Here is my testing environment: Database server: SQL Server 2005 Developer Edition with SP1 Application: An application developed by Visual Studio 2005 using C# (.Net framework 2.0) and ADO .Net 2.0. Principal server: computerA Mirror server: computerB Witness server: computerC Mirroring mode: High availability with auto failover Connection String: Data Source=computerA;Failover Partner=computerB; Initial Catalog=test_mirroring;Persist Security Info=True;User ID=sa; Code used for failover: while (true) { thisDataSet = new DataSet (); try { thisConnection = new SqlConnection (connectionString); thisAdapter = new ...Show All

• jasse_91 How to dynamically enter error code and description in a pre-define table?

  Hi, I want to implement error handling my SSIS package. for this I am putting an execute SQL task for a container(which contains different interlinked tasks) in event handler. Say my first task fails in this container.Immedaitely my sql task which inserts the error code and description should exceute in the event handler and populate my error table in OLAP database. Any help will be great SSIS gurus. Thanks in advance. Regards, Aman Why does it not work As a concept it is soundf, and we use it in practice, so can you gives us an error message Another alternative is why not just use the built in logging to table option, and save yourself some work Perhaps even combine this with some of your own logging if you ne ...Show All

• glavian How to make a hierarchy in a document map?

  How to make a hierarchy in a document map In the report designer, I have two levels of grouping: First Level: Country, Second level: City. I have no problem to create a document map containing both grouping. However, the city and country are listed in a sequential order in the document map. What else should I do and how, to make them a hierarchy that looks like a tree (file folder) structure Thanks. Are you referring to generating them in a PDF or in the actual previewing of the report in report manager The PDF map seems to list them in the same tree, but will go to the correct location. In the report design you should also be able to set this up with groups. Having a do ...Show All

• SAD1 Unable to access Server

  I am unable to get past ClientHandshake and connect to a particular SQL Server. Is there any way to attach one of its mdf files to another server without first detaching it. That is, without detaching it from the server I can't access You could stop the service of the other server and then attach it to the other server. Two server sharing the same MDF is not possible. HTH, Jens Suessmeyer. --- http://www.sqlserver2005.de --- If you do think that you have access to the server wouldn't it be better to find out why you can not get the connection rather then just moving the problem to another server I agree and am working on that as well. This problem is posed ...Show All