spattewar's Q&A profile

• SQL Server ForEach Loop Container Question

  Hi Currently the ForEach Loop container is set to loop over the entire collection of records in my table, but I only need to loop thru the records where the status = x. How is that possible Can I use expressions to set the enumerator to do something like this. Basiclly the collection values are used for further processing, and I would like to avoid looping thru records which have been processed already, which means they already have a status set to y. Please let me know. Thanks. MA Wow, I would think there has to be another way of doing this using expressions or something. I mean all I want to do is pick and chose from the enumeration. But on the other, I am not sure, maybe your way is the only way. I am just not too fond of us ...Show All

• Visual Basic Image On Mouse Over

  How do I get an imgae to display & follow the mouse by having my mouse over another image I forgot that the image must follow the mousepointer, so this updated code for the Form1 class will do that: (Note: add the unchanged code for the xxToolTip class too, of course) ...Show All

• Visual Basic Scrolling Text/RTF Box

  I am interested in creating a scrolling text status control where the latest inputs appear at the top jof a text box and the older information is scrolled down. I don't have a lot of text information to manage, maybe 50 lines or so. I was thinking that I could create a string variable with the present contents of the text box and then insert my new information to the top of the string wih an vbcrlf and then replace the old text in the text box with the new string. Are there any simpler ways to accompish such a task. I use this status text box to capture error messages and other program generated messages. Thanks, Fred Dim TheText As String = String . Empty For x As Integer = 0 To 10 TheText = ...Show All

• SQL Server distributed partitioned views

  Hi everyone, I have some doubts about distributed partitioned views. When we create a distributed partitioned view whcih include three server, do we have tocreate this same distributed partitioned view in that three server in order to make each server to see adn especially modify it Thanks Yes, you need to create the DPV on each server if you want to be able to modify the data on one or more of the servers from each one. Ex: -- server1 create view dpv as select ... from dbo.tbl1 union all select ... from server2.dbo.tbl2 union all select ... from server3.dbo.tbl3 -- server2 create view dpv as select ... from server1.dbo.tbl1 union all select ... from dbo.tbl2 uni ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Underlying Native Interfaces

  Is there any chance we can get a IntPtr to the underlying native interfaces, like device, textures, etc Not really. On Xbox 360, the native GPU resources are not even exposed into the managed space for security and performance reasons. On Windows, we do not expose the internal COM interface references. Paul ...Show All

• Visual Basic how i can display all application on my computer but not all proccess?

  hi, i want to display all application that install on my computer (like media player,excel,word,norton,...) but with out all proccess. like the list display in control panel->add/remove programs i know i can see the all proccess like this: proccess.getallproccess but i need just my install programs. i talking about visual studio 2003 thank u Hi Thanks for this sample. It only shows the Microsoft products. How can I get a listing of all installed products without knowing what vendors products are installed. Regards Deon ...Show All

• SQL Server Option "Include first-level subfolders"

  I do not have the option to "Include first-level subfolders". There is some discussion in another thread (Re: How to Delete Files on Maintenance Plan) that indicates this has been fixed on SP1. I am running SQL Server 2005 x86 64-bit Standard Edition with SP1. Is anyone else experiencing this problem Hi Satya, I just had the same problem you were having but I remember from a friend to always edit the Maintenance Plans on the local server machine, rather than to connect to the server remote using the Management Studio. You see the checkbox "include first-level subfolder" when you have run Management Studio on the server, and even the icons for Maintenance Plans are different ... red ...Show All

• SharePoint Products and Technologies MySite masterpage

  Hi All, On MOSS2007: I'm trying to change the default masterpage for mySites. I tried to edit the default.aspx in the 12/templates/sitetemplates/spspers folder, but I can't seem to let it point to another master ... as soon as I change the masterfile path, the page breaks. Any ideas on what's the best approach to link up my mySites with a custom masterpage Fred Tnx Alan, That's exactly what I wanted. One thing is a pitty though ... I did something similar wih the global onet.xml to change the masterpage of newly created teamsites, but now I've ended up with two file copies of my custom masterpage which isn't very nice because changes have to be copied now to those 2 locations. But I'm happy :-) Fr ...Show All

• Visual Studio Team System Accidentally deleted the only licensed user!

  Do not ask why. The fact is that I accidentally deleted my account (the only licensed user) from the Server Licensed Users group. I am not able to connect to TFS now. I am planning to reinstall, but that takes much time. I tried to found a Server side admin tool, but it seems there is no such tool. Is it possible to add users to the licensed group using a command line tool Thanks. If you run repair/reinstall for Team Foundation Server on the Application Tier from the "Add/Remove Programs" control panel, it should fix that for you. Best of luck- Cheers, Adam ...Show All

• Visual Basic excel spreadsheet

  How do I parse an excel spreadsheet Its rather simple just two columns the first a string and the second integer How do i load and read that "array" I presume Mitch Hey Spotty, Could you please contact me at edhickey at microsoft dot com I'm an MSFT employee, and I'd love to ask you about a program that I am part of. Thanks! Ed ...Show All

• Visual FoxPro form help

  hi! i am new in vfp now i am creating new proj and icreate form with theree grid i would like to auto increment id field (tab not to stop on this field) also when i click add buton it will refresh only parent form field ( not grid field) thanks lavesh thanks for your reply i am using vfp 6.0 what is the code for when i save record it will auto increse no and when i add record i want to refresh parent field and grid field ( e.g if you create invoice with order detail and when you save invoice the new invoice no increses auto and customer and order detail both are blank for new invoice) ...Show All

• Visual Studio Team System Problem with Areas and Iterations not being updated in work items

  After creating a new area or iteration, the new item does not appear in the area drop down used when creating a new work item in Visual Studio. I verified this behavior (create an area, but it is not visible at the work item level) is reproducible from Visual Studio, Excel and MS Project. I deleted my local cache (C:\Documents and Settings\<userid>\Local Settings\Application Data\Microsoft\Team Foundation\1.0\Cache), re-started Visual Studio, but no dice. When I expand the dimensions in the TFSWarehouse, the new area appears as a dimension. After some time (3 to 4 hours), the areas and iterations become available and are visible from the work item view. Why are areas and iterations not immediately available Some f ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Live??

  I think what you guy's at MS are doing is awesome. I think that MS is looking to make some money in the long run. I think what it is they are doing is looking to make money from this, more people will want to make there own games and the sales for the Xbox 360 will be even higher. It will also increase video game development. It will also increase future sales of console's too. Well I don't really care. ( 3 days to go till I can Download!!!!) I am just hapy I can finally create the perfect game for me. Will we be able to have like Xbox LIVE capability's If a game did get published Will that come in the corprate version From the FAQ : Q: Can I use the XNA Game Studio Express or XNA Framework to build a commercial Xbox 36 ...Show All

• SQL Server Call to Webservice from a Reporting Action in SSAS

  Is it possible to call a webserive from a reporting action in SSAS What I am trying to do is create a reporting action that will schedule a report to run at certain time by calling the CreateSubscription Web service of Reporting services. Any advice would be much appreciated. Does anyone have any suggestions or perhaps another angle that I could approach this problem Thanks Hi Teo, 1. I've checked my ExecutionLog Table. Here are the values for TimeDataRetrieval, TimeProcessing and TimeRendering (in Minutes): 19.37min, 12.33 min, 7.38 min. Byte count was 516277912 (492Mb) and Rowcount was 642703. If only 492 Mb are retrieved, I still don't understand why the memory consumption is so high (14 ...Show All

• Visual Studio Team System Creating Custom Control

  Hi, I am very keen to see the working of custom control. Thanks to Naren for a detailed explanation on how the custom control works. But I am facing issues here. Hope some body helps me here.. I have followed the following steps 1. Unzipped the sample in http://blogs.msdn.com/narend/archive/2006/10/02/How-to-use-Custom-Controls-in-Work-Item-Form.aspx to my working folder 2. Built the sample. 3. Copied the dll and the wicc file to C:\Documents and Settings\All Users\Application Data\Microsoft\ Team Foundation\Work Item Tracking\Custom Controls and also to C:\Documents and Settings\prash\Local Settings\Application Data\Microsoft\Team Foundation\Work Item Tracking\Custom Controls . 4. Now I wit imported the Bug-CustomControl.x ...Show All