Nishith Shah's Q&A profile

• SQL Server Including Views in Replication

  I have a three server peer-to-peer replication setup that includes articles for tables and views. As I understand the BOL, scheme changes -- which I take to mean changes, amont other things, changes in the design of a table or view -- should automatically replicate to the other servers in the topology. Here are my quesitons: When including a view as part of the publication, what is it, exactly, that is getting replicated If all the tables supporting a given view are being replicated, and the view exists on all three boxes, whatelse, besides the view schema (and changes thereto) is being replicated Secondly, if in fact schema changes are replicated, why can't I modify a view that is part of a publication When I try to make a change t ...Show All

• Visual Studio Express Editions Deactivated form

  I am using a standard form application which contains a number of buttons. When the form is deactivated I am able to move the mouse over the buttons and the outside of them changes to show the mouse position within there area. The problem is, when I do the first mouse click, the form activates but the button does not action. A second click is required. On most other application within windows, the first click not only activates the form but triggers the option selected. How do I get my application to duplicate this action. Thanks in advance What you describe is consistent with mouse capture being in effect. You can turn it off with the Control.Capture property or by calling ReleaseCapture() with this P/In ...Show All

• Visual Studio Express Editions activating a file on a remote computer

  how can i activate a file on a remote computer inside a lan connection i dont want the users to be administrators on this computer, instead i would like to insert the administrator user and password to the code. (the idea is to restart an application from a remote computer by any user who uses this program) ok thank you i have only one problem my visual studio (2005) does'nt know the Connectionoptins type how can it be ...Show All

• SQL Server Help with SQL Update statement

  Hi I have fields in one table I need to update from another based upon certain criteria, the fields in question are :- Table1:- AddressLine1, AddressLine2, AddressLine3, AddressLine4,ID1 Table2:- Add1, Add2, Add3, Add4,ID_1 What I need to do is update AddressLine1 with the contents of Add1, AddressLine2 with the contents of Add2, etc,etc. But, if one of the fields is empty or contains the word 'NULL' then I want to update that field with the next 'populated' field along. eg, normally it would be something like:- Update Table1 Set AddressLine1 = Add1, AddressLine2 = Add2, AddressLine3 = Add3, AddressLine4 = Add4, From Table1, Table2 Where ID1 = ID_1 but I need an 'if' statement or something in there to check whether Add2 is blank or = 'NUL ...Show All

• Visual C++ The difference between string$ and string

  A fellow developer uses "string$" but has no idea why he uses it. So I pose this question to the pros because I've always used "string". What is the difference between using "string$" and "string" I think someone referred me to the wrong forum for my answer. I just noticed this is a C++ forum and of course string$ would not compile. I need to ask my question in the C# forum, my apologies. ...Show All

• SQL Server Connection Issues To Report Services

  Hello all, I just installed the SQL 2k5 standard suite of services on a w2k3 enterprise edition server. All went well except for the connection to the reporting server. I get the error below. "No connection could be made because the target machine actively refused it" I can't seem to find any information on this error and have no clue where to even start. I've done 10+ installations of this software on various machines and have not encountered this error on any of them. I have uninstalled, then reinstalled the reporting services and still no solution. All connection attempts are being made on the actual server, not from a desktop. sp1 for sql 2k5 is also installed, if that helps. Windows Firewall is off. What w ...Show All

• Visual C# sql Express

  I am using c# express and sql express. After defining a database and dataset I added 2 tables and made a form to enter data by dragging table from dataset and after that every table causes an error in the .fill(statement) at runn time its saying it doesn't exist but I can see data I entered manually in the database Is there some limit for sql express or what private void DegreeDays_Load ( object sender, System. EventArgs e) { // TODO: This line of code loads data into the 'eCalc2DataSet1.HeatingCoolingDegreeDays' table. You can move, or remove it, as needed. this .heatingCoolingDegreeDaysTableAdapter.Fill( this .eCalc2DataSet.HeatingCoolingDegreeDays ); } ...Show All

• SQL Server Get Record Number

  I have a table containing 1000 records. I do have a primary key associated with the table. But I want to get the Record Number of each record. Is there a way to get it. That means for first record it should be 1 and so on and so forth. That depends on wheter you are using SQL Server 2005 or any version below. SQL 2k5 introduced the ROWNUMBER() function which will let your create a rownumber according to some rules (only a new number if a grouping changes, etc.) if you are using SQL2k or bwlo you will have to go another way. What are you currently using HTH, Jens K. Suessmeyer. --- http://www.sqlserver2005.de --- ...Show All

• Smart Device Development What kind of server required?

  I am a newbie in WM5 application. I have a problem: My company needs me to setup an application so that the smartphone can constantly access the server and retrieve data... I have explored many about WM5, but it said little about the system archeticture... I may need to retrieve data from database and file... What kind of server do I need Is Microsoft Server 2003 suitable Do I need to install IIS Is Web Service the only method for the mobile to retrieve data from server What hardware / software I need to pay attention Pls advice... I have been hunting this for weeks but seldom found... The basics of web services and consuming them from the mobile deice are covered here http://samples.gotdotnet ...Show All

• Windows Forms Vista style windows in C#?

  Hello! Is it possible to make Vista style windows in C# Like with a translucent border and titlebar Please give me some samples and pointers. Thx! Matt I would like something like this: http://www.codeproject.com/useritems/Translucent_Windows.asp only for C# not VB. Matt ...Show All

• .NET Development 'GetPictureDetails' is not a member of 'JokePoint.Catalog'

  The error appears: 'GetPictureDetails' is not a member of 'JokePoint.Catalog' How can i go about solving this problem The code that the error appears in: pictureDetails = Catalog.GetPictureDetails(pictureId) Thank you, Peter Sorry Peter , I am not at all familiar with web development , I cant help you there. Perhaps you have not imported a library that needs importing , i.e you do not have your references in place , this is why the error is generally generated in WinForms development. ...Show All

• Software Development for Windows Vista Why I can not combind the SqlTracking & SqlPerstance Service in RC4?

  Hi . I have a sample app written in beta2.2, which simple do persistent and tracking. all my workflow. when I upgrade to RC4, it wont works ! I go back to the foundatmental SDK samples. "SimpleTrackingSample" in RC4. run it again, see the code is simple and fine, then I add some code to do SqlPersistent stuff. but, it wont work !!!, It will always run into WorkflowAborted event. but why any one can help here are my sample. const string connectionString = "Initial Catalog=WorkflowTrackingStore;Data Source=.;Integrated Security=SSPI;"; const string connectionString2 = "Initial Catalog=WorkflowPersistenceStore;Data Source=.;Integrated Security=SSPI;"; static void Main() { ...Show All

• Visual Studio Team System Error 28002, TFSReg, value 2120

  I've seen many people with the 28002 error for VSTS. We are also getting that error, and thus unable to complete a TSF installation. None of the solutions suggested in other posts are working for us, but I thought I'd post some additional error message text that I haven't seen anyone else post. Perhaps this will help. It is from the msi log: TFSReg - Team Foundation Server registration tool Copyright (C), Microsoft Corporation, 2005. All rights reserved. Could not load type 'Microsoft.TeamFoundation.Common.ArtifactLinkIds' from assembly 'Microsoft.TeamFoundation, Version=8.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a'. 11/22/06 08:06:14 DDSet_Status: Process returned 2120 11/22/06 08:06:14 DDSet_Status: Found the match ...Show All

• Software Development for Windows Vista General Questions

  I'm a newbie. 1)What's the difference between Workflow Foundation, Windows Communication Foundation, and Windows Workflow Presentation 2)Is extensions for VS2005 required I mean I must install them Thanks Probably the best place to start is the Windows Vista Developer Story, http://msdn2.microsoft.com/en-us/windowsvista/aa904951.aspx ...Show All

• Visual Studio 2008 (Pre-release) [urg] security negotions fail over domain

  We're about to go final with an interop wpf/wcf application in our main intranet product, when this bit us bigtime: The security negotiations between server and client fail (and thus time-out). This happens with machines on the same domain as well. The exception: "Client is unable to finish the security negotiation within the configured timeout (00:00:00). The current negotiation leg is 1 (00:00:00). " Basically we wish to do authentication using kerberos. So, in both client and server we have: < security mode =" Message "> < message clientCredentialType =" Windows "/> </ security > When testing with both server as client on the same machine, everything works f ...Show All