MMS2006's Q&A profile

• SQL Server Migrate AS2005 Cube to New Version of Source DB

  Is it possible -- and how straightforward is it -- to migrate an existing AS2005 Cube (and/or at least it's dimensions) to an updated version of my source DB (SQL 2005) I had little choice but to establish a "dev-and-test" version of the source DB during enhancements that coincided with production analysis and reporting. Now that I've approved the "dev-and-test" version, I want to make it our production master for OLAP. As a note, I don't believe that any of the fields used in the cube have been modified. We've just added some new calculated fields (and sp's). I have little idea of whether this will be simple, hard or impossible. I'm planning to try, but wanted expert feedback first. ...Show All

• Visual C++ self-made hashtable extremely slow compiled with VC2005

  Hi, I have a problem, and at the point I'm clueless what to do. The problem is, my app becomes extremely slow when compiled with VC2005. Application runs in half hour when compiled with VC6 or VC7, but now, compiled with VC8 it seems to take several days. I'm having this homebrew hashtable implementatation because of portablility reasons, whose probes seems to consume most of the cpu -time according to profiler. It takes 40% of cpu, while normally its something like 1%. But because whole execution time jumps several hundred percents, this alonr doesn't explain it all. And weird enough, simple little timer app I made to test the hashtable runs just fine. I'd be happy to stick with VC7, but I need to have 64bits becouse of memory consumptio ...Show All

• SQL Server Trigger Question

  Dear Experts; I'm trying to create a trigger that replaces a login ID field (LOGIN_EMPL_ID) with the correct data to make it LDAP compliant with our A/D. We create logins in A/D using last_name & if a last name already exists, we use 1st initial + last_name. With the trigger below, regardless if there are duplicate last names or not, the first initial is always getting added to the last name when populating the LOGIN_EMPL_ID field. I'm sure the problem lies in the use of the “Select Top 1” in the statement, but I fail to see how to get away from using this so I don't get a multiple rows error in the sub-query within the IF statements. Any ideas Thanks for your help CREATE TRIGGER tr_Updt_Login_Empl_ID ON [TC ...Show All

• Visual C# detecting close button of browser in C#

  Hi all, i am developing an application in which i want to perform certain action when user clicks on the close(X ) button of the web browser. Please anyone help me out to resolve this issue.Any tutorials or sample application would also be helpful. Regards. Hi spshah To do it, you've declared a System.Diagnostics.Process object and set it's attributes, then started it using the Start() methd; yes So simply do one of these : myprocess.Exited += new EventHandler(myprocess_Exited); In this case, your app runs and whenever the process you've started, ends(simply when it is closed by the user, or even if you've terminated it yourself) this event is fired and so forth. or: myproce ...Show All

• SQL Server uninstall SQL server 2005

  Hello after uninstall SQL server 2005 by tools (vs_uninst_betas) still exist in program menu. How can uninstall definetly. Thanks you. See this post http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=554589&SiteID=1 ...Show All

• Visual C++ Warning when using an Assembly in C++ that was built in C#

  I have an assembly that I'm building using C# and an application that I'm developing in C++ that uses the assembly. I have both of these projects in the same solution. Everything was working fine but recently when I build the C++ applications I've begun to get the warning listed below. I get this warning for every object I've defined in the C# assembly. Any suggestions would be appreciated Warning 1 warning C4945: 'PositionEstimator' : cannot import symbol from 'c:\documents and settings\douglas havenhill\my documents\visual studio 2005\projects\controlpointlibrary\controlpointlibrary\obj\debug\controlpointlibrary.dll': as 'Doppler::ControlPointLibrary::PositionEstimator' has already been imported from another assembly 'ControlPointLibr ...Show All

• .NET Development How many ways can process.MainModule.FileName fail?

  I am trying to acquire a definitive list of ways in which Process.MainModule.FileName can fail, and which are recoverable. Other than the two documented exceptions NotSupportedException and PlatformNotSupportedException, I have discovered, through web searches and experience, that several other failures can occur - generally due to either a) the process object not yet having been fully set up after the process start (in which case a Thread.Sleep(0) and a retry will eventually succeed), or b) because the process has terminated since the Process object was acquired. According to one website it can fail with an InvalidOperationException, possibly because the process has exited. It can certainly fail with a Win32Exception if MainModule is n ...Show All

• Visual Basic Internet

  Hi everyone, I have a HTML page with a script. The page have 2 textboxes, names exp1 and ans1. I want, through VB, to write some text in exp1, then to simulate the type of Enter in it, and finaly, to read the data in ans1 into a variable. Does anyone know how can I do it Thanks, Ofir. Hi Ofir, If the above pseudo code did not help, you will have to post some sample code of what you are trying to accomplish and explain where you are stuck ...Show All

• Visual Basic [2005]Text to text tagged with BB Code

  Hey i wasn't quite sure where to post this topic i am trying to program an application that converts text to BB Code Example :- If u write something in the top text box and code is checked then once u click Tag It in the second textbox the text will be wrapped in BB Code i am not sure how i go about doing this would be great if some 1 could pls help me :) just can't seem to do this but without brackets so the resulting text comes ut looking like ([code]please help me[\code]) in text box 2 so maybe 1 example would be great on how to do this would be greatly appreciated thanks How about something as simple as the following which will scan all the check boxes on a form and only include the ones that are checked in the tags. What ...Show All

• SQL Server Deployed reports have javascript errors?

  Hello- I have developed a number of reports on Win XP with VS2005. They run on our development server, which is running Windows Server 2003 32-bit. I then deploy these reports on our production server, which is running Windows Server 2003 64-bit edition. Accessing any of the reports from Report Manager results in javascript errors, such as 'Line 41 Error: 'RSClientController' is undefined' I get these errors also when invoking these reports through a form post. It appears that some javascript code generated by the report server is missing. Could this be a 32-bit vs 64-bit issue Report Manager seems to work fine; it is only when I run a report that I have this problem. This is the first time I've tried to deploy reports to this server. Tha ...Show All

• SQL Server SQL 2003 and SQL Express

  Hi I would like to install SQL express on a PC which already has SQL 2003 - I use enterprise manager to manage a database. I require express as part of a teaching role (my students have installed it). Is is possible to do this or should I remove the full version Regards Eddie hi, SQL Server 2003 does not exist.. but you can install SQL Server Express (or other SQL Server 2005 edition) side by side with SQL Server 2000 instances.. regards ...Show All

• Visual C# Renaming a file

  Hi   I hope some can help me. I need to rename a file. I can't use a move or copy and delete, as these are too slow. The folder is being monitored and as soon as the file entry appears in the directory the expectation is that the file is complete and ready for processing. The monitored could be anywhere on the network. At the moment I am using : Microsoft.VisualBasic. FileSystem .Rename(tempFile, filename); And I have tried : File.Move(tempFile, filename); I don't know whether Move (C#) or VB.Net FileSystem .Rename equates to Copy and Delete underneath. I'm using C# 2.0. Any help would be greatly appreciated.     Thanks Tom and Matthew. Speed is d ...Show All

• Visual C# Problem with Keystroke Capture...

  Hello, I'm having a problem in C#. I want to set up my form so that the use presses a button, then the form will capture a single keystoke and then be done. Here's what I have: private void button1_Click(object sender, System.EventArgs e) { this.KeyUp += new KeyEventHandler(OnKeyUp); } public void OnKeyUp(object sender, KeyEventArgs e) { MessageBox.Show(e.KeyCode.ToString(), "Your input"); e.Handled = true; } If I use the KeyDown the arrow keys won't be captured. What am I missing here Sorry if this is simple, I'm trying to learn C#. Thanks! ahmedilyas wrote: yes I guess you would need to set it as a global private variable, ...Show All

• .NET Development how could I change the Client's IP address automatically through C#

  Good day to all experts, how could we change the client's IP address automatically using C# programing make it realization . I have a small program running at the workstation ,I wanna C# programm may automatically connect ADSL and 30 seconds can closed ADSL connection. Thank you very much for your help regarding this matter. Have a nice day to all thanks ahmedilyas! Could u tell which C# API can connect ADSL and after 30 seconds close ADSL connection automatically thank you! ...Show All

• Visual C++ unresolved external symbol because of a further function

  Unfortunately I have one more problem, I have now the following: the header file: [code] #include <iostream> namespace main_savitch_2C { class statistician { public: void next(double r); private: bool operator ==(const statistician& s1, const statistician& s2) { return true; } [/code] and my testfile: [code] #include <iostream> // Provides cout, cin #include "stats.h" using namespace main_savitch_2C; using namespace std; int main(int argc, char* argv[]) { statistician s1, s2, s3; if (s1 == s2) cout << "s1 and s2 are equal." << endl; else cout << "s1 and s2 are not equal." << endl; } I know that the operator== function is not ...Show All