AmitKGupta's Q&A profile

• SQL Server Merge Replication / Metadata Cleanup / Help!

  At a client site we just had a customer away on holidays, came back and went to replicate and received the error. I understand why this would happen after the default 14 days, and the obvious fix to prevent it from happening in the future is to extend the period, however I am hoping someone can offer me assistance on the best way to correct the issue now Error is: The Merge Agent failed after detecting that retention-based metadata cleanup has deleted metadata at the Publisher for changes not yet sent to the Subscriber. You must reinitialize the subscription (without upload). The problem is we cannot lose the data that has been entered on this machine since the last replication. Writing scripts to manually save and pump this d ...Show All

• .NET Development Referencing Assemblies Through Code

  How can I reference an assembly through my code, I don't think it can be part of a project, this is related to my previous thread about 3 days ago, but I prefer to keep different questions in different threads. Anyways, Upon running my game, it will build a .exe, from the contents of a .cfg file, I need the .exe that it outputs, to be able to reference my main Game, I need it to be able to change variables and stuff, they are mostly all set to public and what not... Predator14567 wrote: How can I reference an assembly through my code, I don't think it can be part of a project, this is related to my previous thread about 3 days ago, but I prefer to keep different questions in different threads. Anyway ...Show All

• SQL Server Access denied for network drive

  Sql server prompts "access denied" while firing the following query EXEC master..xp_cmdshell 'dir \\servername\sharedfolder\ *.* ' how to access the folders and files existing in network drive. One place to check that is in control panel, services, the SQL Server service. See if it is started using a 'regular windows account' or the Local System account. If it's Local System, then SQL Server service is restricted to the server, no remote access at all. If it's a 'normal' account, then grant this account privileges on the remote share, and it should work. ...at least, this is how it used to work =;o) /Kenneth ...Show All

• .NET Development Serialport freezes

  Hello, i'm developing app which reads incoming data from GPS receiver via serial port. The problem is that app freezes sometimes, even in Visual Studio IDE, when i attempt to close the app. Thank you for any kind hint. Thank you Roggan for your respose. Yes, i'm updating controls via if (this.InvokeRequired) Invoke(...) construction. That seems to work correct. Any other idea, please ...Show All

• Windows Forms Binding text box fields to combo box selected value

  I have a small C# windows application with few text boxes and a combo box. I need to bind text fields to the value selected in the combo box, it works fine for the first selection but when I try to select another another item during the same session it gives me an error: "This causes two bindings in the collection to bind to the same property. Parameter name binding" . I think I need to bind the text boxes to may be the selected index change event of the combo box, but I am unable to implement that correctly. private void cmbEmployeeList_SelectedIndexChanged( object sender, EventArgs e) { txtFirstName.DataBindings.Add( "Text" , objDSEmpTrkSys, "EmployeeInformation.FIRSTNAME" ); txtLastNa ...Show All

• SQL Server Transactional Push Distribution Agent Slow

  We have quite a lot of Transactional replication, and over the past few weeks it had become quite slow. I spent the last few days trying to resolve the problem and found that a Push subscription was delivering transactions at about 50/sec and a Pull subscription was delivering at around 700/sec. This test was run on the Same publication, same subscriber so hardware and links are all the same, the only difference was the type of subscription. I've since changed a few of our subscriptions for the larger publications and have found they run quicker than previously. Has anyone else seen this behavour and is there a valid reason why this would occur. The distributor and subscriber are both running SQL2005 SP1 and the publisher is SQL2000 ...Show All

• SQL Server Cube design question

  I have a Fact table which stores details about each revision made on the document. There is a one to many relationship between a document and the revisions I need to display information based on the last revision made by a particular UserType. How do I select records from the fact table based on a particular UserType and the maximum revision number for that usertype There are a few ways you could do this, but here's one suggestion. Its a very simple pattern which csn be used again and again for similar problems. You have a table or view with the time taken and target time in as columns. Add another column (this is easier if you have a view) and define it as: case when TimeTaken>TargetTime then 0 else 1 end as ...Show All

• Visual Studio Team System TF80070 Error in Microsoft Project

  We are using Team Foundation Server Workgroup edition. I open up Microsoft Project and 'Choose Team Project'. Then I can 'Get Work Items' into the project, but it throws the error below before all of the work items are rendered (but they all show up after I hit OK). Also I can't 'Publish' or 'Refresh' the Work Items from Project. When I try, I get the following error: "TF80070: Team Foundation encoutered an error while performing the operation. It is recommended that you save your work and restart the application." Any help/ideas would be greatly appreciated. I opened All Work Items in Microsoft Project from Visual Studio. Made a change in Visual Studio to a Work Item, r ...Show All

• Visual FoxPro Some thing like edit box with picture control support???

  Hi there experts. How can I make a control like editbox where can I type in and phrases like ":)" will automatically change into o graphical picture(best will be gif file). I mean something like. Or is there an control which can do it without creating a difficult code Thanks in an advice . Bye I see... Is there another control like editbox, that support displaying animated gif files Maybe a paid control from internet I was looking for some controls but unsuccessfuly... :( ...Show All

• SQL Server Question on Internal Activiation

  Hi Could it be assumed that a stored procedure, activated internally by Service Broker, is executed under the same environmental variables (resource allocation specifically) than when that same stored procedure is executed via an EXEC statement from a non-Service Broker procedure When I have 10 of these procedures running (somewhat concurrently) overall performance is not even close as to when I let Service Broker activate the procedure via 10 messages on the queue. If all variables are equal than I am not sure why this is. Or is it possible that everything is not equal Thanks Paul By "external activation" are you referring to the external activation mechansim for Service Broker applications ( ...Show All

• .NET Development Problem: 64-bit MFC C++ DLL calling 32-bit C# class library through COM

  Hi, I have a MFC C++ DLL that communicates, through COM, with a C# class library. I'm devlopping under WinXP 64-bit edition, VS2005 Team Suite, and as long as both projects are compiled as win32/x86 apps, everything works fine! The problem appears when I compile the MFC C++ DLL as x64 app, while still compiling the C# class library as x86 app (reason: this class library uses 32-bit only dlls). When I try to create the C# class library as a COM instance, I get a " 0x80040154 Class not registered " error. I know that 32-bit components are registered in HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\Classes\ and my C# class library is there. So, is it really a registration problem, or it's something else I know that 32 and 64-bit DLL are not compat ...Show All

• Visual Studio difference betwwen ReportViewer and CrystalReport

  hi forum what is difference between ReportViewer Report (VS 2005 Control) and CrystalReport. Can we Create ReportViewer Report From Access and Also explain Adantage of ReportViewer Report. Hi Rastogi. The main difference is that the ReportViewer is used to display reporting services reports. The CrystalReportViewer control is used to display Crystal reports. You should choose the report viewer control that corresponds to the file type that you want to display. If you are using Crystal reports, you should use the CrystalReportViewer control. - Dave ...Show All

• Smart Device Development Stack Overflow Exception

  hi all, I am the error of stack overflow exception. I m redrawing the list items according to the changes in the scrollbar. if scroll again and again then it gives me the error of stackoverflow exception. Please help. wht can b the reason for this exception.plz help. thanx. Maybe you want to change value in scroll control's ValueChanged event handler. two ways: 1.stop occur ValueChanged event before change scroll value this.vscroll.ValueChanged -= new EventHandler(vscroll_ValueChanged); this.vscroll.Value = yourvalue; this.vscroll.ValueChanged += new EventHandler(vscroll_ValueChanged); 2.Change your idea for resolve this question ...Show All

• Visual Studio Express Editions LINK : fatal error LNK1104: cannot open file 'user32.lib'.

  Hello,   I've tried everything to get ANY program to work and they won't. Not even "Hello World" or code copied directly from help.   Always the same:   LINK : fatal error LNK1104: cannot open file 'user32.lib'.   I've read all the suggestions here, followed all the directions including from the websites:     1. Uninstall beta versions   Before installing, you must uninstall any previous versions of SQL Server 2005, Visual Studio 2005, and the .NET Framework 2.0 (this includes Tech Preview, Beta, or CTP versions).   2. Download and install Visual C++ 2005 Express Edition!!   3. Register   4. ...Show All

• Internet Explorer Development IE7 Problems with Active-X

  IE 7 is a great creation by microsoft but still contains a lo of bugs. I've been having a problem from the begining. I've been unable to view FLASH files in web pages (flash and webpage hosted in different servers) or when I'm able to see it, the IE gets partially hanged after loading the page. I've been havin prob especially with my profile: http://xsumitx.hi5.com Can anyone tell me what to do. The page works aweome in IE6 and Firefox Thanx All of my problems began with You Tube after I viewed videos the first time there. Nearly every web site I go to now has formatting(scripting) issues, maybe Java, maybe ActiveX. I'm ready to blow up my machine and F disk this thing just so I can read the NYT o ...Show All