thomaskremmel's Q&A profile

• SQL Server Weird conflicts - Merge Replication 2005 -> 2000

  Publisher is 2005 x64, subscribers SS2000 (SP3) and SS2005 x64. Pull agents, no filters on subscriptions. We are seeing many seemingly random conflicts on between SS2000 subscriber and publisher. It happens on several different tables. One table is never editted, only inserts happening everywhere and deletes happening on the SS2000 subscriber. Deletes will sometimes generate conflict. Reason is '"he row was deleted at 'CTS11.CTS' but could not be deleted at 'cts4a.cts'. Unable to synchronize the row because the row was updated by a different process outside of replication." CTS11 is SS2000 subscriber, CTS4A is publisher. Probably unrelated bug but when looking at conflicts on this same table in SS2005 conflict viewer, get e ...Show All

• Windows Forms How can make one cells value changed with other cell value same time in DataGridView ?

  In DataGridView control , there are more than 3 cell in a row, like int i = invoiceDetailsDataGridView.CurrentCell.RowIndex; DataGridViewRow row = invoiceDetailsDataGridView.Rows ; row.Cells .Value = Convert.ToInt32(row.Cells[3].Value) * Convert.ToDecimal(row.Cells[4].Value) - Convert.ToDecimal(row.Cells[5].Value); how can i make the Cell .value changed with the Cell[3].value changing same time i can make Cell .value changed by leave the current cell (Cell[3]) and click other cell of the DataGridView. I want all the values changed at same time with out exit the current editing. I searched many times in this forum, but didn't find any advice worked. I tried a lot events of DataGridView to make ...Show All

• Visual Studio Express Editions Separating Combined Columns

  I have two columns in a data table, First_Name and Last_Name. I also have a column called Player, that combines the First_Name and Last_Name, separated by a comma. On some forms, I need to use the First_Name and Last_Name, on others I need to use the Player (such as in ComboBoxes). On one form, there is a ComboBox that uses the Player column. Is there a way for me to take that control and reverse the joining of the First_Name and Last_Name so I can place the values in those columns if I need to use those on a form Another way to put it is that if I have the following: First_Name: John Last_Name: Doe Then Player = Doe, John But, if I create a record using a ComboBox that is set to Player, how can I get: Player = Doe, John to: ...Show All

• Visual Studio Express Editions prevent multiples instances of application

  How can I avoid users being able to open multiple instances of an app if it is already open Would appreciate if someone could point me to a code sample. Thanks ! you can also use the Process class to get a list of processes running of your assembly and if more than 1 exists (1 being your current app process) then you know there is another one running. Example: using System.Diagnostics; .. .. Process[] theRunningProcs = Process.GetProcessesByName(Application.ProductName); if (theRunningProcs > 1) { MessageBox.Show("you already have another instance running"); } ...Show All

• .NET Development Error while trying insert values into a database table. Help!

  I keep getting an error that says Incorrect syntax near ','. When I try to insert values into a database table. Here's the code: =================================================================== using System; using System.IO; using System.Data; using System.Data.SqlClient; using System.Collections.Generic; using System.Text; public class MemberFileReader { private MemberFileReader() { } public static void ParsePositional(string FileName) { String strSQLInsert = "INSERT INTO Members VALUES(" + tempCType+ "," +tempNRDS+ "," +tempLastName+ "," + tempFirstName+ "," +tempMiddleName+ ",&quo ...Show All

• SQL Server shrink my backup device

  does this Delete/Remove DATABASE ***** FROM backupdevice WITH FILE = 1(2,3) can working thanks check this it may help you http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=889290&SiteID=1 ...Show All

• SQL Server Indexing error in fulltext catalog

  Hello, I have found some errors in our fulltext catalog indexing file. The SQL Server ist : Microsoft SQL Server 2005 - 9.00.2047.00 (Intel X86) Apr 14 2006 01:12:25 Copyright (c) 1988-2005 Microsoft Corporation Express Edition with Advanced Services on Windows NT 5.1 (Build 2600: Service Pack 2) .. and the errors encountered are: 2007-01-10 08:43:49.97 spid21s Error '0x80043651: msftesql muss dieses Dokument noch einmal isoliert verarbeiten, um den Fehler zu bestatigen.' occurred during full-text index population for table or indexed view '[P2PlusADLocal].[dbo].[Besuchsberichte]' (table or indexed view ID '2080726465', database ID '7'), full-text key value 0x013DA082. Attempt will be made to reindex it. 2007-01-10 08:43:49.9 ...Show All

• Software Development for Windows Vista Workflow VB.Net examples: interfaces and local service

  Does anyone know where I could find some example in VB.NET that use Windows Workflow (not C#) Specifically, I'm looking for code that shows how to implement an interface needed to define the contract between a workflow and service and local communications between the host and workflow. If you are looking for ASP.NET examples in VB.NET look at the persistence and tracking sample found here . ...Show All

• SQL Server Matrix doubt!

  Hi! I have a query that returns the productivity of a project during a period, and other that gives me which employees where working on the project at the period. I can't tell how much each employee producted, all I can say is that one employee worked on the project on that period. When I join both queries I obviously get repeated rows: Proj1 Employee1 1000 Proj1 Employee2 1000 Proj1 Employee3 1000 But I would like to have both information on the same matrix like this: Project Employees Total Project Productivity Proj1 Employee1 1000 Employee2 Employee3 I mean, I don't want the total project productivity to appear once for each employee. I also tryed to change the order, putting the em ...Show All

• Windows Forms Update the registry during install

  Hi, i would like to copy the Install path directory the user types during setup into a registry key. Any suggestions Thanks! Francesc Phil, thank you very much. That took care of it. I've been brosing other threads and i have not found documentation on how to do this basic stuff. Can you point me to a good blog or forum or whatever where i can teach myself Francesc ...Show All

• SQL Server Cubes and dimensions disappear random

  Hi, Since today cubes and dimensions disappear random at our customers site. Without any pointable reason the cubes and dimensions will be deleted from the cubes and dimensions folder within the analysis services database. We have double checked no one removes the cubes or dimensions. After restoring the backup file the database will run for several minutes/hours and then for some reason the cubes and dimensions disappear. We are running sql 2005 standard with SP 1. Anyone knows how we can trace the events or track what happened We have restored the as database multiple times (untill now 5 times) and the problem still keeps returning. No settings have changed and we are running the AS database for about one week from now. I have checked ...Show All

• Visual Studio Express Editions Invalid Email address--fail to register

  When registered, I was keeping get this error message: Invalid email address I have provided my hotmail address, like XXX@hotmail.com , What's wrong with that Please help me too! i know my email is valid because microsoft has sent me emails confirming setup of my passport account. i also tried it at the school i work at with a different email and got the same result. looks like a microsoft foul up to me. ...Show All

• .NET Development download a file from http -file type

  Is there any limition on the file type that can be download from http My program can download a doc, pdf, txt, html file from http. However, for some extension such as dwg, it will return a 404 error(file not found). Anybody know why And what I should use to download other type files. Ying ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. new project help

  I am having a problem creating a new project, every time I try it says. "The filename, directory name, or volume label syntax is incorrect. (Exception from HRESULT: 0x8007007B)" I can't get anything to work or start. I am running Windows XP Media Center intel celeron processor 2GHZ, 768 megs of ram. Thanks There are a few bits of information that would be useful to try and diagnose what's going on: What drive is your OS on What drive are your Program Files on What was the name of the project and the full path ...Show All

• Visual Studio Team System How compare two databases and script changes?

  Hi.. am new to VSTDP. I want to compare our test database to that in production to see all the new things that are about to go in. Then, I would like to somehow generate a scrip to run against production to bring it up-to-date with the test database. Can VSTDP do this Can someone tell me how Thanks, Ron For more information, you might check the online documentation here: http://msdn2.microsoft.com/en-us/library/aa833198(VS.80).aspx ...Show All