mbr_rptusr's Q&A profile

• SQL Server Help me optimize a daily events query

  We keep a database of events that are classified by severity. I've got a good, efficient query that gives me the grand total for these events. And I have a bad slow query that breaks down the information into daily totals. My fast query will count the totals for 3213586 events in 4 seconds. The slow daily query takes about 60 seconds for each day. Please help optimize my slow query! ------ Database schema is: Column Name Data Type Length Allow Nuls 1 msrepl_tran_version uniqueidentifier 16 0 0 [time] GMTtime (int) 4 0 0 msec int 4 1 0 offset GMToffset (smallint) 2 0 0 type nameType (varchar) 15 ...Show All

• .NET Development stack overflow and memory corrupt when use DsBrowseContainer

  [DllImport("dsuiext.dll", CharSet = CharSet.Unicode, SetLastError = true)] public static extern int DsBrowseForContainer(IntPtr infoHandle); public delegate int BffCallBack(IntPtr handle, uint message, IntPtr param, IntPtr data); [StructLayout(LayoutKind.Sequential)] public struct DSBrowseInfo : IDisposable { /// <summary> /// size of structure in bytes /// </summary> [MarshalAs(UnmanagedType.U4)] public int size; /// <summary> /// dialog owner /// </summary> public IntPtr handle; /// <summary> /// dialog caption text (can be NULL) /// </summary> [MarshalAs(UnmanagedType.LPWStr)] publ ...Show All

• Visual Studio Team System Context menu for work item returns "Index was outside the bounds" error

  Hi, In one of my team project, the "Add Work Item" menu item is giving me an error; it expands to " Error loading menu: Index was outside the bounds of the array " instead to a list of work item types. Anybody have any idea what might be causing this error Or where to get more information on this error Here are some additional information that might be useful: It is only happening in this one team project. Other team project are working properly This team project had been deleted and "recreated" (i.e. create with same project name). The original team project was using the MSF Agile template and the new one uses the MSF CMMI template. Nobody else in this team project is having this problem ...Show All

• Smart Device Development WindowsMobile.dll is missing???

  I want to add the reference to my project but when I try to add it I can't find the Microsoft.WindowsMobile.dll or the Microsoft.WindowsMobile.PocketOutlook.dll Where can I find them or download them Thanks, DD These are only available in WM 5.0 projects, come with WM 5.0 SDK. ...Show All

• Visual C# Writing a 16-bit grayscale image

  I have a byte array containing pixel values for a 16bpp grayscale image. I need a solution for converting said array to a bitmap image. So far I've come up with this: internal static Image imageFromArray(byte[] array) { const int WIDTH = 1472; int height = (array.Length) / WIDTH / 2; Bitmap bitmap = new Bitmap(1472, height, PixelFormat.Format16bppGrayScale); for (int x = 0; x < height; x++) for (int y = 0; y < WIDTH; y++) bitmap.SetPixel(x, y, (Color)array[(y * 1472 + x) * 2]); Image image = bitmap; return image; } But there is an error because I can't cast the byte as a color. So my question is, how do I actually translate my pixel data from the byte[] to the bitmap Is there a better way to do t ...Show All

• Internet Explorer Development css: How to colorize the border around a Drop Down

  Hi, Would somebody help me to colorize the select tag in a HTML page u cant.. Use java script 2 simulate select option menu's :)   Here is a page im working on  where i have use js insted of select. http://www.test.virtualdesign.dk/ I used a js script called "chrome.js" and modifyed it using css :) Hope i can be helpfule Martin   ...Show All

• .NET Development how to impersonate a local user in C#

  a shared folder was created on a server. and a local account also created on the server.i assigned this local account to this shared folder. i want to access this folder from a client. from a client, i try to impersonate the local account, but it fails. i used the logonuser() function which receive domain name, username and password. in this case, what is the value of domain name ex: machine name= devsrv,username=ysa, password=123, folder name=images i pass the following to logonuser() : domain="", username="devsrv \ ysa",password="123" but it fails. How can i impersonate the user For localuser accounts the domain = "." Se ...Show All

• SQL Server SQL 2005 Reporting Services SP2 integration with MOSS 2007 SSL error

  Hi, I have just installed RS and SP2 on a server running a MOSS 2007 (with SSL using an internal certificate) and configured RS to work on Sharepoint Integrated Mode. Then I went to Sharepoint to configure RS options, but when I tried to set up the Set Servers Defaults I receive the following error: An unexpected error occurred while connecting to the report server. Verify that the report server is available and configured for SharePoint integrated mode. --> Server was unable to process request. ---> The underlying connection was closed: Could not establish trust relationship for the SSL/TLS secure channel. ---> The remote certificate is invalid according to the validation procedure. Also, when I try to deploy a report ...Show All

• Visual Basic Tips & Tricks for Translation Required

  I have a ComboBox2.Text that it has Two Items of name 1 and 2 and i have a file of this type: Translation For My Tool [INFO] Language: Italiano Author: flash.tato [1] FileType: .mox Object1: Maxtor [2] FileType: .sek Object1: N/A I want that if ComboBox1.Text is 1 the Label1.Text is .mox and if the ComboBox2.Text is 2 the Label2.Text is .sek There is a good way Maybe that it is using ReadLine but how do i move the pointer in a line From 1st Line to 4st line how do i move You'll have to parse the text file somehow and create some kind of collection of ID values and file types. There are a number of ways to accomplish this. Here is one example: Dim FileTypeList As New Dictionary ...Show All

• Windows Forms Problem while adding reference to the project

  Hi, I have an api that is written in C which is complied into a dll. I try to add a reference to the dll but for some reason I get an error "Please make sure that the file is accessible, is a valid assesmbly or a com component". I have tried placing the dll in bin/debug, or the project folder. I can see the dll , so I can select it, but when I try to add it I get this error. I checked the privilages as well. Can anyone suggest what the error might be All help is very much appreciated. Thanks! Do I need to have the manifest file for the dll And do I need to put it in the same folder as the dll I think this may be the problem. ...Show All

• Windows Forms MDI Parent and Child form TaskBar question

  Hello All, I am writing my first MDI form using Framework 1.1. Everything is working properly with the Parent form and the various child forms that I open up within it (eg I can cascade, minimize, maximize, etc). There are 2 things which are causing me problems. One is that only the parent form is showing up in the TaskBar. We are running XP Professional and in Excel, if I have multiple files open, when you click the taskbar you get a combobox which allows you to pick which one you want to select. The old style way of separate task bar items would also be acceptible. The second thing which is related is that if I Alt+Tab I can cycle through open files and multiple Excel files will show up individually for selection purposes. I have n ...Show All

• SQL Server Out of virtual memory

  I have one package that is constantly running out of virtual memory, right now I am on a development server, running only this package. The package is moving data from one table into another on the same server in the same database. The server has 3 Gb of memory and is only running SS2005 and SSIS. I am a local admin on the server and running the package through BIDS, once again for our initial testing. I tried setting the property BufferTempStoragePath to our E drive so it can utilize the 100 Gb of free space we have but that doesn't seem to work either. I have also tried setting the MaxRowSize to many different values to no avail. I am constantly getting an error, see below for exact error, when it gets through roughly half the load. More ...Show All

• SQL Server Problem extracting data from multiple list boxes

  I have a report that has a header section with three detail sections.  The header section contains information pertinent to a person and a situation.  The detail sections each contain information pertinent to the situation and person in the header section.  I have been able to format the data correctly but I am unable to have the unique information per person extracted for the three detail section.  I am using data from four stored procedures, one for the header information and three for each detail section.  sample detail data: sit1desc                        date     &n ...Show All

• Windows Forms setup.exe that doesn't require .NET 2.0

  I've created a setup project with VS2005 and can run my install fine on systems with .NET 2.0. On many of my customer's systems, they do not want to install .NET. Currently when I run my setup.exe it goes off and tries to install .NET 2.0 first and fails if I don't. How do I create a setup.exe/.msi that does not require .NET 2.0 on the system doing the install David, In case I would to have the .net 2.0 redistributable as light install (Like online mode) Is it possible So when the user close the application also the .net 2.0 remove and no footprint remains on client computer, maybe having this advantage can be used on end-user computer which do not want (or the IT) install third party appli ...Show All

• SQL Server Copy Flat File between two server; Help me please.

  Hello All, I want to copy flat file(.txt) from server to another server. server A(Source Folder) ====> server B(Achive Folder) Can I do it Please, help me. Thank you very much. Chonnathan Hi again, Now, I want to use SSIS to process data from text(banking transactions, credit card) in daily process. but source file was in another server. In this case how can i do to get source file to precess in ssis on other server. thank you very much. My english skill is not well, sorry. ...Show All