dna2's Q&A profile

• Visual Studio Team System Scenarios to use Triage Field for Work Item type like bug, Issues etc.

  How can I use the field Triage for work item like bug. Please explain the scnerios in which Triage field holds following values: Info Recv More Info Pending Triaged How this field takes above values for work item - Bug. Triaging bugs refers to the process of assessing the severity, priority, risk and effort to fix of a bug. This field is designed to track the state of that decision process. I'd interpret them as follows: Pending - means the bug is waiting for a decision on whether or not to fix it. More Info - means you need more info to make a decision. The owner of the bug is supposed to provide the addition ...Show All

• SQL Server SQL 2005 Enterprise June CTP Installation Error

  Tried to install several times (on Win2003 Ent. SP1) but I always get the following error: Failure adding user NT AUTHORITY\NETWORK SERVICE to local group SQLServer2005MSSQLServerADHelperUser (1388) The user varies (sometimes NT AUTHORITY\SYSTEM) and so does the local group (sometimes SQLServer2005SQLBrowserUser). Any tips Regards Roger I have tried to install SQLDEV ,But got the same error mesage. ...Show All

• Visual Studio Two Page Report

  Hi, I currently have a report that has 2-pages. The report is fixed-size, that its always a 2-page report. So my question here is, how to create another page in Crystal Reports Is it even possible BTW, each page displays different sets of data...       cheers, Paul June A. Domag Hello Paul, I don't think that I understand what you are trying to accomplish.  How is the report a fixed-size Crystal Reports uses the detail section to drive most reports and the size is often related to the amount of data or number of records you are reporting off of.  Obviously there are a number of things that you can d ...Show All

• Visual Studio Team System 'Display Name' changes in Active Directory breaking WorkItems

  A user in my company recently changed his 'Display Name' in Active Directory and now we can't edit any work item activated by him before the name change. The error VSTS shows is the following: TF20015: The field 'Activated By' contains a value that is not in the list of supported values. We can't edit this field neither from VSTS nor from Excel because it's read only. Looking into the TFS databases, I found that the following fields store the old Dislpay Name: In the tables [TFSWorkItemTracking].[WorkItesLatest], [TFSWorkItemTracking].[WorkItesAre] and [TFSWorkItemTracking].[WorkItesWere]: [Assigned To] [Created By] [Change ...Show All

• SQL Server sql server express loses ability to write to database

  After a period of use (typically 1-2 hours), an application using SQL Server Express stops writing to the database, whilst still continuing to read from it. As far as I can tell, no error message is generated by any operation. The application is written in VB Express and is executed on several machines, with SQL Server Express on a central machine. Re-starting the application on the affected machine restores normal operation. The problem on one machine does not cause a similar problem elsewhere at the same time (hence it appears to be an issue with the relationship between the application and SQL Server) This does not appear to ...Show All

• SQL Server Advice needed for connection to DB2

  I am writing a report in RS and my query is supposed to pull transactional records from a certain date (yesterday). The table I am querying contains roughly 1.5 million records. This is on an AS400 dB2 system. Mostly I use ODBC with no problems, however this query ran for about two hours and was still running before I killed it. I am thinking of using SSIS to copy the records into SQL. If I go this approach (which should be much faster), is there a way to just copy over differential records each day Or does anybody have any other suggestions What is Linking a Server Thanks for the information. I am using SQL 2005 ...Show All

• Visual Studio Express Editions Deploying VB 2005 applications easily?

  Hello folks, I've written some VB Express 2005 applications and I'm looking for the best way/method of deploying them. Many of the machines I'm running these applications on do not have internet access and thus, do not have .net 2.0. Is there a way I can re-compile these programs in c++ express 2005 to relieve this requirement, or can I include ALL of the dependencies on a CD Thanks! Hi. This has all been covered in another post. Search for (Publish Can't Find Redist Files.) That Post will tell you How to put the redistributable file in the bootstrapper packages. You can also clear the check box for m ...Show All

• .NET Development can you programatically change a WebReference at run time?

  Is it possible to programatically change where a web service points to at run-time i.e. I have a Webreference pointing to "http://localhost/MAS/xfer/xfer.asmx", can I change this to e.g. "http://localhost/MAS/xfer/xfer_NEW.asmx" with a setting read in from a INI file thanks Hi! Just make it dynamic, not static. In Solution Explorer select reference and go to the Properties. Actual service address will be stored in app.config. ...Show All

• Visual Basic VBA and Outlook 2003 access

    I've written 3 versions of a VB program: one from VB 6.0 pro as an .exe, one from outlook 2003's vb inside of outlook, and one from vb 6.0 pro as an add in dll.  What I want them to do is to read incoming mail, and either move the new mail to a folder, or email it to another inbox on our network.  All of them work, but all of them force 2 errors: "a program is trying to access e-mail addresses you have stored in outlook, do you want to allow this", this one is strange as I'm not reading the addressbook, just the incoming emails.  The other error is:"a program is trying to automatically send e-mail on your behalf, d ...Show All

• SQL Server SQL Server Project - Failed to connect to databse...

  Hi! I installed SQL Server on my server today and im new to it. I configured it and now im trying to make a SQL Server Project with my other computer... Then the program asks for some account information to logon to a database on the server. Then i fill it out and i get this error: Login failed for user "anaxyd". The user is not associated with a trusted SQL Server connection. Do i need to join the domain that the server is in Or is it something with my account at the server I have created a account at the server management studio in my server: MAINSERVER\Security\logins\anaxyd. Whats wrong You can look at the CREATE LOGIN and CREATE U ...Show All

• Visual C# Getting rid of excel.exe from memory

  I use excel interop to load in data from excel file. After the loading is done, I call myExcelInstance.Quit(). But in task manager I can still see an EXCEL.EXE for each file I opened, eating up a fair bit of memory. These instances don't go away until I close my application. What am I doing wrong ~S You can try to decrements the reference count of the runtime callable wrapper with the Marshal.ReleaseComObject method. Marshal.ReleaseComObject( myExcellInstance ); myExcellInstance = null ; You should release all your COM object like the _Workbook and/or _Worksheet objects. ...Show All

• Visual C++ How to initialize an independent display using CreateDC

  I am trying to initialise a second display as an independent display on my machine using:    CreateDC("\\\\.\\DISPLAY2", NULL, NULL, &demode); but I keep getting error code 0x709. The "\\\\.\\DISPLAY2" is the string returned from EnumDisplayDevices The devmode structure has been initiailised with basic information about the display (height, width, freq, color depth) which I know works with ChangeDisplaySettings if I extend the desktop onto the second display. The error code is described as "The printer name is invalid. " in visual studio. I can get everything to work fine if the Windows desktop is extended onto the sec ...Show All

• SQL Server Crash recovery: Attaching database without prior proper detach

  Hello, I have two harddrives on my system. The Primary one runs SQL2005 software, the secondary has all the DATA. The primary drive has died. I bought a new drive and installed SQL sofware. Now I want to attach databases from the secondary drive. Note: I did not detach them when primary drive crashed. What would be the safest way to connect them to the new server I don't have backups. Thank you! P.S. Sorry for the duplicate post which I made to the SSIS thread Hello, Just use sp_attach_db and pass in the data and log file(s). Refer to BOL for a full guide. Cheers Rob ...Show All

• Visual Studio Express Editions AccessDataSource Where date = today?

  Hi, I'm want to query a table in an Access DB where the Date field is = today's date, so that in a datagrid I can return values that were entered today only. I'm not using connection strings, I'm using the AccessDataSource function on new Web Developer 2005, and trying to configure theWHERE clause in the select statement to today's date. Any ideas hi, in other forum they said its not good to use string format in query, its better to use parameters and they have examples for that http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=250908&SiteID=1 Hope this helps ...Show All

• Visual Studio Team System Available Control Types for Work Item fields

  Hi Guys! Where can I find list of available Control Types for Work Item Forms In samples there are FieldControl, HTMLFieldControl, LinksControl, AttachmentsControl, WorkItemLogControl, ExtendedComboBox. Are there any more What about checkbox, label Is there some kind of SimpleComboBox in contrast to ExtendedComboBox Can anybody clarify Thanks, Leon Hi David, Unfortunately this feature was cut just after documentation. For version 1, we support only built in types in my response above. We might add this feature in future versions. Thanks Naren ...Show All