gjc_vp's Q&A profile

• SQL Server What accounts for this performance difference?

  As mentioned in a previous thread, I've got a single Transaction Scope style transaction surrounding a number of DDL style changes. This usually takes ~1.5 hours to complete. What I noticed is the same sort of query starts to take longer the closer to the end it is. I.e. Create Table after the first 1 min takes 150ms, after an 1 hr it takes 2 secs. Is this a problem with SQL Transaction handling or DTC To prove the point I set my root transaction to "not supported" and the overall time dropped for ~1.5 hours to 6 mins!!!! Now I realise I was taking on some overhead using a long running transaction but I never thought it was this ex ...Show All

• Windows Forms Searching the Database for Records with Specific Criteria

  I want to implement a search engine in my application that searches by a text box entry along with drop-down boxes. Similar to software at doctor's offices.  They type in the name of the person and that person's record is returned if there is a matching name in the database. Another example, when I am on a website that sales desktop and notebook&n ...Show All

• SQL Server Oracle Translate function equivalent in SQL Server

  Hi I want to know the equivalent of the Oracle translate function in SQL Server. eg : select translate('entertain', 'et', 'ab') from dual. I tried the SQL Server Replace function , but it replaces only one character or a sequence of character and not each occurrence of each of the specified characters given in the second argument i.e 'et'. Please let me know if there is some other equivalent function in SQL Server thanks. Hi, no there is no quivalent for the translate function. HTH, Jens Suessmeyer. --- http://www.sqlserver2005.de --- ...Show All

• Visual C# specify the runtime version in Visual C# .NET

  Hallo Community, i read this here in online msdn: thi si for Visual Studio .Net 2003 and i need it for VS.Net 2005: Specifying the Runtime Version for an Application To specify the runtime version in Visual Basic .NET Select the project in Solution Explorer. On the Project menu, choose Properties . In the Property Pages dialog box, select the Build node and click the Change button. In the .NET Framework Version dialog box, select a version option and click Update . To specify the runtime version in Visual C# .NET Select the project in the Solution Explorer. On the Project menu, choose Properties . In the Property Pages d ...Show All

• Software Development for Windows Vista Problem with "The Goods"

  All, I tried to install Windows Vista with Virtual PC last evenning, following Ben's (Virtual PC Guy) instructions.  I however got stuck early on, it asked for my 25 digit activation code to do the install but refused to accept the one I was given in the book accompanying the disks.  Any thoughts E. Will Microsoft make a new Vista CD available Or will Microsoft publish a workaround I tried all possible posts on the web, nothing was successful. Is anyone from Microsoft working on this ...Show All

• Software Development for Windows Vista does any of the labs work without a problem in the beta 1.2 version?

  hello guys. i'm a little disapointed with the hand on labs...well, those of you that have seen my previous posts know that i've been having a lot of problems while trying to run the labs. now, i'm facing several errors with exercise 4 of lab01:  error 288: Activity 'getManager1' validation failed: Property 'ReportEmployeeId' has invalid value. Field 'ReportEmployeeId' does not exist. C:\wf lABS\ExpenseWorkflows\ExpenseWorkflows\Workflow1.xoml : error 288: Activity 'getManager1' validation failed: Property 'ManagerEmployeeId' has invalid value. Field 'ManagerEmployeed' does not exist. the xoml.cs file has 2 fields with those names:   ...Show All

• Windows Forms Looking for help on migration issue

  Using HP dataprotector to migrate data to new AD enviroment. Data is backed up and restored but of course the local AD group is not added to the group shares and what not. Is there a way to us the "net" command to add the local group to all the shares as not to do it manually Has anyone done this hoping to use a script to automate a lot of this but not sure if it can be done with the net command. Thanks for any help provided. Tom This forum is for Windows Forms development using the .NET Framework. So you're unlikely to get an answer here. I would recommend reposting your question in the Active Directory new ...Show All

• Visual Studio Help crashes Visual Studio 2003

  I am a computer science major at a university that has Visual Studio 2003 available through the MSDN academic alliance. I installed VS without the MSDN library for an assignment and everything was great, then when I later tried to install the library it won't work. If I try to directly open the library, a message comes up saying "updating help..." then Document Explorer crashes. If I open VS the same message comes up and the whole program crashes. I can get to VS by clicking on a file that is normally opened by it, but as soon as I do anything that changes settings or causes the help update message to come up, it crashes. I downloa ...Show All

• Windows Forms global mouse hooks in .net

  Suppose a process notepad.exe has started. I like to know how to detect a period of inactivity of a user for that process, for instance how long the user has not entered anything into notepad.Maybe System.Diagnostics can solve this problem but i did not find much information on the websites.Hope to gather some advice here. Thanks a lot G_Zola, Have you found a solution to your issue I'm don't believe the current APIs in System.Diagnostics will be able to help. It sounds as though you are interested in UI interaction - from the user - and not simply repainting, notepad idle processing, or OS interaction wit ...Show All

• Visual Studio Express Editions vc++ Express side by side install with vs2005?

  I'm considering upgrading to vs2005 and have a couple of questions. I'm asking here because, after reading the various pages on msdn on the subject and searching these boards and the web, I have not found a satisfactory answer to my questions. Firstly, I would like to know if there is a vs2005 pro academic version or if the standard version of vs2005 is the only academic version that will be made available. Secondly and perhaps more importantly, I'd like to know if it's possible to keep the vc++ express edition I already have installed as I'd like to keep it for comparison. If it's not possible to have both vs2005 and vc++ express installed ...Show All

• .NET Development Unwanted promotion using TransactionScope

  Hi, I wanted to test System.Transaction and using TransactionScope. So I wrote a little factory class which has very basic CRUD functionality. One of it's methods is CreateName: public static Name CreateName( string nameValue) {     using ( SqlConnection connection = new SqlConnection( Properties. Settings .Default.TestDB))     {        return CreateName(nameValue, connection);    } } private static Name CreateName( string nameValue, SqlConnection connection) {     Name name = new Name (nameValue); ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Where can I get volume textures?

  Does anybody know where I could find some free volume textures to play around with Nico Don't know of any downloads. However, you can make your own very easily, using the DxTex tool available in the SDK utilities. ...Show All

• Visual Studio 2008 (Pre-release) Not able to generate proxy with typed dataset using svcutil.exe and WCF Feb CTP (with Jan Ctp was working fine)

  Hi, I wrote an WCF service using Jan CTP which transfer the typed dataset to and from between client and service. It is working with Jan CTP and I am able to generate the proxy using the SVCUtil.exe. Recently I have updated my system to work with Feb CTP and provide the necessary chnages in the App.config file. when I tried to generate the new Proxy with SvcUtil.exe( WinSDK FEB version) I got the below error: Error: Unable to obtain Metadata from net.tcp://localhost:8085/MyService WS-MetadataExchange Error Uri: net.tcp://c65:8084/BritNetService Metadata contains a reference that cannot be resolved: 'net net.tcp://localhost:80 ...Show All

• .NET Development Run Remote Batch

  Hi you all, Can anyone tell me how can I run a remote batch file Many Thanks, MeTitus There are some tools that allow you do this. Here's two that I found when I googled "windows remote execution": WinRShd and DoIt . I haven't tried them... ...Show All

• Visual Studio 2008 (Pre-release) Combobox with changed items style

  I'm trying to build a custom control that inherits from the ComboBox control. I've tried to change the style used in the items rendering with no success. I've set my style in the generic.xaml file in the Control's assemply (after creating a control library project in VS2005). Is there a sample of this Or could you give me some pointers Does it have to do with ItemsPresenter or ComboBoxItem How Thanks a lot. :) Answering to myself. :) I found the way to do this. But, I don't know how to bind to current item value in its template. Any ideas Here goes the code: < Style TargetType = " {x:Type local:Col ...Show All