Umesh_DB2's Q&A profile

• Visual Studio Team System Making all the fields in work item read only.

  Hi, In my work item I have a field "Status" whihc decides the status of the "Defect" work item. When the value of "Status" is closed, I want the work item to be read only. Hence I have put the following conditions for all the fields in my work item including the "Status" control. < WHEN field = "Defect. Status " value = " Close " > < READONLY /> </ WHEN > But when I set the value of "Status" as "Close" the fields does not become read only. Catch here is, if I remove the above condition for "Status" field, all the fields except "Status" field become read only. Is there some kind of cyclic action happenin ...Show All

• SQL Server changing "header rows to skip" property in flat file connection during runtime

  Hi all I have a flat file.I am trying to set the value for the property " HeaderRowsToSkip " during runtime.I have set an expression for this in my "flat file connection manager". But this is not working.The connection manager is not able to take the value during runtime . My expression is as follows: DataRowsToSkip : @[user:: Var] where " Var " is my variable which gets the value from the rowcount component and trying to set it back to the "HeaderRowsToskip" property. I ve even tried setting the value to the " HeaderRowsToSkip " property in the expression builder. Its not working.... Can anyone help me out in solving this Thanks in advance Regards Suganya ...Show All

• SQL Server SQLCMD - Copy all procedures & code

  Hi All, Our Management studio for sql2005 is damaged and we only have way to copy through SQLCMD - command line. Please can any one provide me the script to copy all the user defined Procedure , Functions & Triggers code from database. Thanks in advance HI, Please can you provide me an example how to use SQLCMD with -y option.I want to get following procedure complete code from sql_model I try declare it does not work C:\>sqlcmd 1>use acco 2>  DECLARE @myVariable varchar(500) 3> SELECT definition is @myVariable FROM sys.sql_modul 4>  WHERE object_id = OBJECT_ID('PLocation'); 5> go Msg 156, Level 15, State 1, Server textserver Lin Incorrect syntax near the keyword 'is'. SQL ...Show All

• SQL Server Remote command call of DTEXEC gives "insufficient for component"

  We have schedule process server, calling SSIS package via command line (see below) to physical SSIS server. Get message "insufficient for component" and package call bombs. Facts: 1. schedule process server has Workstation tools / Clients / Connectivity for SSIS loaded 2. SSIS is 2005, SP1 What are we missing c:>dtexec /DTS "\File System\SalesDW\gyp_dm_carrier" /SERVER BPATLQDDW /CONFIGFILE " \\bpatlqddw\d$\SSIS\SalesDW\gypdm.dtsconfig " /MAXCONCURRENT " -1 " /CHECKPOINTING OFF /REPORTING V Error: 2006-11-09 10:43:34.94 Code: 0xC00470FE Source: DTF - Xfer DW to DM DIM_CARRIER DTS.Pipeline Description: The product level is insufficient for component "Slowly Cha ...Show All

• SQL Server How to add a trend line, equation and r-squred value to (XY) scatter chart using SQL Reporting Service 2005?

  I had no problem to add a trend line, equation and r-squred value in Excel. But couldn't find the same functionalities in SQL reporting service 2005. Any helps would be appreciated. Thanks. Kelly ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. ModelMesh / BasicEffect rendering order

  Hello all, I've been doing some standard 3d stuff with XNA, and I found an odd problem of some sort. Whenever I draw 2d sprites after my 3d rendering code, the model I am loading seems to be displayed in the wrong order. I've been using one of the spacewar ships like the documentation suggests. And I'm using the Font class (spacewar) to draw the sprites. I have removed alphablending for the sprites, no luck Changed the drawing order (before and after the 3d scene) Still can't figure out the problem though, any of you know Thanks! Rendering sprites also disables the depth buffer, so this might be the reason your mesh looks wrong. The easiest solution is to tell the spritebatch to preserve th ...Show All

• Software Development for Windows Vista reference System.Workflow

  hi all, i'm doing a sample workflow project, where i want to access a hello-world workflow project in a windows form project. so i added a reference to the hello-world project in the windows form project, but that failed because i need to add a reference to System.Workflow.Activities, System.Workflow.ComponentModel, System.Workflow.Runtime... but i cant do that they dont exist in the .net tab in the add-Reference window. i also tried referencing them through adding a reference path to C:\Windows\assembly, but still no difference. i also tried adding them through browsing from the reference window, but still they dont get added... i'm clueless! thanks :) never mind i figured it out, thanks anyways :) i refe ...Show All

• Visual C# Trouble with pointers

  Hello, I am currently trying to solve a problem and I'm running into trouble assigning a pointer to a class. To simplify things, my code is setup something like the following: class base_object { public string name; ... } class object_manager { public ArrayList objects = new ArrayList(); unsafe public static void add(string file, ref Hashtable hash) { // do file related stuff here... base_object obj = new base_object(); base_object val = (base_object)hash[key]; base_object* ptr = &val; objects.add(ptr); } } class form { Hashtable my_hashtable = new Hashtable(); void Main () { object_manager.add(the_file, ref my_hashtable); } } The basic premise is that I need to store an arr ...Show All

• Software Development for Windows Vista Single-instance DCOM server problems with high/low integrity levels

  I am working on an application that employs a single-instance DCOM server. The application works fine on all other versions of Windows except Vista. There is a strange behavior that I observe on Vista in regards of the instantiation of the singleton COM interface if there is a difference between integrity levels of the server and client applications. The single instance is accomplished by having the singleton interfaces declared with DECLARE_CLASSFACTORY_SINGLETON ATL macro. Additionally, there is a code in the application that ensures only one instance of application is running by utilizing a named mutex. The application checks if the mutex exists, exits if it does and stays running otherwise. The scenario of the problem I pbserve is the ...Show All

• Visual Studio installation of VS.NET 2005

  Can I install visual studio 2003 and and visualstudio 2005 on the same machine if so isthere any problem while running ASP.NET websites which onw shoulds install first pls ans me. yes you can install them side by side without any problems. The only thing you will need to do when creating/running ASP.NET applications is to set the .NET Framework version to run in the IIS manager/settings. Thats all :-) ...Show All

• Internet Explorer Development Protecting/Backing Up Internet Explorer History File

  In an age where it seems like everyone is wanting to ERASE their internet history files, I am seeking to back them up to another file name, or preserve them in some way against arbitrary erasure. My children are inquisitive and sometimes visit inappropriate web sites. They are aged 12 and 15, and both have been computer literate since about age 3 or so, and especially since they learned to read at age 4 or so have become (as you could imagine) quite instinctive about computers and their many uses and possibilities on the internet. With this comes the natural curiosity of a child, visiting inappropriate sites, downloading adware, and the problem that they have learned how to cover their tracks in Explorer, by erasing either the entire histo ...Show All

• SQL Server Adding Entity after model creation

  I'm woundering if and how it is possible to add a entity to a report model that is directly associated with a database table after the model has already been created Thanks for the help if there is any. You will need to refresh the Data Source View (.dsv) first to pull in the schema for your new table. You can then right-click on the root node in the Model Designer and choose New->Entity. Set the Binding property of the new entity to the new table. ...Show All

• Visual Basic Async Timeout when Accessing a Webservice

  I am writing a VB2005 client application that consumes a Webservice. Certain web methods take a long time to complete and the call times out prior to receiving the callback. I have poured over the documentation but I cannot seem to find the answer to what should be a very simple question. How do you set the Async Timout when accessing a Webservice The WebClientProtocol class has a Timeout property but that only works for Sync calls. Any information would be greatly appreciated. I'm not sure how, or if, you can do this in .NET 1.1 (VS 03), but in 2.0 (VS 05) you can just set: My.WebServices.ServiceName.Timeout I searched a little too and didn't find anything helpful for windows app references in 1.1. ...Show All

• Visual C# Process Module

  Hi, I have an application which lists all the running processes of the machine and i need to get the full path from which the process is running. I am trying to use the following methods : Process.MainModule.Filename Process.MainModule.ModuleName The above code doesn't work it throws an exception "Unable to enumerate the process modules" any thoughts Regards Alan Hi Kaiser28, I guess this is a security issue. Make sure that you: - run the app with full trust - test the app as local admin // you might need debugging privileges to access other processes - run as admin if running in Vista with UAC enabled There might still be situ ...Show All

• SQL Server Conditional Send Mail Task

  Hi, I want send email if certain conditions are met (by send mail task)... if compnay records does not exists in some table (returns null)... not task failure.... how do I achieve this without using Script task   does any one have an idea about it,   regards that's what i was thinking... but i m searching for other way (may be the easiest way) BTW... thanx for your support if ne one come across to ne better idea than that please let me know ...Show All