Charles Tam's Q&A profile

• SQL Server single node cluster

  Is it possible to setup an cluster with sql server 2005 as single node cluster - and lets say in 4 month we add the second node to the cluster - its because of budget and we do not want to setup then again. Thanks for your help, HANNES It is a good practice to use hardware that has been certified by Microsoft for clustering purposes. It's also for the better to use identical hardware in order to avoid extra troubleshooting You must keep in mind that the 2nd cluster should be able to 'bear' the load of the 1st cluster at any time. So if your primary cluster has say 10 GB RAM and you have added PAE extension, you should not add a 2nd cluster that has less than 10 GB of RAM or without PAE. The clusters must be able to h ...Show All

• Visual Studio 2008 (Pre-release) UserControls in the same project

  I'm using the RTM of WPF but still don't have a clear understanding of how to access usercontrols withing the same project in Xaml. Is there a way to do this or not I've been getting by with instantiating the controls in code behind, but I noticed that the release note whick explicitly states this is a bug is now gone in RTM. What exactly in the syntax for doing this ! ! No. The tools for Visual Studio are still CTP, even though the framework is RTP. We apparently will not be getting another version of "Cider" for VS 2005 either... it will be for the next version. ...Show All

• .NET Development CLR and MyBase.Dispose() in WinForms

  I'm curious on how the CLR determine which flag to send as argument to VS2005Designer-generated MyBase.Dispose()-function if I close an application by calling <appl>.Exit only. Clearly it is boolean True (dispose both managed and unmanaged memory). The thing is that when I use <appl>.Exit, i.e call MyBase.Dispose(True) indirectly the application takes very long time to close down. If I, on the other hand, call MyBase.Dispose(False) explicitly the application close down immediatly. Is there anywhere I can tune CLR as regards these flags Dispose(True) is the normal call from your own code, Dispose(False) is reserved for the finalizer. The former takes care of a lot of cleanup; obviousl ...Show All

• SQL Server Currency Format Issue

  Please Help! I am stuggeling with a amount measure in my cube. The format of the measure is set to currency but i always shows the dollar($) sign no matter the regional settings or the language setting of the report. How can i fix this problem as i do not know where to start looking. Everyone keeps saying the currency will change according to the language setting of the report or language setting under properties of sql 2005 analysis services. Thanks in advance, Jacques kruger I have struggled with the same problem. This solution work if you have the same currency in a column: (### ### ### ###.##) or (### ### ### ###.##EUR) with a currency. Note the blanks as a thousand separator a ...Show All

• Visual Basic Login form + SqlDataReader

  How do i check-up a username and a password using an SqlDatareader Which member of the reader should I use to validate credentials if they exist hi chyna, please read the answers to this post: http://forums.microsoft.com/MSDN/showpost.aspx postid=1084443&siteid=1 you must reference the sql client in your code by placing on the topmost part: imports system.data.sqlclient fyi: this example is using oledb, just change the samples to sql example, OleDBCommand to SqlCommand and so on. good luck! dave. ...Show All

• SQL Server Triggers Priority

  Hello, I've got 4 triggers on the table A, all of them are executed when an insert occurs, which trigger is executed first (how does the dbms which one is going to be executed first) Could I assign a priority for triggers execution Thanks Jens K. Suessmeyer wrote: Hi, the trigger order is undefined except for the last and the first trigger which can be set. see the sp_settriggerorder for more information on that. HTH, Jens K. Suessmeyer. ---- http://www.sqlserver2005.de ---- Thank you so much !! ...Show All

• Visual Studio Release 2 Merge Module adding subdirectories to [Application Folder]

  I have a Visual Studio 2005 solution that contains a setup / deployment project to build an MSI to install a Windows Forms application. Several projects in the solution have rreferences to Crystal XI Release 2. To deploy the Crystal files I'm attempting to use CrystalReports11_5_NET_2005.msm; the March 2006 version. The install appears to run fine, however I'm not seeing any files in the GAC (c:\windows\assembly) with the 11.5.3700 version. They are all 11.5.3300. I believe the assemblies for Crystal XI Release 2 should be 11.5.3700 so I don't understand by 11.5.3300 DLLs are appeaing in the GAC. Second, the application folder (in Program Files) for my application has several new directories that appear to be specific to Crystal. F ...Show All

• Visual Studio 2008 (Pre-release) Back to back video playback: problems + inconsistent behavior

  Hi, I'm trying to play video clips, back to back, inside a canvas. My first approach was to hold two mediaelements in the canvas, and switch their visibility, loading the data in each element while the other was playing. This turned out to be unusable, as for some strange reason, the second element would consistently drop a lot of frames. I got this behavior even when the project was reduced to the bare minimum. If anyone has any idea why this is so, please don't hesitate to share the knowledge (using June CTP). I then tried to switch from direct MediaElement manipulation (Source, Play, Stop etc.), to the mediatimeline/mediaclock approach. This turned out to be very tricky, but after a lot of voodoo work (e.g, explicitly assigning null to ...Show All

• Visual Studio How to generate additional property for embedding elements

  Hi, I have That situation: "Container" is a root domain class "Component" is a base class for "FileComponent" domain class "Container" has "Component" (IsEmbedding=True) A generated class for the "Container" domain class has "ContainerHasComponents" property. I want additional property, like "ContainerHasFileComponents" for this generated file. The only one way, I have found, is a creation of the additional relationship from "Container" to "FileComponent", but it looks horrible on the design surface.... Is there any other way, may be, through some parameters, to specify the generation of that additional property for inher ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. 360 Deployment Issues

  Hello   I've downloaded the latest version of XNA: GSE, signed up to Creators Club, downloaded the launcher, created a key and entered it into GSE.  The 360 is sitting there waiting for a PC connection but the deployment just times out.   I've checked the subnet and they're both 255,255,255,0. It doesn't work whether it's wireless or wired. I can't ping it from the PC, it just times out. Got another pal to try pinging their 360 from their PC and they get a similar time out.   I've also made sure all the required ports are open, I think.  I'm not sure, we have a Belkin router and I've added the ports the docs say to add but I can't test whether they are actually open or not.   L ...Show All

• SQL Server Performance problem: 2000 vs. 2005

  I copied a 2000 database onto 2005 on another box. Running the exact same SELECT query, with 7 tables joined, is running in less than 2 minutes on 2000 and almost 3 hours on 2005. The 2005 box is "bigger and better". I've compared the sp_configure output. There are differences in max worker threads, cost threshold for parallelism, and priority boost. I don't think any one of these is significant. I checked the server properties and the database properties and, again, I did not see what I would consider any significant differences. The 2005 instance has 4GB memory, as opposed to 2GB, but not using that much. In fact, the Total Server Memory (KB) for the instance indicates around 1,230,000 for some reason. We need to reso ...Show All

• SQL Server List of Table Name that not supported by SQL Database ???

  Is anyone know about waht type of table or database name that not supported or will have error during execution of SQL statement in SQL or MS Access database. For my, I know only two , i.) cannot put table name that same as the the database name ii.) cannot put database name like "RETURN", "POSITION",etc. Is there any reference site that show out a list of table about the table or database name Thank You ... :) One way of avoiding duplicate names (I believe usually SQL tells you this if a table already exists) is to add different words to the beginning of the table name like "TheCustomers" or "TheUsers" - adding "the" at the start on 99% of occasions avoids name cla ...Show All

• SQL Server How to Pass pass the Parameter in SQL command in SSIS Package

  Hi    We already used Oracle Datasatage Server the following Query statement for Source and Lookup.here there is parameter maping in the SQl Statement . How can achive in SSIS the Folowing Querystatment   Query 1: (source View Query) SELECT V_RDP_GOLD_PRICE.GDR_PRODUCT_ID, V_RDP_GOLD_PRICE.ASSET_TYPE, V_RDP_GOLD_PRICE.PREFERENCE_SEQ, V_RDP_GOLD_PRICE.RDP_PRICE_SOURCE, TO_CHAR(V_RDP_GOLD_PRICE.PRICE_DATE_TIME,'YYYY-MM-DD HH24:MI:SS'), TO_CHAR(V_RDP_GOLD_PRICE.REPORT_DATE,'YYYY-MM-DD HH24:MI:SS'), V_RDP_GOLD_PRICE.SOURCE_SYSTEM_ID FROM V_RDP_GOLD_PRICE V_RDP_GOLD_PRICE WHERE REPORT_DATE = (select max(report_date) from V_RDP_GOLD_PRICE where source_system_id = 'RM' )   Query ...Show All

• Architecture Financial Services Architect Forum

  Hello, We held a Financial Services Architect forum in Canada recently where we disscussed a number of topics related to the financial industry, you can read a detailed 3 part report on the forum at http://blogs.msdn.com/mohammadakif , I am keen to know what architects working for the financial industry in other parts of the world have on their minds and suggestions for potential topics of discussions in these topics, some of the topics we covered in the session are as follows: 1) Microsoft’s commitment to Interoperability, Software Architecture, Integration and Enterprise Class Computing – Mark and Randy, Directors at Microsoft Canada 2) Role of architecture in a modern progressive organization –VP of Enterprise Architect ...Show All

• Windows Forms folders

  how can i prevent any one to accses the folder that contains data and pictures many file such as accsses denide or even encryption this folder and its files may this help you http://www.codeproject.com/csharp/FileEncryptDecrypt.asp ...Show All