SolveIt's Q&A profile

• SQL Server Union in MDX

  I need to create a mdx statement which is an union of 2 mdx. The difference in each mdx is, it has an additional dimension slicer in each of the mdx. I have the same measures in all the both of the mdx. Is it possible to put a dummy slicer in all the 1st mdx to match the 2nd mdx since union requires same dimension. Below i have the mdx , i have put dummy here for me get an response as to what to replace there Bascially 1. First mdx query is by Division 2. Second mdx query is by Division and Application SELECT NON EMPTY { [Measures].[Nppi Record Count], [Measures].[By Div - Employee Average NPPI Count] } ON COLUMNS, UNION( {([Application].[Division Name].[Division Name].ALLMEMBERS * tail([Time].[Calendar].[Full Date]. ...Show All

• Windows Search Technologies Elementary questions about Desktop Search - please help

  I installed Windows Desktop Search and cannot find adequate help documentation on a number of features. I have a Server 2003 Enterprise SP1 OS. I have the recently released WDS 3.0 installed. Complaints: (1) Desktop Search replaced my Windows Search which I was familiar with. But it's much more complex to operate. (2) It's nice that it searches email, but the fact that it does so by default is a pain in the neck (3) The setup of desktop search is single-setup for all profiles. I have 4 people using this computer, and they should have different search setups, but WDS only allows a single one as far as I can tell. The single index for all profiles is stored in the "all users" profile. Let me know if you think this is ...Show All

• Visual C++ VS 2005 SE Compiler Errors with VS 6.0 Source Files

  Hello Folks, I recently installed VS 2005 SE and Service Patch 1 to upgrade a Win32 application that was previously compiled with VS 6.0. I tried a raw build to identify the broken code errors and got the expected <strstrea.h> file not found error. I replaced <strstrea.h> with <strstream> and got past the file not found error but that uncovered the following error c:\c++projects\physics_1\2dview.cpp(256) : error C2065: 'ostrstream' : undeclared identifier Likewise for the other classes in strstream. In addition I got a bunch of warnings WINVER not defined. Defaulting to 0x0502 (Windows Server 2003) So I placed #define WINVER 0x0502 in the project header file (Physics_1.h) where the <strstream> was in ...Show All

• SQL Server Agent Job logs on using Default User Profile

  Hi, I get a strange problem whereby I have set up a Sql Server Agent job to run as a particular user. The job needs to access details from the users local profile. The job fails to access the correct user profile when it logs in, and utilises the 'Default User' profile. This happens for scheduled jobs when the actual user used to run the job as is not logged into the machine where the Sql Server instance lives. If, however, the user IS logged in at the time of job execution, the correct profile is loaded. I can see this happening by simplying executing an OS command that kicks of a batch file with something like the following: echo %USERPROFILE% whoami When the user is logged in I see the results a ...Show All

• Visual C# communication between threads

  i am trying to write the sieve of eratosthenes multi threaded but am having a problem getting my threads to invoke and pass information to each other.Any one got any ideas yes i am but i want to keep the code as simple as possible. i solved the problem of creating another thread . my major one right now is creating and setting a global flag which i can change depending on prevailing conditions. i want a single thread to be able to create another thread only once in its runtime . i want it to execute a certian block of code once once and not do it again. any ideas PS does this forum alllow the posting of code it wud make my explanations quiet relevent ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Inputmapping component number 12342192 :)

  I'm sure there are lots of input mapper components about, probably a lot better written than this one as well, but nevermind, I thought I'd post it anyway. It's still in an alpha stage, missing keyboard sharing between multiple players, but its got some other stuff. Highlights: Delegate-based Binding to keyboard, mouse, 1-4 gamepads Allows saving and loading of custom bindings so players can save their own custom bindings (also provides a few functions to help implement a control binding interface). Allows method calling on Key UpDown, at specified interval, etc.. see http://wilco.34sp.com/GameLibrary for more details, comments always welcome :) ...Show All

• SQL Server SQL Server 2005 table Partitioning

  Hi all, We are planning to use the SQL Server table paritioning in our project. There is a very large table storing 12 years of data. This table would have 25 million records with approx 2 million records per year. We are creating a index with below mentioned keys PK_ID (INT) Rec_CreateDate (Datetime) If we create horizontal partition based on the column Rec_CreateDate, I have the following questions. 1. Will this improve the performance of the DML queries on the table 2. Should I have the partitions on the same file groups or place in different file groups 3. Will the query performance improve only if I include the column Rec_CreateDate in the DML queries or the Pk_ID column itself is enough Also , ...Show All

• Software Development for Windows Vista Question about Languages

  If I have my Windows Xp say in Italian and i would like to install the windows vista premium upgrade bought say in United States ... is it gonna give me the different language error Should I get only the ultimate version with the MUI options (but wouldn't I have the same kind of problems from an upgrade install ) Sorry if I posted in the wrong section. Thank you ...Show All

• Windows Live Developer Forums Live Messenger is Not Responding

  What should i do guys Any solution. WebMessenger isn't that good as Live Messenger is! Many thanks, kisses for you all :)) You should use this solution. http://msn-errors.blogspot.com/2006/12/live-messenger-is-not-responding.html ...Show All

• SQL Server Copying my SQL Database to another server

  Hi guys, I have created a new SQL database (named “DB”) on my personal pc at home. I want to copy “DB” to my job’s computer, which works on a local net with SQL server. What should I do Thanks a lot, Aldo. Hi Mathew, thanks for anwering. I want to know how to make the SQL database copy. I've tried copying the mdf file but getting some strange stuff. (I want to copy the table and views configuration). Thanks, Aldo. ...Show All

• SQL Server How to change identity to an existing column?

  Hi can anybody tell , Is it possible to alter existing column to add IDENTITY Thanks in advance Yes It is possible to add Identity Column to a table already have some data. BUT there is no such a command to alter a column to be an IDENTITY Column. You have to go through the following steps. 1. Create a same table with the IDENTITY COLUMN. but with diffrent Name 2. Move all data to the New Table, with IDENTITY INSERT ON option 3. Drop All constraints from the OLD table 4. Drop the OLD table 5. Rename the new table as the OLD table 6. Attach all constraints to the new table ... Hope that it will help ...Show All

• Visual C# How to replace a line on a text file without creating a new file.

  I am new to c#, I am using streamreader and streamwriter. However, I do I open a text file, replace the 5 line with a new string without creating a new file Thanks in advance. Hi, You can first create another file (diff file name from original one) which replace the 5 lines with new string, then delete the original one and try to rename the file (use File.Move() method) with the same name as the original one. Thanks. ...Show All

• Visual C# Error highlighting

  Hello, I've been working with NetBeans IDE (Java) for quite some time and now I'm learning C#. What disturbs me alot in the Visual Studio 2005 IDE is, that non-syntax errors that would lead to a compiler error are not highlighted until I compile my source code. For example if I'd return an integer although the return type of my method is void, the IDE wouldn't highlight that error until I'd try to compile the source. That's quite annoying to me since NetBeans IDE always did that and I'm used to it. Now my question is: Am I missing an option Is there a way to activate it Thanks for any help! The IDE simply doesn't do the sort of semantic analysis that is required to catch these errors before compilation. ...Show All

• Internet Explorer Development IE7 Toolbar Icons

  Is it possible to extract the IE7 toolbar icons for use in applications with web browser control or are these protected or inaccessible I've looked for them and can't find them. Indeed, they are in ieframe. Thanks. - I'm just making a slightly modified version of IE in VS2005 with the webbrowser control, and it's just for personal use, I don't plan to even distribute it. I am curious about whether it's legal though. MS makes a lot of their icons available for use but I haven't seen the IE toolbar icons anywhere so I don't know about that. ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. A problem drawing lines with color

  I'm working on a project where I do a lot of drawing with LineLists. I'm drawing from an array of VertexPositionColor format vertices with a BasicEffect, but no matter what color I set each vertex in the array to, they always draw as white if I don't change any of the BasicEffect defaults. If I change the DiffuseColor property of the BasicEffect, the lines will draw whatever color I set that to, but I need to be able to set the color on a per vertex basis. Am I missing something ...Show All