GTrz's Q&A profile

• SQL Server sproc running soooooo slowly. cant figure out why

  i have a sproc that is taking 5 hours+ to run. that was on 40000 rows. even on 25 rows it takes over an hour. the sproc calls a sproc or two with a cursor or two ( sorry for being so vague) . the sproc stil should not take an hour for 25 rows. i have checked what db objects are locked, and there are no other processes going on at the time, as i have killed all them off. would lack of space on a hard disk or something. any ideas of some strange things that could cause a sproc to run slowly Since you are using cursors and calling SPs for each row, it is going to an inefficient process most of the time and the performance will degrade as the number of rows that you process increases or your tables grow. If yo ...Show All

• SQL Server Merge Replication with SQL Mobile Server 2005 / SQL Server 2005

  I am using Merge Replication to Synchronize a database on a mobile PDA. I create an empty table 1st using; "engine.CreateDatabase()" then sync with ; "replicator.Synchronize() " It works great the 1st sync, but subsequent calls to "replicator.Synchronize() " dont download new table changes at the server level to the remote PDA. I have found by calling ; "replicator.ReinitializeSubscription(True)" I can get new updates downloaded to the handheld, but it is very flaky / glitchy when using this call and hangs / freezes / or doesn't work all the time, every second attempt seems to work.... My questions is... 1) after initial synchronization, is there steps at the server level or handheld level to request new updates to download - ...Show All

• SQL Server Calling stored procs based on a code table

  I need to run stored procs based on a list in a code table. In other words, it reads the name of a stored proc from a table and runs it and does this for all the rows in the table. I think the ForEach loop container will do what I need and there is an ADO enumerator option but the documentation does not tell you how to use this. From what I can tell, you need to get a dataset into an SSIS variable first and then you plug the variable name into the ForEach ADO enumerator. Is that correct If so, can someone tell me how to get a dataset into a variable Thanks Perhaps kirk's blog will help you: http://sqljunkies.com/WebLog/knight_reign/archive/2005/03/25/9588.aspx ...Show All

• Smart Device Development Wake Up PDA or Keep awake ?

  Hi, I have come across a issue when trying to play a sound when the device falls asleep. (Mobile 5 , VS2005) ... It just doesnt play! I was wondering , is there anyway i can keep the pda alive or any way i can wake the pda up when i want to Many Thanks in advance. Jason I've answered similar question about a week ago. Which means you can get answer right away if you use search. ...Show All

• .NET Development Licensing on MDbg

  Hi, could someone tell me what is the licensing or user agreement of using MDbg in a commercial product In general, you can legally distribute MS sample, but MDbg has provided a significant amount of functionalities which it may have a different end-user aggreement. Our current design plan is to integrate MDbg into our product with a custom MDbg extension and with minor or no modification to the MDbg Shell. Thanks Unfortunately, the mdbg team is unable to interpret the EULA for you. If you're considering the use of the mdbg source in a commercial product, I generally recommend involving a legal entity from your end in order to make sure the licensing terms in the mdbg EULA are compatible with the licens ...Show All

• SQL Server MDX : WHERE Greater than year 2004

  I have an MDX dataset auto-created by SQL 2005, I want to restrict it to anything greater than year 2004. I could get the single year 2004 by replacing ALLMEMEBERS with &[2004] : (i.e. [Incident Date].[Year].&[2004]) but don't know how to do GREATER THAN in MDX. WITH MEMBER [Measures].[ParameterCaption] AS '[Incident Date].[Year].CURRENTMEMBER.MEMBER_CAPTION' MEMBER [Measures].[ParameterValue] AS '[Incident Date].[Year].CURRENTMEMBER.UNIQUENAME' MEMBER [Measures].[ParameterLevel] AS '[Incident Date].[Year].CURRENTMEMBER.LEVEL.ORDINAL' SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [Incident Date].[Year]. ALLMEMBERS ON ROWS FROM [Incid ...Show All

• Visual Basic Strict Color Data Types

  Hey, i know what the problem is here, but i don't know how to fix it! Texttxt.ForeColor = GetSetting("My_Program", "Program_Options", "Fore_Col-Col", Color.Black) It says that it won't work because Color.Black can't be a string. Now i know there's a simple way around this problem... But i'd also like to know how to prevent this type mismatch (i believe that's what it's called) from happening again with ALL data types. Can any one give me some magical web page with all the answers (and solve this) too please The My.Settings.Save actually persist the settings to the configuration file otherwise you are only chnaging the in-memory copy and if you restart the application it wil ...Show All

• SQL Server Invalid attempt to read when no data is present

  I have a stored procedure that inserts a record, and then either returns an error or, when successful, returns the entire row. This is a method I use on sites I have developed in other languages when inserting or updating data; I am new to c#. With C# I have a datareader executing the sp, and the insert works fine, however I get the error "Invalid attempt to read when no data is present." when I try to read the data that should be coming back. I have researched and updated my code so that I no longer get the error, but I still cannot get the data back. I trap the sp in profiler, ran it in anaylzer, and it works fine - data is returned. But in the code, it does not see the data. I have modified the return results so now I ju ...Show All

• Windows Forms StatusStrip - SizingGrip problem

  Hi I've added a StatusStrip control to a form. Within this I added a ToolStripProgressBar , and set it's Alignment to "Right". Now I have the progress bar next to the SizingGrip. If I now set "SizingGrip = False", the sizing grip is removed, but there still is an empty area left. I now have an ugly space between the progress bar and form border. How do I get rid of this area Kind Regards I also tried it on a PC with Windows Themes enabled. That looks fine also, the progress bar is flush to the window border. No idea why you'd have a problem. Note however that I used the RightToLeft property of the StatusStrip to get the progress bar to display on the right-hand side. Setting th ...Show All

• SQL Server Problem with creating new SQL server database in VWDExpress using SQL Server 2005 Express

  I have two problems on creating new SQL server database in Visual Web Developer 2005 Express using SQL server 2005 Express. The 1st problem: (It is resolved) After installed SQL Server 2005 express and Visual Web Developer 2005 Express. When I tried to create a SQL server database in VWD the following error occurred: "connection to SQL Server files (*.mdf) require SQL server express 2005 to function properly. please verify the installation of the component or download from the URL: go.microsoft.com/fwlink/ linkId=49251" I was stuck with this problem for few days. I did several times of install/reinstall of VWPExpress and SQL server Express, made very sure following proper de-installation sequence as specified in t ...Show All

• Visual Studio Error : Project Type Not Supported

  Hi, I installed Visual Studio 5.0 into a new machine. When I tried to open an ( vb project ) existing project it came with the following error : " The project file cannot be opened. Project type not supported by this installation " The version of Visual Studio that I am using is : Microsoft Visual Studio 5.0 Version 8.0.50727.42 (RTM.050727-4200) Can someone please help me with this problem. Thanks. Found the solution to my problem. Had to install an update and a plugin for VS2005 to support WebProject Applications. To include support for Web application projects you will have to install an update and add-in as specified in the following article http:/ ...Show All

• Smart Device Development Error Code c00e000b recieved when starting msmq on Pocket PC Phone Addition

  Hello All... Im getting error code c00e000b on a pocket pc device when using visadm to start msmq after installing it. when I use the verify short cut I get a successfull reply but when I use the status short cut I get the c00e000b error code. I have seen many posting on the internet for this error but no solutions. I downloaded the msmq cab from the MS web site to make sure I have the latest version, but Im not sure it is the right version for my processor my device has a Intel(R) PXA270 processor and Im using the msmq.arm.CAB Yes, you have to sign it with trusted certificate (or have SDK test certificate installed on device). CAB sure will install, but untrusted driver simply won't start. Consider in ...Show All

• Visual Studio Team System Always getting "The internal state of the database project..yada yada..."

  That quite annoying as I don’t want to always kill the project from source source and get the latest correct build from the deployment database and build everything on top what was done in the meanwhile. Any suggestion or solution for that in the meantime -Jens. --- http://www.sqlserver2005.de --- That is not good, do you still have this problem If so could you ZIP the project and email it to me so I can look at it (gertd at microsoft dot com) Thanks, -GertD ...Show All

• Smart Device Development Wave Form API

  Im using the Wave Form Audio Interface ( http://msdn2.microsoft.com/en-us/library/aa446573.aspx ) to play back streaming audio from mic inputs in realtime. I have 2 inputs, one sampling at 44.1 khz and another at 8khz. The 44.1 khz plays back normally with no distortion or delay. However the 8khz sounds perfect but has a 4 second lag time or delay It seems if I set the sample rate of the 44.1 khz to 8khz in the code I get the same delay as the 8khz sample rate. So, I guess my question is why does the Wave Form API introduce a 4 second delay with a 8khz sample rate. //No Delay WaveFormat fmt = new WaveFormat (44100, 16, 2); Player = new WaveOutPlayer (-1, fmt, 16384, 3, new WaveLib. BufferFillEventHandler (Filler)); ...Show All

• .NET Development Obfuscation and debug

  I'm using the Obfuscator supplied by Visual Studio. How can I ensure I will be able to debug the Obfuscated assembly Is the map file along with the obfuscated assembly enough Should I build a non obfuscated version for debug instead Depending on the obfuscation level it could almost be impossible to debug obfuscated assemblies. When you obfuscate the assemblies, your source code no longer matches the assembly and most likely the method & attribute names are changed. The map file will help you to understand the stack trace from an exception as otherwise they will just show method a -> b -> c. I suppose if this is what you mean by debugging. ...Show All