BJHop's Q&A profile

• SQL Server Losing record after synchronizing subscriptions

  Hi We got a server running SQL server 2000 SP4 with a database that’s being replicated There are 17 subscribers running MSDE SP4 using merge replication. Replication is started manualy Initially we tested this with two subscriptions an everything went well, but now, since 3 months, we are facing a weird problem while sync'ing. We have massive data loss on records that where inserted at the subscribers. Records seem to disappear, but only record that have a foreign key constraint. What I mean is that for example a record is inserted at the table that holds our client records with primary key ‘ClientID’ and then a record is inserted in a table with actions for that client with a foreign key ‘ClientID’ referr ...Show All

• Windows Live Developer Forums Windows messenger live problems

  Hi, I have just upgraded to windows messenger live 8.0 build 8.0.0792.00. It connects and reconnects constantly by itself whenever its likes. I 've Only just resently started having this problem... it began with being unable to change display pictures.. then being unable to add contacts... then getting constant pop-ups of the same people wanting to add me. I have allowed messenger in the program control with Zone Alarm. It is a very frustrating problem. I thought it may be a virus but my anti virus found nothing. I also got an error code this morning 8100030d. Any help would be great. Thanks Hi Jose, I doubt this is the correct topic to reply to. Please either create a new topic next ...Show All

• Windows Forms Cross-container component connection

  Setup: Form F. Component X with property P of type component Y. Component Y. Form G. If I drop component X and component Y on form F, when I am in the property browser for component X and click on property P, a drop down list box allows me to choose the instance of component Y on form F to assign to property P. Excellent ! This is what design-time RAD programming is all about. Now let's suppose I want to put component Y, in a separate form G, as a public component, and remove component Y from form F. Now when I click property P of component X in Form F, there is no entry in the drop down list box for the property that lets me choose component Y on form G. Is there some way I can get the visual studio designer to see form G from form F so t ...Show All

• Visual Studio Express Editions Very urgent!!!! Creating .cpp file

  Hi, You cannot create C++ (.cpp) files using Microsoft Visual Basic 2005 Express Edition. You need to download Microsoft Visual C++ Express Edition which is available at http://msdn.microsoft.com/vstudio/express/visualc/ Regards, Amol. ...Show All

• Visual Studio Team System Performance Problem #2

  We've got a project with 3200 objects. The project contains about 10 errors. When we attempt to double-click on one of the errors to bring up the file, Visual Studio will hang for anywhere between 3 and 10 minutes. The Task Manager shows 'devenv.exe' consuming about 90% of CPU resources for this entire time. We're using the RTM version of DBPro. Amos. Me too, we also have performance problems which stall Visual Studio (or at least one thread in VS). So we are killing VS 3 to 4 times a day. Afterwards deleting the .dat file helps to get it up and running again. ...Show All

• SQL Server Creating Stored Procedures Based On Variables

  Hi There, I would like to know if for example i have some tables in my DataBase and i need from each table to get for instance, the Name by the ID, how can i make only one procedure which use parameters and variables so i can use this SP to get the Name By ID for all the Tables Thanks You would have to use dynamic SQL in the stored procedure. Assuming all you tables had a unique column named ID and an associated column named NAME, you could create a simple procedure like: Create Procedure GetNameByID( @tableName varchar(100), @ID int ) AS Begin Declare @sql nvarchar(1000) Set @sql = N'Select "NAME" From ' + @tableName + N' Where ID = ' + Convert( varchar(10), @ID ) ex ...Show All

• Visual Studio 2008 (Pre-release) Returning an array of types defined with a data contract.

  I have a method that looks like: ReturnType[] A(RequestType request) The ReturnType is defined in the data contract. I am not sure how to define a message contract for an array of types defined with data contract. I think that is why I am getting the following error: The operation 'A' could not be loaded because it has a parameter or return type of type System.ServiceModel.Channels.Message or a type that has MessageContractAttribute and other parameters of different types. When using System.ServiceModel.Channels.Message or types with MessageContractAttribute, the method must not use any other types of parameters. The request type (RequestType) is defined in the service contract with [MessageContract] etc. I think what I need ...Show All

• .NET Development Required To post XML data to SSL enabled Server IIS 5.0

  Hi, I have to post XML fILE TO A server IIS 5.0 which is SSL eanbled Following is the code that accpets the data posted to THE IIS 5.0 SSL enabled server using System; using System.Collections; using System.ComponentModel; using System.Data; using System.Drawing; using System.Web; using System.Web.SessionState; using System.Web.UI; using System.Web.UI.WebControls; using System.Web.UI.HtmlControls; using System.Text; using System.Configuration; // must add reference to project, not there by default! using System.Diagnostics; using System.IO; using System.Net; namespace WebApplication2 { public class WebForm1 : System.Web.UI.Page { ...Show All

• SQL Server Need script to loop through all non-system databases and drop all user schemas - Almost there

  Does anybody have any tsql code that will loop through all non-system databases on a SQL Server 2005 instance and drop all the user schemas in each database Thanks. you could get the DB's by using: select * from master . dbo . sysdatabases where dbid > 4 You could then loop through the objects with: SELECt CASE WHEN xtype = 'P' THEN 'DROP PROC ' + name WHEN xtype = 'U' THEN 'DROP TABLE ' + name END from sysobjects where xtype in( 'P' , 'U' ) Order by xtype , name Depending on the objects you could also add functions..views..etc ...Show All

• Windows Forms IMenuCommandService - Undo delete doesn't work...

  Hi, I have implemented an UndoEngine in my custom designer, and it works fine for operations such as moving, resizing etc. The problem is with undoing a delete command which was done using GlobalInvoke(StandardCommands.Delete).  I can see that the ComponentAdded event gets triggered by the IComponentChangeService but the control never reappears on the designersurface. I have all the required services (I think): ComponentSerializationService IDesignerSerializationService INameCreationService UndoEngine The undo is performed by calling the DoUndo() method from the hosting forms menu click event. Any help would be greatly appreciated. Here is my UndoEngine implementation:     internal class M ...Show All

• Software Development for Windows Vista Visual Studio 6.0 SP5 setup on Vista Beta 2 (5384)?

  Does anyone know how to get around the MDAC check in the Service Pack 5 setup of Visual Studio 6.0 For some reason it doesn't detect MDAC 2.5 or higher which it requires (even though Vista obviously has a later version - 6.0) and the setup will not continue from that point. I've tried every registry key I could think of to trick it into thinking MDAC is installed. Thanks Ted. Cheers....have it running now...got round it in a different way....copied entire visual studio 6 folder from xp and altered registry HKEY_Local_Machine\SOFTWARE\Microsoft\VisualStudio\6 from destination C: to X: where I have Vista....Had to install MDAC sp7 to get Access to work ...Show All

• SQL Server Differences between mined data and queried data : Association rule

  Dear all, I have a table containing call records, and made a mining model from that table only. The model has 3 columns : calling_number, called_number, and target_operator, using Association Rule algorithm. The key is calling_number, input was operator, and predicted column called_number. The result shows no rule, but there are results with item-set size of 1 (column) and 2 (column). On the top record of the result, SQL Server says there are 1891 support for called_number = 1891 and operator = 'INDOSAT'. I queried the table with this query SELECT DISTINCT calling_number FROM call_records WHERE called_number = '07786000815' AND target_operator = 'INDOSAT'; It returns 2162 records instead of 1891. If I removed the DISTINCT qualifier, SQL S ...Show All

• SQL Server Uselesss Error Calling SSIS from Reporting services

  I'm trying to call an SSIS package from Reporting Services and I get the follwing error. Has anyone seen this before An error occurred while executing the query. The package failed to execute. (Microsoft Report Designer) I'm following the instruction from Microsoft defined at the following link: Defining Report Datasets for Package Data from SQL Server Integration Services Thanks, Greg van Mullem ...Show All

• Windows Forms Error when trying to do form 'functions' through self-compiled dll

  When I use a .net framework compiled dll (compiled through code), it recieves this error, when I try to do basic form functions like myform.Show();, and stuff like that, I get this error when I do that. The only references i have in the dll, are System;, System.Windows.Forms; Is there one I am missing Line number 14, Error Number: CS0012, 'The type 'System.ComponentModel.Component' is defined in an assembly that is not referenced. You must add a reference to assembly 'System, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089'.; Line number 14, Error Number: CS0012, 'The type 'System.ComponentModel.ISynchronizeInvoke' is defined in an assembly that is not referenced. You must add a reference to assembly 'System, ...Show All

• Smart Device Development How to set app to be always in foreground?

  My app should be the only interface for the user, since the phone is used as a watchdog device. How can i make sure, that it stays always in the foreground Only after hitting a special sequence of keys the app should terminate. Any idea how to implement this with SmartPhone 2003 Thanks Hans Unfortunately there is no easy way to this. If you want your application to be a proprietary application on the device - then you "should have used Windows CE" (quotes from one of Microsoft Developers at MCDE'2006). There you can replace shell with your application, and nobody will be able to exit it. But if you're stuck with PPC2003 or Windows Mobile 5 (as myself :)), then you got yourself a ...Show All