elfenland's Q&A profile

• SQL Server BULK INSERT fails with Msg 511 - Cannot create a row of size x which is greater than the allowable maximum of 8060.

  I am running the following BULK INSERT statement: BULK INSERT WEBLogs.dbo.WebLogEvent FROM 'H:\mydirectory\myfile.txt' WITH (BATCHSIZE = 100000, DATAFILETYPE = 'char', FIELDTERMINATOR = '\t', MAXERRORS = 1000000, TABLOCK) The insert failes with this error: Server: Msg 511, Level 16, State 1, Line 1 Cannot create a row of size 8666 which is greater than the allowable maximum of 8060. The statement has been terminated. There is nothing I can do about the bad data, but I would like for INSERT to simply ignore the bad record and move on. Is there a setting that will enable such behaviour Thank you! No. There is no setting to enable such behavior. This is the physical row size limitation in a ...Show All

• Software Development for Windows Vista WWF Persistance Status

  I have a workflow which having a while loop inside that I have an activity called Handle External Event, which will receives inputs from some windows application. When ever inputs come I used start a workflow and load the workflow for current situations. I have situations like, some time I have to hold the current workflow instance (dehydration) and start new workflow instance. WF internally updates the workflow persistence details into Workflow – DB. When ever workflow executes, I have to store the input values into my application database. So I am calling a database call( call to Data access Layer) from my External activity. The problem I am facing is after updating my application database workflow is not at a ...Show All

• Visual Studio HP Openview Monitoring for VSS

  Hi, Does anyone know if it is possible to use any of the tools from HP Openview to monitor the Visual SourceSafe application What I was looking for is if it is possible to be able to send an alert if the application goes down or become unavailble. Does anyone know which OV tool will do the trick and what process or services does it look for Thanks I’m not familiar with OpenView but what exactly are you trying to monitor Unless you are using HTTP access (in which case you’d monitor http(s)://server/SourceSafe/vssservise.asmx) all you’d monitor is the network share on the server the database is on. VSS using the file based database meaning that VSS Clients directly read/write files to ...Show All

• Windows Forms what causes PerformLayout method be serialized?

  in dot net 2.0, initially you have a form, then drag a push button onto the designer surface of the form, some properties are serialized by the code generator. but for some other controls, Textbox, ToolStrip, for example, when being dragged onto the designer suface, an extra this.PerformLayout() is appended. actually it is the parent control's PerformLayout that is serialized, if you drag a Textbox onto a Panel, it is the panel's PerformLayout method that is serialized. so what makes this different behavior thanks ...Show All

• Visual Basic Set working area, anyone please?

  Hi, See this thread.>> http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=1116884&SiteID=1&mode=1  I was wondering if it's possible to SET the working area at all please     Regards, S_DS   The following is a macro that uses the environment event "OnSTartupCompleted" to set the screen location...this sample sets the main VS window to the bounds of the primary screen...you can set MyScreen to which ever screen you want Option Strict Off Option Explicit Off Imports System Imports EnvDTE Imports EnvDTE80 Imports System.Diagnostics Imports System.Windows.forms Imports System.Drawing Public Module EnvironmentEvent ...Show All

• Visual C++ How to contain a modeless dialog in View Frame

  Hi, I created a modeless dialog (it's just a common one created with CDialog::Create). The dialog is located at a random position in the desktop window each time when it is created. I want to have it restricted within the View Frame though. Does anybody have any ideas about a solution Thanks in advance. Hello Re: How to contain a modeless dialog in View Frame The more appropriate place for your question is probably the MFC newsgroup: http://msdn.microsoft.com/newsgroups/default.aspx dg=microsoft.public.vc.mfc&lang=en&cr=US OTP Thanks Damien ...Show All

• Visual C# Compare 2 objects using type casting

  Lets say I have the following: int a = 5, b = 2; object o1 = a; object o2 = b; And I want do do if(o1 == o2) doSomething(); Obviously this doesn't work b/c o1 and o2 are reference objects. But how can I type cast them so it performs the correct comparison I tried this: Type type1 = o1.GetType(); Type type2 = o2.GetType(); if((type1)o1 == (type2)o2) doSomething(); But I get a compile error saying: "The type or namespace 'type1' could not be found" Does anybody know how to do this correctly More to the point type1 and type2 are variables not types. You code would have to read: if((Type)o1 == (Type)o2) doSomething(); Of course, since they are both already Type's you could just use: if(o1 ...Show All

• .NET Development how to modify and upadate the data in dataset

  Hello, in my program I am filling my dataset from 3 datatables and I need to update the value in "sum" field by increasing it by 1 (+1) and saving it back to the database...my select command for filling the dataset is: dataadapter1.SelectCommand.CommandText = "SELECT INCOMING.EPC,TAGINFO.Material_Number,TAGINFO.Description,TAGINFO.PSP,STOCK.SUM " & _ "from (INCOMING " & _ "INNER JOIN TAGINFO on INCOMING.EPC = TAGINFO.EPC)" & _ "INNER JOIN STOCK on TAGINFO.Material_Number = STOCK.Material_Number WHERE INCOMING.EPC=(" + tagdata + ") How can I update the "sum" field and save it back to the database Thanks in advance, Ca ...Show All

• Windows Forms Working with GridViews

  When I select on field ( a checkbox ) in the gridview I want to make that given row only readable, how do I do it Thanks JM Hi, This is quite confusing. If you can check a row and make it read-only then how would you uncheck it and make it editable again Since you can't uncheck the row coz the row would be then marked as readonly. Could you please explain a little bit further on what you are trying to accomplish here. :) Maybe we can offer a different approach to solve your problem. cheers, Paul June A. Domag ...Show All

• SQL Server Count Item function

  Hi, I need to count the number of rows in my Item table. The following statement gives me the number i.e. 200. Select Count(*) As Counter From Item Group By Id How can I number each individual row so that the row will have a number next to it i.e. Select Count(*) As Counter, [Count Statement] as Number of the Row From Item Group By Id Thanks Row_Number() is a new function in SQL Server 2005. Try this one: SELECT ( select count (*) from items as t2 where t2 . items <= t1 . items )+ 1 as series_No , t1 . id FROM items t1 ORDER BY t1 . items ...Show All

• SQL Server SSIS package cant run in sql job

  I already schedule ssis package but fail running in sql job I test run the package from SSIS and it successful but fail when run in sqlserver agent->jobs with message : The process could not be created for step 1 of job 0x78DF57ECF2572549A372E6295CB4C057 (reason: The system cannot find the file specified). The step failed. any idea --soonyu Soonyu, Are you scheduling the job to run on the same server/PC on which you developed the SSIS package   Can you verify that the .dtsx file was copied to the server/PC that you are trying to schedule it from I have this same problem...  I develop SSIS packages on my desktop, then when I am done, I move the .dtsx file to the server that ...Show All

• Visual Basic Multiple Catch blocks permitted

  Visual Basic Language Reference  Try...Catch...Finally Statement (Visual Basic)  Multiple Catch blocks permitted. If an exception occurs while processing the Try block, each Catch statement is examined in textual order to determine if it handles the exception, with exception representing the exception that has been thrown. ------------------------------------------------------------------------------------------------------------------------------------------------------ I have found that if I implement a multiple catch block an entry is always added to the exception stack for the block even though the exception that passed through was not an exception that was to be handled. I was expecting this multi-catch bloc ...Show All

• Smart Device Development what is the best way to handle a CSV file as data table ?

  i have this question and hope assistance please .   what is the best way to handle a CSV File like a table from a database and fill it into a datatable object   regards ! i'm sorry . you are right .. i will prepare the code with a description of my question .. ...Show All

• SQL Server MDX - Calculating Variance - One table

  I have a very simple table. Date Amount Variance Data as follows: 11/30/06 50.00 W 11/29/06 45.00 X 11/27/06 55.00 Y 11/25/06 30.00 Z I want to fill in W, X, Y, Z (and all other rows in the table) based on the Variance of the last 3 days - including the day on the row. For example, I would like to fill in field W with the Variance of the Amount field looking at 11/30, 11/29, 11/27. I would like to fill in field X with the Variance for data set (11/29, 11/27, 11/25) Etc ... I am converting an Excel spreadsheet to SQL 2005 (so i can handle a bunch of data). The reason I need to populate the field (and not just report it) is that I need that data for a bucnh of other calculations. So very simple in Excel ...Show All

• Visual C# How to get uptodate user information with WindowsIdentity object?

  I have the folling codes in C# WindowsIdentity user = WindowsIdentity .GetCurrent(); IdentityReferenceCollection groups = user.Groups.Translate( typeof ( NTAccount )); Everything works fine. However, whenever I change something in ActiveDirectory for a user, the user must logoff and log back in to see the changes. Are there anywany for me to force WindowsIdentity object to get the uptodated Groups without logoff and logback in Regards, JDang Until at this point, the user must logoff and login again to see the changes. You can call GetCurrent() many times but the Groups remain static. Do you think this is a bug Regards, Jdang ...Show All