anubisascends's Q&A profile

• SQL Server execution of stored procedure has become extremely slow!!

  Hello, i am not sure if i am posting this problem in the right forum. please forgive my ignorance, if indeed i am doing so. i am having a bizarre problem with the execution of a stored procedure on SQL server. up to now, the execution time was taking maximum ten minutes and then suddenly since a few days ago, it takes more than 40 minutes, no exceptions!! i have tried to diagnose this problem with some tools that are provided out there such as executing a stored procedure called "proc track_waitstats" from which i learned that the “max degree of parallelism”. needed to be set (i set it to 3, it used to be zero. there are 4 processors). after rerunning the diagnosis, my SQL server seemed very happy with wait times. zero for almost everythin ...Show All

• Visual C# Creating User Help for a Windows Application

  Hi, I am writing a windows application in C# using VS2005. I have added an item on the menustrip and called it "Help". I have created a form called "frmHelp" that will open if the user clicks help. Now I am wondering how I can get the help content into the form. I am assuming that I will store the actual help content in a database. I would like to be able to have imbedded links and various colors and sizes of fonts in the help text. I have done some searches and can't seem to find out how to go about doing this. Can anyone point me in a direction or give me an example of an application that has help thanks Barb I actually meant the "forward" button, what ...Show All

• .NET Development Send Email from C# Executable

  I know how to send an email message from a C# web program but how do you send an email message from a C# executable Thanks for any help you can provide. Mike hii what's the stmp and pass my email in hotmail but i donno what is the stmp and pass g0000d bye ...Show All

• Visual C# Converting a string to int

  I'am building a console program and need to convert a string that the user types to an int. If I use convert.ToInt32 a get the ascii code for the number but not the number it self. can anyone help me find a easy way to do this, if there is one :) can't edit my post due to the forums being down unfortunately..... the code above posted goes through each character and checks to see if its a Digit, as your code has, and of course will fail when you get a non digit character like - (minus) for example. you could do in your code Char.IsDigit(str(i)) but no idea if this would make a difference. My apologies if this does not work ...Show All

• Visual C++ How to convert unsigned char __gc[] to char[]

  Hi, I am new to C++ .Net and currently running into a problem of type conversion. I have a unsigned char __gc[] and I need to convert it into a char[]. How do I do that Thanks for your help! Feng Suggest reading How to: Marshal ANSI Strings Using C++ Interop How to convert from System::String* to Char* in Visual C++ 2005 or in Visual C++ .NET ...Show All

• Visual C++ MFC ActiveX built with /CLR fails to load

  We need to use UserControl-derived components written in C# in our existing MFC application. The components need to be inserted into existing ActiveX controls (written using MFC and ATL as separate OCX files). The recommended way is to turn on the /CLR switch and use CWinFormsControl class. Using this approach I was able to insert a simple test component into one of our ActiveX controls and successfully build the OCX in Debug mode, however when running the application I noticed that it fails to load the modified ActiveX control - when the app tries to create an instance of the control it fails with the following error: ClassFactory cannot supply requested class. The same load failure occurs even when I completely removed the test component ...Show All

• Visual C# Operator '+' cannot be applied to operands of type 'T' and 'T'

  One day, the Microsoft C# team will stop treat us as kids, and this code will become possible:   public static ABIDataVoidNull<T> op_Addition_NV_NV<T>(ABIDataVoidNull<T> inValueL, ABIDataVoidNull<T> inValueR)        {            if (inValueL.IsVoid)            {                return (ABIDataVoidNull<T>)inValueR;            }            else if (inValueR.IsVoid) ...Show All

• Visual Studio How to generate Dyamic crystal reports ?

  I am having two dropdown list box . Which the use has to select the starting date and ending date . With the help of his input i should develop crystal report . How to do it . I am using c# and Sqlserver . Regards, Raghu Thank u very much . As i am new to crystal report i dont have any idea about it . Can u please send any sample code or any others source code url . Regards, Raghu ...Show All

• SQL Server updating nodes in a nested set model

  We have a nested set design in our database. The design allows multiple instances of nodes in the hierarchy. Each node has a combination of node name and its instance id as the primary key. We also maintain a unique_qty column that has the unique number of nodes below a particular node. This unique qty basically ignores the multiple instances of nodes below it and counts only the distinct node names(ignoring their instance ids). the problem that im facing is...how do i update the unique_qty when i perform any move in the tree. Thanks in advance satya phani You should be able to subtract the total unique qty of the sub-tree being moved from the all the ancestor nodes of the source and add the tota ...Show All

• SQL Server Column mapping in SSIS

  Hi, My Destination columns are more than source columns.... So, how to do column mapping if my source and destination columns are different Thanx, Ruja If you simply have more columns in the destination than the source, you can "ignore" the destination columns that don't map to the source, and they'll simply get NULLs (or the default value if defined in the database schema) inserted into those fields that you ignore. You don't have to match on the number of columns. ...Show All

• .NET Development how to send X,Y mouse postion..

  there is a server and a client.. i connected them using sockets.. i want the Remote "client" app. to draw when i move the mouse on the host"server" app.. i got the mouse position from the onMouseMove () but i dont know how to keep sending the coordinates to the client so it can paint.. thnx. I think i have a good idea to solve the problem: byte: 0 ~ 255 This is a sample: x : 800 y : 450 You send the byte[] bt like this: bt[0] = 3 bt[1] = 35 bt[2] = 1 bt[3] = 195 When you receive the byte[] in client app,you can get the result: x = 3*255 + 35 y = 1*255 + 195 Wish helpful. ...Show All

• Software Development for Windows Vista BUG: Why does the name of a StateMachineWorkflowActivity property appear as "State Machine Worflow"?

  I have a custom activity defined like the following (see below). BUG: When this custom activity is used in a workflow, why, in the VS2005 Property window, the name of the ForkStateMachineWorkflow property appear as "State Machine Workflow" (with the spaces and without the quotes) - instead of ForkStateMachineWorkflow REPRO: You can test this using the CustomActivityBinding .NET 3.0 RC1 SDK sample. Michael. using System; using System.ComponentModel; using System.Workflow.ComponentModel; using System.Workflow.Activities; namespace Microsoft.Samples.Workflow.CustomActivityBinding { public partial class CustomActivity : Activity { public CustomActivity() { Initialize ...Show All

• .NET Development Trying to learn website design

  Hello Ladies & Gentlemen! I would love to be able to make a website to include pictures....could someone please tell me the requirements that i need to get started... I am a complete novice so please if you reply be gentle with me! Regards ...Show All

• Visual Studio 2008 (Pre-release) Requiring parameters in messages

  If I have an operation like: int AddIntegers(int int1, int in2), it seems like I can invoke this message by sending a message that does not have the int2 parameter, i.e. a message that looks like: <soap:Envelope><soap:Body><int1>2</int1></soap:Body></soap:Envelope>. WCF will assign the default value to int2 (= 0) and it will work as if nothing was wrong. What is the best way to make parameters required I find it strange that parameters are optional by default and not required. I know that the DataMemberAttribute has a IsRequired property, but how do I make the method parameters themselves required I was hoping to do something like: [OperationContract(RequireParameters = true)] int AddIntegers ...Show All

• Software Development for Windows Vista Page Limit?

  Does anyone know whether there is a page limit in an XPS document I have created a 10,000 page XPS document printed with the Microsoft XPS Document Writer from Crystal Reports XI. I can open this document in the XPS viewer with no problems. However, when I create a 100,000 page document using the same package, the XPS document does not open in the XPS viewer and the memory use on my computer jumps and keeps on rising. I am working on Windows XP. Any ideas, anyone Thank you CTA, This information is very useful. In further tests I was able to print upto 30,000 pages using the MXDW in non-interleaved format. I will need to look at the zip32 limitation. My document is quite simple though (1 logo on ...Show All