Answer Questions

• Karrar output column in asynchrnous script component

  I created a output column in a script component with synchronousinputid = 0 in the output. But in the script designer, I do not see this column listed for the row. Whereas when this property is not 0, the column is listed for the row. What am I missing here Thanks Rviswa ...Show All

• JamesScottJr Not getting the return value from Stored Procedure.

  Enclosed is the stored procedure: set ANSI_NULLS ON set QUOTED_IDENTIFIER ON GO ALTER PROCEDURE [dbo] . [InsertModule] ( @Module nvarchar ( MAX ) ) AS Begin Set NOCOUNT ON if exists ( Select 1 From Modules Where Module = @Module ) Begin return - 1 End ELSE Begin INSERT INTO [dbo] . [Modules] ( [Module] ) VALUES ( @Module ) RETURN 0 End END This is the calling program: private void SubmitButton_Click( object sender, EventArgs e) { sqlConnection1.Open(); if (Module.Length > 0) { SqlCommand cmdModule = new SqlCommand ( "InsertModule" ,sqlConnection1); cmdModule.CommandTy ...Show All

• Tadwick Export to CSV - Multiple Subreports

  A little background: We have a container report that houses 12 subreports. Only 1 subreport is displayed when executed. The other subreports are hidden via an expression. The subreports are stacked on top of one another. The Problem: When exported to .csv, we will get the data of the "visible report" (this is what we want), however we get 11 "Error: Subreport cannot be shown" where the other subreports are "hidden". This would be very confusing to our endusers, and I am having a hard time resolving this. Has anyone had a similar experience Thanks in advance. Yes, This is By Design and expected behaviour in CSV. ...Show All

• jkushiner Hours/minutes in the Calendar date time prompt

  Is there any way to get teh date time prompt to display hours & minutes For example, if I default the field to '=Today', I would like to see '8/10/2006 9:04 AM' instead of '8/10/2006' Similarly, when I pick a date using the date picker control that is displayed by default, I would like it to also display the time, which I guess would default to 12:00 AM. Thanks in advance! Thanks...your replies got me off on the right path. I ended up using the following: =DateAdd("h",12,Today) and =now I had been using =Today which just returns a date. Duh. I have a report parameter set using : =DateSerial(Year(now()), Month(now()), 0) that displ ...Show All

• FredMunro CrossTable - SQL Server 2000 Help me

  Hello, sorry for my English.. i have this problem two tables TABLE_A Import 65 132 244 165 TABLE_B FromValue ToValue 0 100 101 200 201 1000 i'd like a query that have to result this Field1 Field2 Field3 (Count of table A) 0 100 1 101 200 2 201 1000 1 and if i change the table B this query automatically change.. thank's very much Thank's very much Try SELECT FromValue ToValue, (SELECT COUNT(*) FROM TableA A WHERE A.ImportBETWEEN B.FromValue AND B.ToValue) AS Cnt FROM TableB ...Show All

• David Sadler Wrong values stored in a field of Datatype Float

  Hi, When i try to insert a value in to a field of datatype float(8), it is storing the wrong values(approximate values). For example, if i try to insert 2.62 , it takes it as 2.6200000000000001 But i can see the correct values displayed in the frontend. Heard that there is a fix available for this issue. Could any of you help me in getting the details about that fix Thanks in advance. ~ Chaitanya In addition to what Jens said, read here about the float datatype: http://msdn2.microsoft.com/en-us/library/ms173773.aspx It is what is called an approximate datatype, so you can have some minor (mathematically insignificant) differences between what you expect and what ...Show All

• Kyle J. Conflict table cleanup interval

  What replication parameter sets the interval in which data in the conflict tables is deleted in SQL Server 2000 SP4 Apparently when the snapshots are generated the conflict tables are cleaned out as part of the process. This was causing my conflicts to disappear each night when the snapshot agent ran. Rerunning snapshot should not be cleaning the tables. @conflict_retention governs how long the data will be kept in these tables before purging. If I have data in the conflict tables and then execute the snapshot SQL Agent job the conflict tables are cleaned out. I have the @conflict_retention value set to 90 days. The publication is a filtered merge publication ...Show All

• IlyaCher Connecting to Oracle from Windows 64bit IA server

  I am trying to pull data from an Oracle 9i database to my SQL Server 2005 sp1 database on Windows 2003 64bit Itanium server. Each time I try to use the import wizard, select the Microsoft OLE DB driver for Oracle, I get an error message telling me that the Oracle client tools are not installed. This happened after I had already installed the 9i tools, tested the connection using TNSPING and confirmed the tnsnames file was correct. So, I uninstalled the 9i tools and then installed the 10g client tools. Tested everything after the install and then tried the import again selecting the MS OLE DB driver for Oracle. I again got the error message that the Oracle tools were not installed. has anyone ran into this problem and if so, were you abl ...Show All

• Assaf Stone Help me Search engine

  I build catelog and index full text search. If search on one table then it's very simple but I want to search keywords on more tables and show results order DESC by RANK.Pls help me. ...Show All

• siva_Baskar Differences between mined data and queried data : Association rule

  Dear all, I have a table containing call records, and made a mining model from that table only. The model has 3 columns : calling_number, called_number, and target_operator, using Association Rule algorithm. The key is calling_number, input was operator, and predicted column called_number. The result shows no rule, but there are results with item-set size of 1 (column) and 2 (column). On the top record of the result, SQL Server says there are 1891 support for called_number = 1891 and operator = 'INDOSAT'. I queried the table with this query SELECT DISTINCT calling_number FROM call_records WHERE called_number = '07786000815' AND target_operator = 'INDOSAT'; It returns 2162 records instead of 1891. If I removed the DISTINCT qualifier, SQL S ...Show All

• creaturita SQL Server Mobile subscription problem

  Hi, i have created publication on server.and when i try to create sql server mobile subscription on my machine, i get following error: TITLE: Microsoft SQL Server Management Studio ------------------------------ A request to send data to the computer running IIS has failed. For more information, see HRESULT. HRESULT 0x80072EE2 (28037) ------------------------------ BUTTONS: OK ------------------------------ my machine and server are on different. i am able to get "SQL Server Mobile Server Agent 3.0" message when i run  / sqlcesa30.dll" href="http:// / sqlcesa30.dll">http://<server_name>/<virtual_dir>sqlcesa30.dll through Internet explorer what should i do now.please help me   ...Show All

• leshan Getting "product level is insufficient" message on flat file destination

  Hello, I have read previous threads on this, still not working. New installation of SQL Server 2005 on a Windows Server 2003 box. I have installed SP1 on both the server & the client, do I have to re-create the package Thanks in advance, Dave Where do you get the error and what are you doing Are you promoting the package to the server and then are receiving this error Have you installed the SSIS toolset on the client computer Just because you can develop in SSIS doesn't mean that it was installed. What version of SQL Server did you install on the server and on the client Issue resolved - I believe the issue was that SSIS was not installed on the client properly. I re-inst ...Show All

• Elfar Alfre&amp;#240;sson - MCAD Very High CPU during Full Text population

  I am building my first catalog on my 2005 server. It currently has been running for almost 3 hours now when in 2000 it took a little more than an hour. It seems the bottle neck is my sqlserver. I know that there are 2 other services associated with populating the catalogs but they don't seem to be doing much but the sqlserver.exe is sitting at 98% cpu or more. This obviously is not good. I tried searching for solutions and found nothing that helps. I increases the available memory to the server to 2gb from 1gb but the server is only using 40mb anyways so that did nothing. I am not sure what to do next... The table that is full text has 3 varchar(max) columns plus 10 other varchar fields but I wouldn't think that has anything to do with ...Show All

• Mandip can service Broker talk to informix

  Hi, I am very new to Service Broker. Can I have a Service Broker which will Exchange Message from Informix and service broker sitting on SQL Server Box. If this is possible, How can we achieve it. Any Pointers will be very helpfull. Thanks Hi Dinesh, Some where I read that we need to have a sql server express at the machine having Informix, then we need to link the informix with express and send the message through express and receive the acknoledgement from express. I have not yet tested this infrastructure... :( waiting for insatlled Informix. -Dharmbir Hello Remus, This seems fine for Informix installed on Windows, but in my case, I c ...Show All

• Pintoo Khaira Error when I try to add Output Column in in Data Conversion

  Here is what I get. Is this an install problem or is this how this software works =================================== Error at Data Flow Task [Data Conversion [720]]: An output cannot be added to the outputs collection. (Microsoft Visual Studio) =================================== Exception from HRESULT: 0xC020800F (Microsoft.SqlServer.DTSPipelineWrap) ------------------------------ Program Location: at Microsoft.SqlServer.Dts.Pipeline.Wrapper.CManagedComponentWrapperClass.InsertOutput(DTSInsertPlacement eInsertPlacement, Int32 lOutputID) at Microsoft.DataTransformationServices.Design.Controls.ComponentMetaDataTreeView.AddOutput() What did you do to cause the error -Jamie When in a package I added a data flow ob ...Show All