zenox's Q&A profile

• SQL Server Performance and Execution Plan

  Performance !!! Hi! I am trying to execute an stored procedured that have already been used in another server (the test server ) but it takes 25 hours and in the another server takes just 40 minutes. !! I have reviewed the indexes, statistics an so on, I have exactly the same quantity of data but cannot explain why does it takes so long in the server that is supposed to be the better one. When I show de Execution Plan in the Query Analyzer in one server I get: - Select (0%) - Compute scalar (0%) - Remote Query ( 100 %) When I executed in the another one I get: - Select - Compute Scalar - Nested Loops Left Outer Join ( 80 %) - Merge Join / Right - Remote Query - Sort - Hash Match Right … ...Show All

• SQL Server Issues With SQL 2005 Encryption

  Are there any pitfalls i should look out for when using the encryption in SQL 2005 Just to clarify, have you tried calling "select * from sys.openkeys" right after your open key statement (before your alter)   Was this result blank For the database, are you backing up the database from your main server and restoring this onto your test server   If so, are these two machines in different time zones   If you are restoring a database in two different time zones, you may get errors trying to use symmetric keys (depending on what version of SQL Server you are currently running). Sung [edit] - corrected syntax error on sys.openkeys ...Show All

• Windows Forms running windows app in solution...

  Hi, I have a solution and there are many different projects in it. Some of them are windows forms application. How can I run a specific windows application from the solution rite now when I open the solution in VS.net and hit F5, there is always one particular project that runs. Do I have to "set as startup project" to run a particular windows application in that solution Thanks, Hey, You do need to Set that project as the startup project in order to get it to run with F5. The startup options are set in the solution properties. So, if you right click the solution and select properties you will see the different startup options you have. You can run multiple projects at startup if you' ...Show All

• Visual Studio Express Editions Can this be done?

  Hi, i have 2 pictureboxes 'A' and 'B', 'A' is a black rectangle box and 'B' is a blue circle. How do i make 'B' overlap 'A' and only the circle is show in the rectangle box without the picturebox blocking out the other details Thanks. Mario Thanks alot for the example. I figured it out. Basically set one of the picture as background. Next put in a pictureBox1 and set backcolor to transparent, the pictureBox1 will take the background picture as it's background. Now import in the picture which also has a transparent background into pictureBox1. Place pictureBox1 at the desired location and you are done. ...Show All

• Smart Device Development Problem with OpenNetCF SoundPlayer/Player Classes

  Hello, I want to play a .wav file using the SoundPlayer Class(OpenNETCF.Media) and right afterwards a video file. The problem is that i cannot find a mechanism to control whether the .wav file is completed or not in order to start playing the video file so the video starts while the sound file is still playing. I didn't find any event in the SoundPlayer Class that could be fired when the sound file is completed and i didn't find also a property that holds the state (playing or stopped) of the file. The Player Class (OpenNETCF.Media.WaveAudio) provides the above event and property but takes a stream as an argument and not a file which i think is easier to handle than streams. Should i work with the Player Class and define str ...Show All

• Visual Basic Passing an array from a VC++ ActiveX component to VB .NET 2005

  Please point me in the right direction if this has already been answered. I've looked all over and found things close to my problem, but nothing that adapted properly. All I want to do is pass a one-dimensional array from an ActiveX componenet written in VC++ (2003) to a program written in VB .NET 2005. It seems like I should be able to package the array as a Safearray and then as a Variant, and return that object. But I don't seem to be able to package it properly. Thanks! I'm a little confused. Are you creating the array in the C++ code and trying to use it in the VB code Or is it the other way around Can you post the declarations that you currently have in your .idl, .h and .vb file Best R ...Show All

• Visual Studio Microsoft Visual Studio 2005 V8.0.50727.42 - A data source instance has not been supplied for the data source - Isn't it easy ?

  Again the silly question. I've got it work on the free VWD, it's pretty simple. Recently I started using the  Microsoft Visual Studio 2005 Version 8.0.50727.42, and ----- I could not make it work ! I'm building a Web App, the report is Embedded Resource. I draged and dropped an ObjectDataSource3 and configured it correctly,  when I clicked the "smart tag" and "chose data source",  ObjectDataSource3  is under Other Data Sources --- My Page Name list instances", I could see it, but I couldn't choose it. Did I do anything wrong Please help, Thanks in advance, Long Hi, It's me again, I found a link that has the same problem as mine : http://forums.microsof ...Show All

• Visual C# Starting windows service

  I'm made one windows service which serves as a remoting host, but I can't run it! I built it, called installservice mywindowsservice.exe It said me that is successfully installed, but now I don't know how to start it.... I can't find it in services list... What am I doing wrong All services must run as LocalService account or a specified windows account. If you do not use the LocalService account you must specifiy the username and password that the service will be run as. This is necessary as services are started without any user needs to logon. The LocalService account is a special account with many privileges and also restrictions so what is most suitable depends on what your service needs authori ...Show All

• SQL Server The error of the Sql Server 2005

  Dear all I have a problem that about the Replication of the SQL SERVER 2005. If there are a hundred data in the delivery of replication ,but after they transmited fifty data ,the internet is disconnection. The question is how about the rest of the undelivered data and the delivered data. Do the delivery data will be rollback If it dosen't be rollback how dose the administrator of the database know the error of the replication of the data,the most important is how to know the data has not complete delivery. If it will be rollback and how do we check the error of the internet at immediately.. Thank you Sorry, but I'm still confused about what you are asking for. As an administrator, all you should be concerned with are replication age ...Show All

• .NET Development System.Data.Design.TypedDataSetGenerator: how i can customize the table adapter inside, setting public ...?

  System.Data.Design.TypedDataSetGenerator: how i can customize the tableadapter inside the generated code, setting public 'adapter' proprety and 'commandcollection' property without crak auto-generate code thank you in advance Hi, Typed DataSet classes are generated as partial clases, so you can create a partial class where you can override or customize the piece of code you want to, and without affecting the generated code Best Regards, ...Show All

• Visual Basic passing a function's name to another function (or sub)

  Dear all when programming in FORTRAN I was used to pass the name of a function to another sub or function. With VB.NET I have some problem. Suppose I have several functions, named F1,F2, F3,.., and that I have to perform some common task on these functions (for instance numerical integration). Well, I wish to manage things in such a way to have a library function or subroutine (to do integration) and to call it passing various parameters 'and' a function name ( e.g. F3 ) to perform the integration of F3 . In other words I wish something similar to this fragment of code to work (declarations and initialization omitted): module main integ1= integration(a,b,step,F1) integ2= integration(a,b,step,F2) end module m ...Show All

• SQL Server YTD summation after a pivot.

  I have an appropriate pivot query for my report that gets the sumation of all items and puts them into these columns. lineItem Jan Feb Mar Apr ... Dec item1 1 2 3 4 ... 12 item2 2 4 6 8 ... 24 I need to get the following lineItem Jan Feb Mar Apr ... Dec YTD item1 1 2 3 4 ... 12 78 item2 2 4 6 8 ... 24 156 Is this possible My querry looks something like the following WITH ProductSales(ProductID, OrderYear, OrderTotal) AS ( SELECT det.productID, YEAR(hdr.orderdate), det.linetotal FROM sales.salesorderdetail det JOIN sales.salesorderheader hdr ON det.salesorderid = hdr.salesorderid ) SELECT ProductSalesPivot.productID, Total_Sales_2001 = ISNULL([2001], 0), Total_Sales_2002 = ISNULL([2002], 0), T ...Show All

• .NET Development DllImport of 32-Bit dlls

  Hi guys, I am a real newbie on 64-Bit progr. so my question might sound a little stupid. I have a VB.NET project which refered to a 32-Bit dll via COM-Interop. I migrated the project and the COM invocation does not work anymore. I tried several compiler settings (anyCPU, x86) but nothing helped. Then I found in my old C# book a method called DllImport ( System.Runtime.InteropServices) I declared the dll as follows: <DllImport( "fcvb.dll" , CharSet:=CharSet.Auto)> _ Function dllBIN2_iv( ByVal price_u As Double , ByVal ex As Double , ByVal d_exp As Double , ByVal d_v As Double , ByVal price As Double , ByVal rate_ann As Double , ByVal acc_rate As Integer , ByVal cost_hldg A ...Show All

• SQL Server Is server downgrade possible?

  Hello, my question is simple, i guess, if anyone can help me solve this problem: I just installed Windows 2003 SBS Premium R2 but i have a software using SQL Server 2000 and not the one included in this version, 2005 wich is not compatible with. How can i downgrade, where cand i get the older server if the downgrade is possible and what else can i do before i shoot myself Is there any license issue that will not allow me the downgrade Thank You!!! Well, i don't have an older SQL 2000 database backup (also don't have a prior SBS 2003  server release) because we never used SQL before, version 2005 is uninstalled already but i don't know where from to download/get the SQL 2000 server as long as "Microsof ...Show All

• Visual Studio Express Editions form inheritance and DataGridView

  I've encountered the following: when you inherit, say, a form with a button on it (the button's Modifiers property set to protected), it is possible to change that button's properties in the inherited form. But when you try this with DataGridView, all properties are grayed. However, it is possible to assign them by editing *.Designer.cs file directly, so I think it is a bug in the IDE. One more thing I've noticed: the inherited form's grid has TWO (Name) properties in the Properties editor. Any comments PS. As I see, there is no Inheritance Picker in the Express edition. Probably, this feature is removed for simplicity or something, but it isn't mentioned in the editions comparison table. Is there any other table with more ...Show All