tuanzhang's Q&A profile

• SQL Server Cannot set Default value for column using "Alter column"

  Well here's one of those excruciatingly simple obstacles: In SQL Server 2005 (Mgmt Studio): according to BOL, the syntax to set a default value for an existing column is: ALTER TABLE MyCustomers ALTER COLUMN CompanyName SET DEFAULT 'A. Datum Corporation' However, when I Check: alter table CommissionPayment alter column Amount Set Default 0 I get the error message: "Incorrect syntax near the keyword 'Set'." No other combinations of this syntax work. Help! What am I missing DEFAULT is not a column property in T-SQL -- it's actually implemented as a constraint.& ...Show All

• Windows Forms New form

  How can I do that the form that is executed calling it from menu does not block apliacion main   It will try to explain a little better.  I have a form with which I consider the application main, with his menus and all that, and soon forms that is executed from menu, but the problem which I have is that when one of these is executed, the main one lets be unaccessible, and for example, I cannot execute another order of menu. Can anyone help me (I know, my english is not good) ...Show All

• SQL Server Restoring .cab file

  Hello, I am trying to move towards SQL Server 2005. I need to move my Analysis Services 2000 database to SSAS 2005 (both on different servers). What is the best way to do so. Also if I have the .cab file of the AS 2000 Database , Can I restore it in SSAS 2005 environment. Thanks in Advance , siaj Hi Siaj, You can use the AS2005 migration wizard to migrate a AS2000 database to AS2005. Yan ...Show All

• Windows Forms Draw mode in the NET Framework

  Tell me please the analogue of VB6 DrawMode propery in NET Framework, VB.NET, C#. This functionality is unfornuanately not part of GDI+. There is but a <strong>DrawReversibleLine</strong> which is implemented in <strong>ControlPaint</strong> and gives rise to the headache of needing to tansform coordinates. I hope to see the <strong>DrawReversible(-objects)&l ...Show All

• Software Development for Windows Vista cpu constantly running at 100%!!! and Vista running EXTREMELY slow please help

  i have no idea what to do,  when i go to task manager and click performance it says my cpu is running at 100%, and its doing that 100% of the time, im afraid it may overheat. I am running a Sony Vaio laptop, 3.2 Gz, 1Gig RAM, 64MB video card. vista is also running slow, very very slow... it lags and it doesnt alow me to move large files. (says that i do not have permission) HELP! Sorry for bumping, but I have the same problems and my mi laptop's battery runs out too fast because of this, too. Thanks. ...Show All

• SQL Server Access is denied. (Exception from HRESULT: 0x80070005 (E_ACCESSDENIED))

  I'm having problems determining the source of this RPC Endpoint Mapper error. I'm running a web page (web server - win2k) that uses the ReportViewer control to display a server report located on a different server and domain (report server - Server 2003).    Any ideas would be appreciated. The event viewer message is: Event Type: Error Event Source: DCOM Event Category: None Event ID: 10002 Date:  4/17/2006 Time:  2:59:02 PM User:   computername \ASPNET Computer:  computername Description: Access denied attempting to launch a DCOM Server. The server is: {8B ...Show All

• SQL Server DateTime Parameter in URL

  Hi Group, How can I amend the following to pass the current date as the hidden parameter I tried Now() and Date() but this does not work <form id="frmRender" action=" http://Server1/ReportServer /Reports/Charts/Pie " method="post" target="_self"> <input type="hidden" name="rs:Command" value="Render&CreationDate"> <input type="hidden" name="rc:Toolbar" value="false"> <input type = "hidden" name=CreationDate value= '01/06/2004'> <input type="submit" value=& ...Show All

• SQL Server Update sql server 2005 mobile edition

  I have use this guide to make a application for windows mobile 5.0. http://msdn.microsoft.com/vstudio/tour/vs2005_guided_tour/VS2005pro/Smart_Client/DataBinder.htm Everything is work. I can add, remove data in the dataset. But i can't update the sql server database. can somebody tell me whats wrong Nitro. It appears this sample does not have any code to update the data base. Look into calling TableAdapter.Update() if you need to persist changes to the database. ...Show All

• Software Development for Windows Vista Question for Workflow Monitor

  Hi, All, I get a problem to run the Workflow Monitor sample to monitor UserTrackPoints. I know "All workflow and activity types should be gacced or placed in the same directory as the sample executable". For tracking sample UserTrackPoints, there are only two files in the bin/debug directory, UserTrackPoints.exe and UserTrackPoints.pdb. I put both of files into same directory as WorkflowMonitor.exe, but I still get the error message "Could not load file or assembly 'QueryUsingSqlTrackingService, Version=3.0.0.0, Culture=neutral, PublicKeyToken=null' or one of its dependencies. The system cannot find the file specified.&quo ...Show All

• Visual Studio Express Editions Can't get activation key for VB Express Beta 2

  I have tried to get an activation key 3 times for my Visual Basic 2005 Express Beta 2.  I fill out the form on this webiste, press submit, and it says an email has been successfully sent to my inbox.  But there is no email in my inbox.  I checked the email address.  Can anyone help   Has anyone done this successfully Robert OK - there are a couple things here: First, you get the Pending Limit Exceeded because the system only allows a very limited number of outstanding email verifications against a given email address.  Since you're not receiving the email (perhaps because ...Show All

• Visual C++ Heap/Stack Overflow/Overrun Issues

  I am running a simulation program in VC++ 6 that requires arrays (dynamic or otherwise) that will eventually have as many as 200,000 entries of type "double". The program works fine when I use small arrays (with a few hundred entries) but fails when I increase the array size to say several thousands. The error code is "Unhandled exception in sim.exe: 0xC00000FD: Stack Overflow". I guess the main question is, if possible at all, how do I increase the stack or heap size so that the program can accomodate arrays with 200,000 "double" entries Other advice most welcomed. Thanks in advance! ...Show All

• Visual C++ VC++ migration problems

  I'm trying to bring a project from VC6 to VS2005 Pro. When I first imported the project there was, not unexpectedly, a long list of compiler errors and warnings, and I modified the source code to get rid of all of them, and am now left with 2 problems I'm not sure how to fix. 1) I get an error during the html help phase of compilation to the tune of "windows can't find hcw" - that's the executable for the help workshop. I see that hcw.exe was installed in the Tools/ directory of VS6, but I can't find a comparable executable anywhere in the VS2005 directories. (This problem does not stop compilation) 2) Much more disturbing t ...Show All

• Visual C++ C2002: invalid wide-character constant after moving to July CTP of VS2005 Beta Team System Edtion

  The following code fragment from a header file compiled alright with Visual Studio 2005 Team System Edition Beta 2 (from DVD), but when I installed the July 2005 edition, I now get a compiler error: C2002: invalid wide-character constant Any sugestions as to what could be the problem   Thank you. -------------------------------------------------------------- #ifdef _DEBUG #pragma comment ( lib , _DNT( "AcGe17d.lib" ) )   // Error points to this line #else #pragma comment (lib, _DNT("AcGe17.lib") ) #endif --------------------------------------------- Ayman, While discussing this with a coworker, w ...Show All

• .NET Development ArgumentException in WriteXml

  Hi, I'm getting problems when try to create a XML file. It's throwing a System.ArgumentException with the message "The surrogate pair is invalid". I think that it's a bug of XML classes of Framework Class Library, because I tried all possible ways to write this file (I used all possible classes: from DataSet, with XmlDocument). Please, could someone help me Thanks Francisco Amaral Are you using the WriteSurrogateCharEntity method on XmlWriter   if so are you makeing sure the first character is between 0xDC00 - 0xDFFF and the second character is between 0xD800 - 0xDBFF If not you will get this error. ...Show All

• SQL Server Fuzzy Lookup

  How is it possible to get the Unmatched records on the error path of lookup so  that they may be passed to a fuzzy lookup. I'm trying to duplicate the 1st example on the Data Cleansing Webcast. All I'm getting is a null on the  title out of the lookup component. TIA, GUY Here you go.. http://msdn.microsoft.com/msdntv/episode.aspx xml=episodes/en/20050512SQLServerDF/manifest.xml ...Show All