RahulMittal's Q&A profile

• SQL Server Execute multiple statements at once...

  I am not even sure if this is possible but I want to be able to excute several statements (or SPs) at once from inside a SPs (or any other method). What I am doing is a I am taking data from a single column, multiple rows and making it into one row (i.e. data1 + data2 + data3....) But I am doing this to a total of 2.1 million individual rows and the result will be about 204k rows.... what I have written is basically a nested loop and it works fine but very slow... slow as in it has been running for 24 hours now and it is about 60% done... I need this to finish in under 36 hours preferably... If I could handle more than one set of data at once (there will be no duplicates) I could speed up the process by how ever many I feel like work ...Show All

• Visual Studio Script error using online help

  Just installed Visual Studio Standard after uninstalling the express versions. Now when I use online help I get a script error as follows: Line: 28 char: 9 Error: 'DCSext' is undefined Code: 0 URL: http://msdn2.microsoft.com/en-us/library/fyf1dk77(d=ide).aspx Do you want to continue running scripts on this page Anyone else have this problem Didn't have this using online help with any of the express versions. It works but it is curious why this started after the new install. I experience this problem and is about to crack up if I dare say. It's mainly when the navigation pane is building up, and it is usually between 5-12 popups everytime online help is to show a topic. It really give a non sense feel to it. Undef ...Show All

• Visual C# Run C# application remotely. How ?

  Dear All, I have a doubt regarding the .NET architecture and I want to know is it possible to do the following. I have a server called MAIN SERVER which is connected to OTHER SERVERS. This MAIN SERVER can be considered as gateway which is connected to all OTHER SERVERS located at different geographical locations. I have a desktop application in CLIENT 1 connected to MAIN SERVER through LAN. I would like to create an application architecture where the application at CLIENT 1 should post a request to MAIN SERVER to ping OTHER SERVERS. In turn the MAIN SERVER should ping the OTHER SERVERS and respond back to the desktop application at CLIENT 1 and application at CLIENT 1 should display the result I would like to do this with th ...Show All

• SQL Server Reporting Services MemoryLimit

  We're having trouble with memory configuration in Reporting Services 2k5 SP1, running on Win 2k3 SP1. We have a very large report, which we've been running to benchmark performance.   First, here are the results of our testing: Initially, the server had 512mb of RAM. When running the report, the w3wp.exe process used up to 400mb of RAM and Reporting Services usually timed out before delivering the report. We increased the RAM in the server to 1024mb, and found we could run the report. It took around 02'30" to complete, and the w3wp.exe process peaked at 520mb of RAM usage. When we tried to run two instances of the report concurrently, RAM usage peaked around 800mb, and Reporting Services timed out before delivering the ...Show All

• Software Development for Windows Vista Package Load Failure after installing VS Extensions for Workflow

  I saw this problem during the WF betas, but now I have a new machine with a clean install of VS2005. I installed the ".NET Framework 3", "Windows SDK for Vista", and then the "Visual Studio 2005 Extensions for Windows Workflow Foundation" (in that order). After installing these components, I receive the following error when I open Visual Studio: Microsoft Visual Studio Package Load Failure Package 'Microsoft.Workflow.VSDesigner.DesignerPackage, Microsoft.Wirkflow.VSDesigner, Version=3.0.0.0 Culture=neutral, PublicKeyToken=31bf3856ad364e35' has failed to load property. ... Would you like to disable loading this package in the future You may use 'devenv /resetskippkgs' to re-enable package loading. ...Show All

• Visual C# Fade background like WinXP

  I would like to simulate WinXP shutdown's background fade to grayscale. How can I achieve this on my app's quit when I ask user "are you sure you would like to quit" else return to full color. Thanks for any ideas how 'bout trying and capturing entire screen to bitmap, drawing to fullscreen and then showing your form / message box above it ...Show All

• .NET Development WSE 3 add in VS2005

  Hi everybody, Dispite all the treads on the internet, i did not solve my problem with the missing WSE 3 add-in in Visual Studio 2005 pro. I tried all the tips i found on the web, but nothing seems to work. Please help. Thanks, Jurgen how do you modified the generated proxy base class from System.Web.Services.Protocols.SoapHttpClientProtocol to Microsoft.Web.Services3.WebServicesClientProtocol thx ...Show All

• Visual C# VS hangs when trying to open/create a project

  Hi everybody! :-) all of a sudden, out of the blue, VS studio started to hang and become not responding when I'm trying to open or create a new project. It starts to load or create the project but than it just hangs and stops responding (not responding status). devenv.exe process gets stuck on 50% (+-1), and thats it. I tried to uninstall and reinstall, but nothing works! I'm out of ideas! HELP !!! Thanks a lot! Hmmm... Does the project that hangs have an open design surface that is hosting the COM control that you're talking about The designer surfaces (like the Windows Forms designer) create instances of the controls that are hosted on them when the form is shown, even at design time. ...Show All

• SQL Server Parameter not working

  I am pretty new to reporting services and hope some of you experts can help. I created a report from AS cube that has a column "Description" with 30 distinct values. The report has a multi-value parameter "Description" with the following details: Data Type : String Value Field: Description Label Field : Description The filter that i have on the table is =(Fields!Description.Value) = Cstr(Parameters!Description.Value(0)) When i preview the report i only see the top 1 item from the values that i select from the parameter list. What am i doing wrong Any help is appreciated. Thanks Thanks for replying. I just tried that. Now when i select more than one ...Show All

• Visual C# How to deploy an embedded file?

  I have a very simple console application I've written that copies a file from a DVD drive to the local temp directory. What I'd like to do is make it as idiot-proof as possible (you know murphy's law regarding end users...); to that end, what I did is to add the file to the project. Now, what I'd like to do is just take that file and copy it to the temp directory. What's the cleanest and easiest way to do this (Yes, I'm new at this...) Thanks! I thought that I could add the file as an existing item to the project, then set it as an embedded resource.  What I want to do from there is write a simple method to copy that file (or its contents) to an external file in the user's Temp directory.& ...Show All

• SQL Server Connecting to SQL Server

  Hi: I installed SQL Express in one of my Notebook A (XP Pro SP2), I could start writing code with VB6 as it is in local machine (.\Sqlexpress) At later stage, I used another Notebook B (XP pro SP1). I changed the notebook workgroup with the same name and try to connect to Notebook A with Ethernet Cable using SQLOLEDB to make connection, I had this Error Message "Test Connection Failed because of an error initialising the provider.[DBNETLIB][Connection Open(Connect()).]SQL Server Does not Exist or Access Denied" I look thru this forum, I quoted Jens K. Suessmeyer comment This simply mean that in a network you either will need all users to have their own database OR dedicate a "server" (which can also be ...Show All

• Silverlight (formerly WPF/E) Store image object in a javascript object

  I currently have an application that creates an image object in pure javascript using the following code: this._image = new Image(); $addHandler(this._image, 'load', Function.createDelegate(this, this._onLoad)); this._image.src = url; The neat thing about this is that I can wait with putting the image element into the HTML document until the browser actually has it loaded. So basically my onLoad function just add's it to the DOM and hides a progress indicator: $get('images').appendChild(this._image); this._image.style.height = "50px"; this._image.style.width = "50px"; $get('progressIndicator').style.display = "none"; Now, I want to do the exact same thing using XAML, but as far as I can see, you j ...Show All

• SQL Server Designing Custom Reports

  Hello !! Im'using Reporting Services SP2 on SQL Server 2000 SP3a. I work with Visual Studio 2003. I have some questions concerning the capability of Reporting Services : 1. Is it possible to use some Javascript in the expression. For example in the action "Jump to URL" I want to open a pop-up with information from the database. I found the following examples : =void(window.open('" & Globals!ReportServerUrl & " /ReportName&rs:Command=Render&rs:Format=Html4.0&Parameter1=" & Fields!Field1.Value & "','_blank'))" =window.open('" http://www.msn.com"','_blank' ) =void(window.open('http://www.msn.com','_blank'))" But I'm not sure that's avalaible for SQL s ...Show All

• SQL Server Beginner's questions

  Hello, I have two database servers that I am interested in sending messeges between them. I am not interested in security or encryption at this point, only a simple message sending and recieving. Can someone please provide simple scripts for object setup (certificates, queues etc) and message send and recieve a link to such a script will be great as well. I am just a bit lost understanding all the new concepts (certificates, service, service binding.....) Thank you I. I installed the tool and followed the instructions but all it did was to create a document with the service name and endpoint. what do I do from here Thanks I. ...Show All

• Visual FoxPro Can not draw on As Top Level Form with ScrollBars property is both in VFP 9.0

  Dear All I am having some problems in VFP 9.0: I used GDI+ and do some task to draw on a form. Init event: DECLARE LONG GetWindow IN Win32API LONG HWND, LONG uCmd WITH THIS gRealHwnd = IIF(.SHOWWINDOW = 2, GetWindow(.HWND,5), .HWND) ENDWITH Paint event: gpgraphics.CreateFromHWND(gRealHwnd) IF gpgraphics.gethandle() > 0 gpgraphics.DrawImageAt(gpBitmap, 0, 0) ENDIF It is ok if I set ShowWindow property is In Screen or As-Top Level Form and ScrollBars is none. But when I set ShowWindow is As-Top Level Form and ScrollBars is Both, it failed (can not draw). How to solve this problem Thank for reading. With a top level form you need the client hWnd. Try this: oGraphics.CreateFromHWND( SYS ...Show All