Answer Questions

• Anatoly Rozhyn Cannot find an item in a big table

  Hello people, I have a table of 30,000 records on my handheld which runs windows 4.2 and sql me. When the item I am searching for is at the top of the table, the search finds it easily. When the item is in the middle or lower, it doesnt find it. I am not running out of memory and my database is on the local memory. Here is my code: String query = "SELECT * FROM Products WHERE Barcode = " + TheReaderData.Text; DataSet ds = GetDescription(query); label2.Text = TheReaderData.Text; label1.Text = "No description" ; if (ds.Tables[0].Rows.Count != 0) { label2.Text = (ds.Tables[0].Rows[0].ItemArray[0]).ToString(); label1.Text = (ds.Tables[0].Rows[0].ItemArray[1]).ToString(); } -- ...Show All

• Holm76 comments

  hi how can i put comments in rdl (XML) Thanks Are you talking about the data source view (DSV)-which is the xml file which contains the metadata about the structures and relationships in a datasource if so its like html <!-- Add your comment here--> Hope this helps ...Show All

• LotusExigeS1 SQL Sever 2000 to SQL server 2005

  Hi all, I have an aplication in VB6 that uses an ODBC to link to a SQL database. Until today all my clientes had SQL Server2000 and my aplication worked fine. Some of my cliente have now SQL 2005 and my application still woks fine except in one of them. In this particular cliente it gives an error when the application tries to read/write a particular table and a particular column. This column is data type BIT and my code is ... Myrs("Servida")= true ... Any idea why the error appens And why only in a particular machine and not all of them with SQL2005 What can I do I changed the code for myrs("servida")=abs(cint(true)) and solved the problem, but is not the way that I want to go. I do not want ...Show All

• Atulpatel trim trailing white spaces

  Hi All, I have a column which has some white spaces that I suspect is tab delimeted one. So when I use a rtrim(col1) it would not trim those. So i used a scrip component and wrote this line, Row.trimDetail = RTrim(Row.detail) here trimdetail is an o/p column and detail is the input col with the trailing spaces. but still I don know why the column has that spaces. Can someone help me to figure out what is the problem Thanks in advance, Well, are you sure they are spaces and not tabs You could also just use a derived column transformation to do the trimming instead of a script. that likely won't help here though. Thx for the comments. The col am selecting is from a char But  ...Show All

• BobInIndy Replication from Sql Server 2000 to Sql Express 2005

  I want to replicate data from sql server 2000 to a sql server express 2005 box. I can dts data across..but I want to be able to set up push replication from the Sql Server 2000 box, but the option to push the data to the Sql Express server in the GUI does not come up only Sql Server 2000 boxes are listed. Initially I will be using Snapshot replication but would like to eventually move on to transactional rep if only I can get it to push the data across. Does anyone know how to acheive this thanks for any help Sammy. Couple problem here... SQL Server Express 2005 can only be used as a subscriber and it cannot server as a publisher or distributor. http://msdn2.micros ...Show All

• freewind Table Column Comparison Transform

  Is there a transform available which allows you to specify two different tables (same primary key) and compare columns (you identify which column(s) values need to be compared in the transform) between those two tables thanks If the variability is small on the number of changes to the column comparisons, you could set up all of the possible scenarios, and later choose which comparison to use using a conditional split or derived column. Otherwise, it's not really possible any way you cut it. You could do something in a script component, I suppose, but you're looking at quite a bit of work. How does this not fit into a lookup transformation So basically then, just read from Table A, then f ...Show All

• Al Harlow Please correct syntax

  hi there RS2005 - Layout tab I have a field that says txtTrackerTrue=Sum(Iif ((Fields!Tracker.Value = Fields!RecvdBy.Value), 1,0 )) I want another field that says txtAllTrue =Sum(Iif ((Fields!Tracker.Value, ClosedBy.Value = Fields!RecvdBy, 1,0 )) obviously this is going to error how would I do this please thanks hey there thanks for jumping in, Reading back I didn't explain myself very well at all - sorry about that RS2005 - layout tab Name of txt box = txtTrackerTrue Value of this txt box = Sum(Iif ((Fields!Tracker.Value = Fields!RecvdBy.Value), 1,0 )) This is correct - this is just for guidelines. I need another field Lets call the txt box = txtAllTrue V ...Show All

• Ceres629 SQL server Groups

  Is it possible that i can create a SQL Server Group in sql 2005. Eg. in 2K when u right click (in Enterprise manager) on Microsoft Sql servers you can see "New Sql server Group". I am talking about this group. I have many servers in NYC and Dallas and in VA. I want to group them in the group names NYC DAL VA. is it possible. Do you have a screen shot I'm not understanding what you are seeing. Hi Narayan, What you have said is possible, you can create the Group and Sort your SQL Server as per your requirement. Hemantgiri S. Goswami Press Ctrl+alt+G or View -- Registered Server . In this window u can group the servers Madhu yes Michael you are right but i made a server group but cant see that ...Show All

• Sai A Render a report from the command line (RS.exe)

  I am trying to redo an app that I built to gen reoprts from the command line in a specified format using RS 2000 to use RS 2005. However, I am having a problem using rs.exe to render a report. It looks like the rs.Render method no longer exists. It also looks like you can no longer get to these methods from the rs.exe environment. Is it still possible to render reports using rs.exe If so, can somebody please provide an example Thank you in advance. Nice! I will give it a try. Thanks Brad. Nope. After doing some more digging into the SSRS classes it looks as though you now have to use the CreateReport() method which is only exposed by the web service via the ReportingService2005 class. So that means that you can no lo ...Show All

• CYBORG615 NtBackup & VSS

  Hey guys Just a question. If I use NtBackup with Sql server 2005 & sql writer started, the NtBackup use the Volume shadow Copy Service and the Sql Server Writer That is if do I do the backup of the log and data files, is these correctly and with consistence Very Tanks What I mean by crash-consistent is this: ntbackup does indeed coordinate with the SQL Writer via VSS. However, we do not require all transactions to be completed or rolled back before the snapshot takes place. To do so would cause a major interruption in workflow, which is what we are trying to avoid. Instead, we just make sure that there is no I/O happening during the very brief period that the snapshot is being created. When this is then used for restorin ...Show All

• AlexBB SQL Server Everywhere - Retrieve Identity column after insert record

  Hello Using Visual Studio 2005 Prof and SQL Server everywhere. How do get the identity column value after insert record. With SQL Server 2005, its quite easy to get by creating and insert statement on the tabledapter ( Insert statement followed by a select statement where identitycolumn = scope_identity()) How do this is sql everywhere regards   You can try getting @@IDENTITY value to know the identity value used in that connection for last INSERT operation. Checkout if the following thread helps you! http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=96692&SiteID=1 Thanks, Laxmi Narsimha Rao ORUGANTI, SQL Server Everywhere, Microsoft Corporation ...Show All

• White Hawk Replicating Schema Changes

  Hi there, I'm using Sql 2005 merge replication and I have noticed something, I'm not sure if this is true or not:... My publication is set to replicate schema changes (replicate_ddl = 1). Now, I have noticed that schema changes are only replicated if the current snapshot is valid. Is this right If so why My next question carries on from the first. If I'm about to run a TSQL script on my publisher that will add a column or two to a published table, how do I ensure my snapshot is valid inorder for the ddl changes to be replcated Should I be using: EXEC sp_mergearticlecolumn @publication = <publicationname> , @article = <article name> , @force_invalidate_snapshot = 1 , @force_reinit_subscriptio ...Show All

• benwalker Newbie Question

  Hi I'm working with SQL Express, and this is my first experience with DB, so I'm still learning. I made a rather stupid mistake, and I'm not quite sure how to get out of it. In the process of trying to fix a problem, I changed the default DB in my account to one that it can no longer connect to - for a reason unknown to me. (once I get this cleared up, I'll ask about that.) Now I can't login properly to SQL Express, b/c it can't connect properly. please help thanx Jeffery Thanx... Duh! - to me - I should have thought of creating another local Admin account. Thanx - it worked. hi, yiu should be able to connect via a system administrator login, bot WinNT t ...Show All

• 2162 Help me remind me why I never run a package from a package

  Hi, For some reason, I stay away from executing a package from a package. I guess that this is because I have experienced issues with this in the past and because I have read some articles in that forum that pin point specific issues when you do this. So far I try very hard to either combine all I need in one package or I break it down in multiple packages and use SQL Agent to drive the package chaining. Does anyone has a better experience with SP2 as far as running child package from parent package is concerned Any bugs remaining out there Thanks, Philippe Hi, I agree with the idea to avoid a super big and slow opening package while it depends if you pull everything at the same ...Show All

• Prabagarane Stopping package execution programatically

  Hi, I am p rogrammatically creating a package and for executing the package i say "Package.Execute()". Likewise,is there any method exposed which programatically stops the package execution Thanks in advance, Suganya Since you appear to be hosting the execution yourself, you could use events, see IDTSEvents, and tell the package you want it to stop by passing true back when OnQueryCancel is called. DefaultEvents is helper that already implements IDTSEvents for you, have a look at the example - http://msdn2.microsoft.com/en-us/library/0f00bd66-efd5-4f12-9e1c-36195f739332(SQL.90).aspx As jaegd indicates, the task must fire the event for you to reply with your cancellation option, and that does not al ...Show All