Kanhaiya's Q&A profile

• SQL Server Problems Using Temporary Tables

  I am declaring a temp table in control flow via Execute SQL task. I then want to use that table as a source in a data task, keep it alive going back to control flow and use it as a destination in another data task following. I am having trouble just getting the first data flow to access that temp table. In my Execute SQL task, I'm creating a simple temp table. After executing that task, I can head to the data task and change my OLE DB Source to point to that temp table, but I recieve an error about an invalid table name when I attempt to map columns or hit "OK." Is there something else I need to do to use that temp table as a source or can I only reference it through SQL queries Thank you. In ...Show All

• Visual Studio Team System User permission

  Hi Could anyone tell me where to find a explanation on how to set up the user permission in Team Foundation. We are currently rolling out VS2005 with Team foundation and we have difficulty to setup all the permission on a team project. Also if anyone know someone who does in house training about Team System on a project manager point of view near Reading (UK), please let me know. Thanks, Benoit For more information please consult our MSDN help documentation: http://msdn2.microsoft.com/en-us/library/ms252477.aspx  and http://msdn2.microsoft.com/en-us/library/ms253094.aspx Please let us know if you have any further questions not covered by the help docs. Thanks,   ...Show All

• Smart Device Development short alignment issue

  I'm seeing something very weird when compiling this code for an ARMV4i Smartphone target and running it on a smartphone emulator: INT foo(UINT16 *srcPtr) { short data; data = *(srcPtr+1); switch (*srcPtr) {... } If the memory pointed to by srcPtr contains: 11 22 33 44 55 66 77 88 data is set to 0x88776655 (endianism isn't the issue, but 32 instead of 16 bits is - it should be 0x4433) *srcPtr is evaluated as 0x44332211, again 32 instead of 16 bits, it should be 0x2211. Any ideas Cheers, Ken It wouldn't surprise me if intellisense gave you a different definition than the one really being used by the compiler. If you're in doubt about the actual width of a datatype, ...Show All

• Windows Forms Control visiblilty of main form component after the close of pop-up win form

  Dear All, My problem here is that first I have a combo box. Upon selecting a value of the combo box its visible set to false. Then at the same location the visible value of a text box is set to visible=true. The problem is that if the value which is keyed in the texbox is below a certain range then a pop dialog or winform will appear for confirmation of acceptance of the lower value. Upon making the confirmation via the pop-up win form the control gets back to the main form. Now I want the combo box to be visible=true and textbox visible=false when the control is pass back from the pop up winform to the main winform. Thanks. Hi, what you should be doing is this: Form1 f = new Form1(); i ...Show All

• Visual Studio Express Editions Can I................

  Here's the deal, one of the features of the program that I am creating is that it will (or should) have the ability to send a page out (to a pager). Again I am not asking how (at this point), just want to make sure that I can do this. And while I have everyone's attention, my program is coming along quite nicely, have the user interface done, database is connected, will have the database completely setup by Friday (hopefully, if my four year old doesn't make me do another all day "daddy come watch power rangers with me"), so looks like my first (and I do mean very first functional) program will be completed by the end of the month (go new guy, its your birthday). Thanks in advance for all the help. well to send emails, take ...Show All

• Visual Studio Express Editions how do i make the width bigger what numbers?

  How do i make the width bigger what numbers is the next up from 740,612 The project i have is from a starter kit and its not showin the buttons the buttons are hidden at the bottom! ...which can be achieved by setting the form's "AutoScroll" property to true . You can do this in designer window in the Properties pane, or by writing it manually to the form's constructor : public MyFormsName() { InitializeComponent(); this.AutoScroll = true; } If you do not wish to use scroll bars, just drag the form bigger, or set its Size property to some better value: this.Size = new Size(1000,1000); That should be enough. ...Show All

• SQL Server SQL Server 2005 - Log Shipping - Missing sp_change_primary_role and sp_change_secondary_role

  I have installed SQL Server 2005 and setup a cluster and log shipping. I decided to perform a planned failover and realized that there are no sp_change_primary_role and sp_change_secondary_role stored procedures. I checked on both the SQL Server 2005 installations and could not find them. My question is : "Is it safe to get these stored procedures from a SQL Server 2000 database and run them on the SQL Server 2005 database " "Has anyone come across such missing stored procedures in SQL Server 2005 and know the reason why it is so (so that I can avoid it in the future if it due to a faulty installation) " Cheers NEVILLE GEORGE Yes, follow the steps provided in the BOL refer ...Show All

• Visual C# Cast <IList>

  I have something like this... public static IList < AbstractKeyValueEntity <T>> Values<T>( ListBox listBox) { IList < AbstractKeyValueEntity <T>> results = new List < AbstractKeyValueEntity <T>>(); foreach ( ListItem item in listBox.Items) { if (item.Selected) { results.Add( AbstractKeyValueEntity <T>.GetLookupByEntityID(item.Value)); } } return results; } I make a function call something like this something is of type IList something = ( some ) CallFunction .Value< some >(DownList); I get an error saying Cannot implicitly convert type ''some' to 'System.Collections.IList'. An explicit conversion exists (are you m ...Show All

• SQL Server SSIS package that runs fine through command prompt, XML Error when run through SQL Server Agent Job CmdExec

  I have an SSIS package that runs fine through command pormpt although when I try to run it from a SQL Servr Agent Job CmdExec step it bombs out.  Please help this has me stumped...the SSIS package uses an XML connection string so certain key settings such as connection strings and email info can be changed easily.  Currently this is all on the same machine.  I have not moved it beyond where I am developing.   On the command line I am using the following command... dtexec /F "S:\connections\contacts.dtsConfig" /DE "password"   Below is the output log...   Microsoft (R) SQL Server Execute Package Utility Version 9.00.1399.06 for 32-bit Copyright (C) Microsoft Corp 1984-2005. All rights reser ...Show All

• Smart Device Development information regarding mobile start status

  hi all, I want to track the boot up of the mobile, i.e. after i switched off the mobile as soon as i start again, i want my appln to run. any help in achieving this i would very greatful. Thanx in advance thanx for the help.But where to include this code Invoking to the api in the console application. Thanx for ur help. ...Show All

• SQL Server Puzzle: NULL in Conditional Split Error

  A little puzzle with this Error - Status and PropertyType fields do not allow nulls while other columns do ( there are about 20 columns in original expression but left out for simplicity - these are created the same way ). Any ideas how to solve it [Conditional Split Filter Changes [813]] Error: The expression "LOOK_Status != Status || LOOK_PropertyType != PropertyType || (LOOK_OfficeName != OfficeName || ISNULL(LOOK_OfficeName) != ISNULL(OfficeName)) || (LOOK_OfficeID != OfficeID || ISNULL(LOOK_OfficeID) != ISNULL(OfficeID)) " on "output "Listing Changed" (885)" evaluated to NULL, but the "component "Conditional Split Filter Changes" (813)" requires a Boolean results. (My wish for nex ...Show All

• Microsoft ISV Community Center Forums Converting text file to excel file macro - help needed

  I have a text file I need to convert to an excel spreadsheet. I wouldn't have a problem making an array code if it were a straight file but the trick is that each line could be different. For example: Line one is 01330948951000312 eeid jan boerenkamp line 2 is 023330948951000312 00370058274800350010112/01/2002 Line 3 is 05330948951000312 31065327123107533811 any time a line begins with 01 it will follow that format any time a line begins with 02 it will follow the format of line 2 and so on Is there a way to make an array to put into Excel so that if a line starts with 01 it splits it one way and if a line begins with 02 it splits another way and so on Thanks in advance ...Show All

• Windows Live Developer Forums Can we modify our bots now!?!

  The www.robotinvaders.com site says that we are only required to host our robots until November 15, 2006. Since this is the case and the judging period is over (I think it is anyways) can we modify our bots now 5. Host the robot on your server Publish your BOT to a personal Web space. You must host your robot until November 15, 2006. [OT] there is a community site (not MS) contest for XNA here : http://xbox360homebrew.com/content/XNACreatorsClubContest.aspx ...Show All

• Visual Studio How to disable the Parameter prompt for Crystal Report using VB.Net

  I'm having a problem whereby I can't disable the parameter prompting in VB.Net with the following codes:- Dim crPDV As ParameterDiscreteValue Dim crPFD As ParameterFieldDefinitions Dim crPFL As ParameterFieldDefinition Dim crPV As ParameterValues crPFD = CR.DataDefinition.ParameterFields crPFL = crPFD.Item("paramterName") crPV = crPFL.CurrentValues crPDV = New CrystalDecisions.Shared.ParameterDiscreteValue crPDV.Value = valueToPass crPV.Add(crPDV) crPFL.ApplyCurrentValues(crPV) CrystalReportViewer1.ReportSource = Application.StartupPath & "\TheReport.rpt" CrystalReportViewer1.Show() Any error with the above codes OR do i need to add any additional code(s) that able for me to pass the parameter value direc ...Show All

• Visual Studio Express Editions some questions again

  1) i want my program to cover everyones screen full, i could use the windowstate maximize for that but what i want is that everything scales with the size of the form, i hope u understand what i mean 2) how can i get/put data from/in a dataset with coding thx in advance as for the video, you need to use either 3rd party control to do this or use and embed the WMP control in your application for the listbox, not sure but I know you can do this with a combobox. I guess one theory would be on the textchanged event of the textbox, to go through each item in the listbox and see if the item "startswith" the text the user entered and if so, keep it otherwise remove it. ...Show All