SammyD's Q&A profile

• SQL Server synchronizing expired subscription and publication databases

  I had a merge subscription expire and now need to synchronize two disparate databases.  How do I do so without overwriting the subscriber database with the publication snapshot   Thanks for any help you can give. The expired subscription will need to be reinitialized from the publication snapshot. Few ways to not lose the subscriber data (not yet synchronized to Publisher) is to 1. store the data in temporary tables and then ...Show All

• Visual C# Confusion with Clear() method of ArrayList

  Hi, Check out the following lines. ArrayList list1,list2; list1.Clear(); list1 = list2; Now, my question is, does calling the Clear() method matter here It shouldn't isn't it because in the next line we are assigning another list2 to list1 (this is by reference isn't it). So the presence or absence of Clear() method should affect list1. But that is not the case for me. If I call Clear() the content ...Show All

• .NET Development Help with Reflection and accessing controls on page

  Hi all, I am trying to access a couple of controls on a page via Reflection.  More specifically, I am trying to get and set the value of a textbox using: Dim dispCompInfo As System.Reflection.FieldInfo dispCompInfo = Me .GetType.GetField("txtFirstName", Reflection.BindingFlags.NonPublic | Reflection.bindingflags.Instance) However, I cannot seem to get a return value from any of the Type's "Get..." methods.  Can someone tell me ...Show All

• SQL Server Writting multiple rows from one input Row

  Hi: I'm trying to write a transformation script to write multiple rows from 1 input row. In SQL Server 2000 DTS I could do this by using DTSTransformStat_SkipFetch and DTSTransformStat_SkipRow. In SQL server 2005 it looks like I need to use EndOfRowset but I do not know how to use it for sure. If this correct can someone show me a code example and if I am incorrect can someone tell me how to do this Thanks I have and I do n ...Show All

• Visual Basic How to detect if app is in debug mode

  I know I saw this property somewhere . I want to detect if the app is being run in debug mode (or in the IDE). Any ideas. If System.Diagnostics.Debugger.IsAttached() Then ......... ...Show All

• Visual Studio Team System Visual Studio and Share Point

  Hi there! How can I view documents history in Visual Studio IDE. If I've created a project based on MSF Agile and configured Requirements Folder to create versions for each document each time it is saved, how can I make versions visible in Visual Studio Best Regards, Rui Dias You can't from within Visual Studio (Team Explorer). You can only view SharePoint document history on the SharePoint site, which ...Show All

• Visual Studio 2008 (Pre-release) What happened to the ADO.NET 3.0 May CTP?

  It was announced here http://bloggingabout.net/blogs/erwyn/archive/2006/05/11/12167.aspx and then within a few days was so completely removed from MSDN ...it was like it never existed. Why was all of the documentation for ADO.NET 3.0 removed from MSDN (...in fact, it's odd that this HTML forum continues to exist) Vidya, are you saying the LINQ will be one of the features in ADO.NET 3.0 Has anyone heard when ADO.NET 3.0 will r ...Show All

• Visual C++ Writing to an open document!

  Hallo, It may sound a silly and stupid question. Still please answer my question.I starts an application A written in vc++. This program opens a file F and then it calls another application B. Application B now try to write into this file F which has been opened by A. This is the scenario. Is it possible to realize this Thanks n Regards Swingme swingme wrote: Hallo, It may sound a silly and stupid quest ...Show All

• Visual Studio Team System Error Adding a Testing Policy on Check in Policies

  Hi, I created some unit tests and I’m trying to add a testing policy. VSTS ask me for a metadata file (.vsmdi), I select my project from the server and when I press OK the following error appears, “ Warning Error downloading $\MyProject. ” The metadata file is in my solution. Any suggestion Thanks. To create a test policy you need to select a VSMDI file from ...Show All

• Visual Studio Express Editions Almost Impossible to download!!!

  So, MS have made their website almost impossible to use. I wanted to trial MSVC 2005 via download option, which their website says is available. I look all over their confusing website, filling in form after form, going in circles to try to find it. Eventually I see the sign saying 'you must be registered to download'. It doesn't help when your country list doesn't contain the UK! You got the US and all sorts of countries, but not ...Show All

• Visual Studio Team System How to use own Work Item Type "Feature" in Query

  Hallo, we created a custom Work Item Type called Feature. Everything works well. The WI-Type is imported in TFS (witimport) and we can use it. Now i wanted to create a query that returns all features asigned to me. In the querydefinition I would like to select the "Feature" als value for the field "Work Item Type" but i can't select it. I am just getting Bug, Risk and Task for selection. (So Quality of Service Requir ...Show All

• Visual C# Separating data access form code.

  Greetings All, This inquiry is regarding the separation of data access from a windows forms application. I currently have a class called Data which exposes static methods that basically take in the form variables and then creates, updates and deletes those variables from a sql database. So in my form class I can call this: Int Success = Data.UpdateDate(DateTime date); (return -1 if unsuccessful) My question is – ...Show All

• SQL Server SQL Server

  I would like to know how to upload files to my SQL Server 1.       Make sure you installed Integrations Services 2.       Use dtswizard.exe or SQL Server BI Dev Studio ...Show All

• SQL Server Previous Row Calculations

  Hi all  I am wondering if anyone know a way that you can look up a value from the previous row to do a calculation on. I have a field that I need to subtract the same field from the previous row to validate. Is this possible in a query Thanks Kenzie Slight simplification, you can use only the CTE in the self-join like: WITH t_seq AS ( select ROW_NUMBER() OVER(ORDER BY <column_list>) AS seq from <table> ) select . ...Show All

• SQL Server After laptop goes into standby, SQLEXPRESS won't start

  If my laptop goes into standby with the MSSQL$SQLEXPRESS service running, the service will not start again. I get the following error messages in my log: 2006-03-06 20:49:08.45 Server This instance of SQL Server last reported using a process ID of 1764 at 3/6/2006 1:48:21 PM (local) 3/6/2006 9:48:21 PM (UTC). This is an informational message only; no user action is required. 2006-03-06 20:49:08.45 Server Error: 17053, Severity: 16, Stat ...Show All