euton_l's Q&A profile

• SQL Server High CPU utilization during full-text population in SQL 2005

  Hi, In SQL 2005 a full-text population of a text field in a table containing 1.2 million records utilizes very high CPU resources. A dual Xeon 3Ghz, 1GB memory was running at 95% during the population of the full text catalog. There was no other activity on this server besides the full-text population. It performed the population in approximately 28 minutes, which is allot faster than SQL 2000, however, the high CPU utilization would be of great concern in a production environment. I have not tested incremental or change tracking as yet but i plan to look at this very soon. Is this unusual behaviour or does the SQL full-text ...Show All

• .NET Development Moving from RC to full release version

  Is this going to be a simple uninstall of the rc version   Or do I have to run the auto uninstaller I used for removing Beta 2   Or is this going to be a completely manual process to remove all the associated programs 1 by 1 Thanks! yes...thanks.  i just wasn't sure if it was set up to uninstall only the beta or not, but it's not. :) ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Managed DirectX

  I am a vb.net application developer in vs 2003.  I am currently using the Windows Media ActiveX control for playing video files within my windows form application. I have been reading about the new release of managed DirectX and am curious about any advantages over what I am doing now and if examples for how to play a video in vb exists for this environment. Fred Herring If all you are doing is playing video, then you are probably just as well off using the ActiveX control. Just to let you know, Microsoft doesn't actually provide any managed wrappers for the DirectShow functions.  A set of open-source managed DirectShow wrappe ...Show All

• Visual Basic AnalogTVTuningSpace and MSVidCtl

  I´m trying to develop a decent tv tuner/capture application (since there are no such apps, nowhere, I say) in Visual Basic 6.0. I´m using the MSVidCtl component together with the AnalogTVTuningSpace and IChannelTuneRequest object to achieve this, as described here:  http://msdn.microsoft.com/library/default.asp url=/library/en-us/directx9_c/directX/htm/hostingthevideocontrolinavisualbasicform.asp  and here:  http://msdn.micro ...Show All

• Visual Studio Express Editions Debug assertion failed: (unsigned)(c+1) <= 256, file isctype.c, line 68

  I have compiled a debug version of Thunderbird using VC++ Express. I intermittently get the error in the Subject. When I kick into the debugger, the stack trace seems to indicate that the range check is actually failing in the _security_check_cookie() routine. Here's the stack trace: msvcr80d.dll!1023c92d() [Frames below may be incorrect and/or missing, no symbols loaded for msvcr80d.dll] msvcr80d.dll!1023cd81() > xpcom_core.dll!nsCRT::strtok(char * string=0x040db607, const char * delims=0x0371f398, char * * newStr=0x0371f398) Line 172 + 0xa bytes C++ Here's where the application code got to - it is just trying to return fr ...Show All

• SQL Server .NET 64-bit and .NET 32-bit Framework on a Win 2003 server x64: which aspnet_regsql wizard is recommended?

  Hi everybody, I installed on an Win 2003 server x64 .NET 64-bit framework (beta 2.0.50215). After that I installed VS2005 beta 2 (2.0.50215) and SQL2005 (VS 2005 Beta Experience Kit). No problem are visible. Two .NET frameworks are installed, ...\Microsoft.NET\Framework\v20.0.50215 and ...\Microsoft.NET\Framework64\v20.0.50215. What aspnet_regsql wizard is recommended to use to configure a SQL Server database that stores information for ASP.NET applications services Thanks for replies... I guess it would be better to post this on ASP.NET forums. This forum is for answering questions related to CLR Integratio ...Show All

• Visual Studio Team System 32000 error on app tier install (dual-tier)

  I'm getting stuck towards the end of the app tier install using the July CTP. The VSMsiLog has an error in it... 08/18/05 21:30:10 DDSet_Error: The Commandline '"C:\Program Files\Microsoft Visual Studio 2005 Enterprise Server\BISIISDIR\sdk\bin\Bisregedit.exe" "C:\Program Files\Microsoft Visual Studio 2005 Enterprise Server\BBIISDIR\Uninstall\BigBuildBisRegistration.xml" vsts-poc3-vs2k3 BisDB' returned non-zero value: 1. MSI (s) (EC!1C) [21:30:16:187]: Product: Visual Studio 2005 Team Foundation Server (services) (English) -- Error 32000.Failed to execute action. I looked for the xml file at that location and the uninstall directory doesnt e ...Show All

• SQL Server xml to relational tables

  I need to insert xml documents into multiple relational tables in sql server. What is the easiest way to map the xml to the relevant tables. It was my intention to bring the document into a stored procedure as a string and use openxml to insert into the tables. I have since heard xmlspy can automatically do this. Is this true If so is there any other way of doing this Regards Danny Danny, If you are using SQL Server 2005, you can also pass the data via a stored procedure as an xml datatype. You can then process the xml using the .nodes() method on the xml datatype. If the xml data you ...Show All

• Visual Basic Real Time Data Monitoring

  Hi All: I am writing a project to analyze data from a device in real time. The idea is to pick up the signal from a sensor through serial port in 20Hz and to do some calculation on the data received, and plot out the result on the form. I use a background worker to read data from the serial port and do the calculation within a Do Loop. There is no problem on this. My problem is that when I try to use GDI+ to plot the results on the form, data are not refreshed instantly on the form. I use a Collection of Single to store the data for plotting. Questions are: 1. Can Vb2005 do the job Or VC2005 is better 2. Is there a control ...Show All

• Visual Studio Express Editions login control for beta 2 does not authorize user

  In Beta 2 the login control does not work for me, although it worked in Beta 1 easily. It's NOT the password.  My explicit code Membership.ValidateUser works.  Also when I type in a user with an invalid password with the control, the validation control shows the error.  However, when I type in the valid password it simply takes me back to the default page and the user is not logged in.  @)(#*@()#*@# Any help appreciated. OK. I discovered the problem... My machine name has the special caracter _ ... When I'm tryed use http://<IP>/<Application> everything runs OK!!! Thanks!! ...Show All

• SQL Server Interactive sort doesn't work for multiple sub-reports

  I have a report, which contains two nearly identical sub reports. In the IDE, when I test the containing report, each of the sub-reports works fine, in particular, the interactive sort feature works for both. When I deploy the reports to the test server (desktop running Windows XP, SQL Server 2005 Developer’s Edition, and SQL Reporting Services 2005, reports are served as web pages), the interactive sort feature seems to work only for one of the sub-reports. The other sub-report causes a postback, and refreshes, but does not return sorted. It appears as though whichever sub-report I attempt to sort first, sorts fine. When I attempt to sort ...Show All

• Visual C++ MemoryStream

  This does not work: MyStream is a MemoryStream InsertString = String::Format ("insert into blobtest (blobtest) values ('{0}');", MyStream->GetBuffer()); MyStream->GetBuffer() just returns "System.Byte[]", not the actual data, which is what I want. You can see what I'm trying to accomplish here. Why isn't it working Before I answer this question, I'd like to know how you obtained MemoryStream (did you make it from a file Which file Did the user type it in ) What is the column type for blobtest ...Show All

• Visual C++ DWORD_PTR

  I checked and tried what you both said. The declaration of windows.h was ok. I tried to compile the simple app with only a declaration of a DWORD_PTR #include <windows.h> int main( int argc, char **argv) { DWORD_PTR i; return(0); } Here's the errors (i disabled the precompiled option (/p) for this list) Thanks again Output Window Compiling... StdAfx.cpp Note: including file: c:\hydrotel\code\hydrotel_2004_07_09_console_avec_dll\hydrotel_2004_07_09_console_avec_dll\stdafx.h Note: including file: C:\Program Files (x86)\Microsoft Visual Studio 8\VC\atlmfc\include\afxwin ...Show All

• Visual Studio Maximum size of Report Parameter

    I have a report which I need to call from ASP.NET page. I'm trying to use reportviewer control that came with Reporting Services 2000. The report has a parameter which accepts more than 5000 charecters size string. But when I run the report the report viewr never responds. But if I limit the size to around 700 charesters it works fine. So, my question is what is the maximum size allowed to set the reporting services report parameter value Is there any difference in SSRS 2000 and SSRS 2005 related to this issue In SSRS 2000, parameters were submitted via url, so you will run int ...Show All

• SQL Server Subquery returned more than 1 value error

  Hi group I get the above error in my SP when the tblHolidayDates has more than one record. Here is my SP: begin if datediff(day,getdate()-10 ,(Select HolidayDate from tblHolidayDates))= 3 AND DATEPART(dw,(select holidaydate from tblHolidayDates)) = 1 -- Monday Date SELECT su.SuspensionID, su.ConsentNo, si.SiteID, si.NameNo + ' ' + si.Address1 AS SiteAddress, si.SiteDesc, si.SuspensionStart, si.SuspensionEnd, si.Address1, si.BaysAttached, rd.RefValue AS NoticeDays, si.MergeID FROM Suspension su INNER JOIN SiteData si ON su.SuspensionID = si.SuspensionID INNER JOIN RefData rd ON si.NotReq = rd.RefCode WHERE su.Status = 'ACT' ...Show All