GregRoberts's Q&A profile

• SQL Server Transaction Rollback Issues

  Hi We are loading data from one extract file in to 4 different database tables. When we are loading if the first table gets loaded without any issues and the second table loading gives any issues, we need to rollback the data loaded in to the first table also. In the package for achieving this, we are using Sequence container. In the sequency container we are having 4 different tasks for loading data to 4 different tables from the same extract file. We also tried setting the different transaction options given in the properties box of the packages, container and tasks. Also we tried the properties by setting as mentioned in the Test# 7 and 8 in the following URL http://www.sqlservercentral.com/c ...Show All

• Smart Device Development How to form a bitmap image in compact framework

  hi all... i am developing an appliction in which i am drawing some rectangles & lines along with some text. I am using .NET compact framework. But whatevr application i have developed it is showing some flickering problem. So can anyone tell me how to remove this flickering. If we form a bitmap image from the rectangles, lines & text then i think we can remove this flickering. So can anybody tell me how to form a bitmap image at runtime in .NET compact framework. Thanks, vinay Well, I have no time to try, but try this: In OnPaint 1) Create bitmap, with the size of the forms ClientRectangle 2) Create graphics from that bitmap 3) Clear graphics to suitable back color (black default) ...Show All

• SQL Server using alias in a view

  Hi How (if i can) can i use a alias in my view if i have 1 alias total and a alias Moms can't i then have a nother alias there say total+moms Or shall i write all again in another alias Alvin Alvin: The short answer to your question is "no"; you cannot use your alias as the abstract to build nested aliases. A select such as: select vare_1.Pris, vare_1.Pris * shoppingcartItems.Antal AS total, vare_1.Pris * shoppingcartItems.Antal / 100 * '25' AS moms, moms + total as medmoms from @vare_1 as vare_1 inner join @cart as shoppingcartItems on vare_1.item = shoppingcartItems.item will result the following syntax errors: Server: Msg 207, Level 16, State 3, Line 25 Invalid column name ...Show All

• Visual Studio Express Editions Web Browser validate URL

  ok...i have another question about a simple C# browser... I found out that if i type something like www.google.com into the browser, it has an error, but if i have the "http://" it will work.  So my question is, how do i detect if the person has typed "http://" or not, and then have the appropiate responses to those situations...i dont think that was clear :)...let me rephrase, suppose the person types http://www.google.com , i want that to go directly to the browser, but if the person types www.google.com , i want the browser to add "http://" Thanks, paoloTheCool :) try this . http://www.codeproject.com/vb/net/IE7_Clone_VS2005_Browser.asp more i will try by code.. hey i m gl ...Show All

• Community Chat Help please

  How can i create any password to my USB (flash drive) without using any software! is it possible thanks im soory but i dont know on how! this is my first time to ask like this... Sorry! ...Show All

• .NET Development Regex search for two words seperated by a space

  I have a text file that I need to match on. I load the file into a string and then strip out the newline characters (\012’s) and replace them with stars (\052’s) to make working with them simpler. So then I have a string variable made up of groups of text separated by double stars (**) with the occasional star in-between the double stars. I need to find names within those ‘groups’ but I also need all the text within the group. I build my regex by using a string variable for the name and end up with a regex like this: Dim textForRegex As String = "( xism)\*\*[^\*]*" & strName This works as long as I use a single name in my ‘Prompt’ string. When I type in two words such as ‘John Smith’ my regex search fail ...Show All

• Visual C# Abstract forms and design view

  I have a form I created as a base class. I then derived a child form from this. Everything is OK so far. Now, I would like to make the base class abstract, so I can add some abstract methods. Now the problem, if I decide to go to design view in the child, I get an error. The base form is abstract and cannot be instantiated, but design view is trying to do just that. Is there a way to fix this Seems to me there should be, the commonDialog class is abstract. When developing the saveFileDialog, I'm sure the developer didn't have to keep changing the class definition to get things to work. Any help will be appreciated. As far as I know this behavior is by design. I do not think there is any fix available for t ...Show All

• .NET Development WSDL contains local server name URL in soap:address location attribute

  I have a Web service which is being accessed by a third party who uses a Java tool to construct SOAP interfaces from the WSDL published automatically by ASP.Net about my service. The location attribute contains the local name of the server, rather than the external domain, eg.: - < wsdl:service name =" MyService " > - < wsdl:port name =" MyService Soap " binding =" tns: MyService Soap " > < soap:address location =" http://localservername/ MyService .asmx " /> </ wsdl:port > - < wsdl:port name =" MyService Soap12 " binding =" tns: MyService Soap12 " > < soap12:address location ...Show All

• SQL Server SQL Server Memory Consumption with SSIS?

  I've been working on serveral packages for the past hour and after finishing for the night I quickly wanted to check to see how much memory SQL Server was consuming on my laptop. It was using almost 500MB of memory. It typically hovers around 50-100MB when I'm not doing anything with it. Is this normal The answer very much depends on how much memory do you have on the system, and what other applications are running. SQL Server does like to use the memory if it is available (otherwise - why would you buy all that RAM - was not it to make SQL run faster ) so if you have enough free memory SQL Server can use some to cache its data. So check how much memory is free - if about 20% of RAM is still free, everythi ...Show All

• Visual Studio 2008 (Pre-release) How to apply behavior configuration section in app.config/web.config while coding

  Hi All: I will create a ServiceHost, the problem is how to apply "returnFaults" behavior section The configuraiotn section: <behaviors> <serviceBehaviors> <behavior name="returnFaults"> <serviceMetadata httpGetEnabled="true"/> <serviceDebug includeExceptionDetailInFaults="true"> </behavior> <serviceBehaviors> <behaviors> Thanks, Zhihao In that case, you can just do the same thing imperatively, e.g. ServiceMetadataBehavior smb = new ServiceMetadataBehavior(); smb.HttpGetEnabled = true; host.Description.Behaviors.Add(smb); host.Description.Behaviors.Find<ServiceDebugBehavior>().IncludeEx ...Show All

• SQL Server deleting dups and keeping only 1 row in a batch

  I have asked this question before and got some great answers, I just wanted to ask this again. I can detect dups easily, is there a way to get a total number of all dups so that I can delete a certain number at a time, then check the total again for verification that that specific number of dups are gone I'm still using 2000. If I delete dups, won't it delete the 1 row I want to keep And I do have a unique identity column. thx, Kat Kat - You can get the dup rows using Group by with Having clause - see example: SELECT ident = convert ( int , 1 ) , name = 'harry' INTO #Temp INSERT #Temp ( ident , name ) SELECT 2 , 'tom' UNION SELECT 3 , 'dick' UNION SELECT 4 , 'harry ...Show All

• SQL Server Is it true?

  Microsoft E-Learning products are currently available for purchase only within North America at this time Jezz, bad luck I am currently living in Spain... ...Show All

• Visual Studio Team System What are the setups we need to do before starting Load Testing using Team Suite?

  Hello, I am new to Team Suite . I want to do Load Testing using Team Suite. What are the prerequisites/setup i have to follow before starting Load Testing using Team Suite I have also installed Team Foundation Server. Thanks, Riti You need to have the Visual Studio Team Test or Visual Studio Team Suite sku installed. Once you install wither of these, check out these load test walkthroughs: http://msdn2.microsoft.com/en-us/library/ms182561(VS.80).aspx ...Show All

• SQL Server SQL Server Bug in handling of getutcdate() during DST time change?

  During this latest time change, the value of getutcdate() was offset by one hour as called from SQL Server. True UTC time should never be impacted (or changed) by any Daylight Savings Time activity. This is likely not an OS issue, since IIS logs did show the correct UTC time (unchanging) during the DST time change. Here is a record of how the time change was handled by a running SQL 2000 sp4 Server as these functions were called: getutcdate() = Oct 29 2006 5:50AM //ran at the same time as// getdate() = Oct 29 2006 1:50AM getutcdate() = Oct 29 2006 7:05AM //ran at the same time as// getdate() = Oct 29 2006 2:05AM @@Version=Microsoft SQL Server 2000 - 8.00.2040 (Intel X86) May 13 2005 18:33:17 Copyright (c) 1988-2003 Mi ...Show All

• Visual Studio Express Editions Passing data between a DLL and an .exe

  Using the application wizards in Visual Studio Express 8.0 (with C++) I created a solution with 2 projects, the output of these projects are "MyMath.dll" and "GUI1.exe". MyMath is built from "MyMath.h", "MixedNum.h", "MixedNum.cpp" and some ancillary files like "Stdafx.h", "AssemblyInfo.cpp" and "Stdafx.cpp". GUI1 is built from "Form1.h", "GUI1.cpp" and ancillary files. I have a single class named "Fraction" defined in MyMath. MyMath contains the math functions I am defining and GUI1 is the Windows interface. Data is input through this windows form and the result is output through the same form. I intend to run these as sepa ...Show All