Thierry Bouquain's Q&A profile

• SQL Server msmdsrv.exe is taking 99% cpu

  I've tried rebooting the server, restarting services, etc, but that only seems to help for about 5-10mins. When the cpu usage was that high, I profiled the cube for a 3 minute period and no queries were being performed.   Is there a way to narrow down what (and why) might be causing that process to hog so much CPU time and making the whole server slow More info: When the server acted up, it was always from the same user. I looked at their setup, and their permissions are done through windows domain groups and the 2 groups in which the user is placed put them in 2 different roles - which each have access to 1 section of a customer region. I took the person out of one of the roles and t ...Show All

• Visual Studio Filtering Dynamic Help

  Hi all, I'm wondering if there's any way to make Dynamic Help display topics related to only C++ (or heck, only the language of the file I currently have displayed, if that's possible). When I place my cursor on a C++ type, I don't want help about Microsoft.Jscript, or "How to: use the webservice attribute", as those have absolutely nothing to do with C++. Is there any way to make Dynamic Help a bit less uselessly dynamic P.S.  I'm using VS 2005. Can you tell me whether the file was opened as part of a C++ project or directly in the IDE Opening of the file as part of the project does produce better results. There is no way to apply a filter on the dynamic help. What one can do is to change the a ...Show All

• SQL Server Looking for a good example of a script task in the dataflow that writes to a file

  I need to write back to a legacy system in the form of flat file --the first row would be a header and the remaining rows would be the actuals rows of data--each field would have a column delimiter of , and a row delimter of CRLF. The source is a SQL Server 2005 table. Im looking for a good example of a script task in the dataflow section that writes to a file. Can anyone show me the code how to do this or point me to a link. thanks in advance Dave Mr Pro Tools wrote: Jamie, No there is not an example in Donalds book that explains how to produce an output file. He covers how to write a Dataflow script task to produce an XML output File--but that is a very different obje ...Show All

• Windows Forms UserControl Background Color

  Hi I have created one user control with label and image. In Window classic it looks ok i.e with white background. In XP style(blue and green) also it looks ok. But when style is gray,background becomes black. How can it be addressed I want my user control to look same irespective of the thame. Is it possible. If you set the background colour to "Control" it will use the theme colours. If you want to ignore the user's colour settings you must manually set the colour of the control to a specific colour. ...Show All

• Visual Studio Express Editions Help! With a class project

  I am fairly new VB .net and I need help with a class project. I have to use an array in one-dimensional . I don't know how to start this project. Any suggestions. A really open ended question - class project , use one dimensional array. What do you want to do with the array. Its really a data structure to store something - Blackwood has shown how to declare and assign values to the elements but if your have a specific task in mind or are having specific problems let us know - outside of that you really asking a very vague general question. ...Show All

• SQL Server past and future date

  How should I find the dates for 3 days past and 5 days future. Such as TodayDate-3 and TodayDate+5 base in the date only, discarding the time This is likely to be a bit more efficient, since it doesn't require converting from datetime to varchar: SELECT dateadd(day,datediff(day,0,getdate())-3,0) AS [3 Days Ago], dateadd(day,datediff(day,0,getdate())+5,0) AS [5 Days from now] Steve Kass Drew University www.stevekass.com JIM.H.@discussions.microsoft.com wrote: > How should I find the dates for 3 days past and 5 days future. Such as > TodayDate-3 and TodayDate+5 base in the date only, discarding the time > > ...Show All

• SQL Server History Id and SnapShot Id

  Hi, Wanted to clarify some doubts about Report History and Snapshot. 1. What is the difference between the snapshot id and history id. Report Snapshots are stored in the report history. When I call CreateReportHistorySnapshot method programmatically, the method returns a history Id. Is this id different from the snapshot id (report snapshot which is stored in the history). If the id's are different how can I get the snapshot id 2. The History id is a date-time stamp of the snapshot. This string is used as a unique identifier for the historical snapshot. It contains the time portion till seconds(not milliseconds). Hence if I generate the next snapshot in the same second it gets overridden. Is there any way to create more sna ...Show All

• SQL Server Question about RS2k user logon window

  When I'm trying to logon the reporting service main page, the user logon dialogue box will ask you to input the authorized user id and password(It's the account created in windows system). But when I try to open certain report!on my reporting server, this logon dialogue box will be displayed again and I have to input the account and password again. All the reports can be directly opened after second entry. So my quesition is how to setup reporting service so that I can open all the reports directly just after the first entry.That will bother users to browse report!freely only after inputing authority information twice. PS: My platform is Windows 2K Server SP4 + SQL Server 2K SP4. edward ...Show All

• Visual Studio Express Editions Getting a specific section of an image and blitting it

  Hello, I'm writing a map editor for a game that me and my friend are coding, and I can't seem to figure out how to get a 32x32 section of an image, and blit it onto a tile in the editor. I also cannot figure out how to load the image into a GroupBox using an OpenFileDialog. What I really need to know is the following: Getting any 32x32 section of an image (by coordinates of the image) and blitting it into a pictureBox on the map editor, and loading the original 320x320 bitmap into a groupBox for the tiles. Any help is appreciated. ...Show All

• SQL Server How to control format of datetime attributes?

  There is an attribute that have type DateTime, based on the field type in data source. It hasn't separate name column. The member caption is formatted as yyyy-MM-dd hh:mm:ss. Can I control the format of Member name without giving separate name column. I assigned different format in the format field of key property window, but it had no effect. What I did wrong Thank you, I thought about more sofisticated solution, that can be used in multi culture environment without adding x additional fields with "formatting" of a datetime attribute. I hoped, that the AS2005 is smarter as AS2005 and offers more possibilties. Do you know what is the format field in key properties for ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Problems using BasicEffect

  I using vertex shader to show some triangles and a cube (merging two XNA help example), every thing work right. The same thing if I use Effect, but when I use BasicEffect (only for cube) it don't work: drawing cube it siple make background black (Clear use other color). Here my code that don't work: device.VertexShader = null; // Don't use previous Vertex shader. basicEffect = new BasicEffect(device, null); basicEffect.AmbientColor = new Vector3(1); basicEffect.DiffuseColor = new Vector3(1); Viewport viewport = new Viewport(); viewport.X = 0; viewport.Y = 0; viewport.Width = graphicsComponent.BackBufferWidth; viewport.Height = graphicsComponent.BackBufferHeight; device.Viewport = viewport; basicEf ...Show All

• .NET Development cpu usage

  Hi, I have a stand alone application which is CPU consuming and I want to optimize the CPU usage for that application. I though about setting the priority of the application / process to high or even Real-time. My question is how do I do that from the code c# (Visual studio 2005) and do I have other things that I can do to optimize the CPU usage thanks :) How do I change the priority of process (current program) through the code ...Show All

• Visual Basic Run time Error

  Private Sub cmd_DeleteTables_Click() MsgBox "Click yes when prompted to delete records" Dim sqldel As String sqldel = "DELETE tbl_physical_main.*, tbl_physical_main.[Material Number] FROM tbl_physical_main WHERE (((tbl_physical_main.[Material Number]) Is Not Null))" DoCmd.RunSQL sqldel, no sqldel = "DELETE tbl_noDataForTag.* FROM tbl_noDataForTag" DoCmd.RunSQL sqldel, no sqldel = "DELETE tbl_SAPmaterials.* FROM tbl_SAPmaterials" DoCmd.RunSQL sqldel, no MsgBox "All previous inventory data has been deleted and the next inventory load may continue." End Sub DoCmd.RunSQL sqldel, no after delete the record I have run time error, Please advice. Gee1 ...Show All

• Visual Studio Team System Subscription problem

  I have some problem with project's alerts in Team explorer. I 've made project's alert with Build completes event. I 've received e-mail about this event. However, I've made project's alert with Anything is checked in event. I haven't received any e-mail about this event. I 've checked in Tfs_Integration database and I found the record in dbo.tbl_subcription table with this event and my e-mail address. It is a bug in Team explorer Few tips: For more troubleshooting http://blogs.msdn.com/psheill/archive/2005/11/28/497662.aspx is helpful. This post deals with checkin notification and might help: http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=384113&SiteID=1 ...Show All

• Microsoft ISV Community Center Forums Summing up hours on form based on parameter query

  Hi there - im finalising my new activity system but i have one issue. on an activity form i have certain fields for information purposes that are non editable - they are 'hours worked with client' , 'hours worked this month' and 'hours worked for the day'. The first 2 fields are populated automatically by opening recordsets on form load or companyname exit and summing up the hours based on the relevant query where the criteria ensures that the query is already populated. However for the 'hours worked for the day' field the query is a parameter query (qrytodayhours) where activitydate = Forms![frmactivity]![activitydate] and i was then hoping to enter the following code to sum up the hours using a recordset on the on exit of the acti ...Show All