Scott Chang's Q&A profile

• SQL Server Info on VLDB (Very Large Database) scenarios?

  So, the boss asked how Sql 2005 does with VLDBs (Very Large Database). Can someone, anyone, point me in the direction of some reliable, relevant information related to Sql 2005 and VLDBs I'm having a tough time finding anything with numbers, Gigs, Terabytes, stats... case studies, etc. Thanks. http://www.microsoft.com/sql/prodinfo/compare/wintercorp-survey.mspx ...Show All

• Visual C++ Resize main window of an application

  Hello, While resizing the main window, say reducing the size by mouse, I want that the window size cannot be further reduced when it comes to a minimum value. The application is developed using VC++ 2005 and MFC. Please tell me how I can do it. Once i posted the same inside my blog You can see the post here Restrict Window Sizing Taken from the post To accomplish the same, you may need to override OnSize message Here’s a sample snippet to do the same. const LONG MIN_WIDTH = 500; // Minimum width const LONG MIN_HEIGHT = 300; // Minimum Height void CMainFrame::OnSizing(UINT fwSide, LPRECT pRect) { // Set the minimum size if width going to be less than minimum width if ((pRect->right - pRect->left) <= MIN_WI ...Show All

• Software Development for Windows Vista GetCurrentUser/GetUser call and security elevation

  I have a problem that I have yet to find a documented answer. I need to obtain the logged in user while running a setup application. I am trying to create a scheduled task in Vista and this is one part of the issues that I am having. The setup application is required to run with admin privledges. Calling GetCurrentUser or Getuser returns the admin where I expected the logged in (standard) user. My intended use is to allow for the creation of a scheduled task using the user name of the logged in standard user yet the documentation clearly says the owner of the currently running thread is the reported user - any other options Thanks for the response yet I've been struggling with the code sample when i ...Show All

• SQL Server month ('jan','feb',...) string to date conversion fails

  I use the derived column to convert a string date from a flat file like this: "Jan 02 2005" into a datetime. I have seen in the forum to use: (DT_DATE)(SUBSTRING(mydate,5,2) + "-" + SUBSTRING(mydate,1,3) + "-" + SUBSTRING(mydate,8,4)) However, even if it produces a string like '02-Jan-2005', the following cast to dt_date fails. I have also tried inverting month and day, year/month/day but all with the same result: Derived Column [73]] Error: The component "Derived Column" failed because error code 0xC0049064 occurred, and the error row disposition on "output column "... I think the cast fails bacause of the month format. Therefore the only solution would be to code in in a lookup table Jan, 01 | Feb, 02 |... ...Show All

• .NET Development Creating a database storage and information access?

  Okay I'm totally lost. I've been trying to make a website for our customers to sign into where they can view specific details relating to their company (their product purchases, warranty end dates, and points balance tracking). How do I go about creating such a database storage and access website. Does anyone know where I find a tutorial or if someone can help me out. I've tried everything I could find and nothing. All I got so far is the actual layout and log in working. Now i need the backbone of the website; the database functions. Thank you. Hi Charles, I tired what you outlined and I'm doing something wrong because it's not working. I tried the screencasts but not much help. Anyway, do yo ...Show All

• SQL Server creating a new replication

  I am very new to the whole sql replication, i am trying to replicate with 2x 2000sql std machines One is to be the distrubuter and the publisher (merge type by the way) the other to be the subscriber. I have downloaded and followed step by steps religiously however i have nothing but isses with this. I have used the wizards i am getting various errors. the merge client comes up with an error after looking in the event view i find i have the following error Event Type: Information Event Source: SQLSERVERAGENT Event Category: Job Engine Event ID: 203 Date: 8/01/2007 Time: 12:52:17 PM User: N/A Computer: FAILOVERSQL2000 Description: SubSystem Message - Job 'FAILOVERSQL2000-PTO-PTO-ELCOM-TEST-1' (0x96AD1DBC3E5A9541A6C72C4CCFB ...Show All

• SQL Server Dynamic view

  Is it possible to create dynamic sql views in Sql Server 2005 I have a requirement of having to change the Sql View depending on the user selection criteria. Is it possible Krutika wrote: Thanks. I cannot use stored procedure, any other option to programattically alter the view No. Well, you can use CASE statements in your view if that helps. ...Show All

• Visual Studio Team System Custom rule

  1 Can i write a custom rule to check after keyword "return" and "goto" ,there is no "()" for instance return (a) ;is wrong return a; is right 2 To check "{}" is exist when "if" and "for" has one statement for instance if (a == b) return a; -- is wrong if (a == b) { return a; } -- is right Hallo Vivian, I'm afraid You will not be able to check for this. ( ) and { } are source code constructs and will not survive the compilation. Since FxCop is analysing the compiled IL-Code it will not be possible to detect such constructs. Kind regards, Anton Papst. ...Show All

• Visual Basic How to get a Combo Box to feed from another Combo Box

  Hope someone can help me!! I have a form with two combo boxes. One displays different Areas(e.g. Area1, Area2, Area3) and the other one displays different Regions(e.g. Region1, Region2, Region3). What I want to do is to populate the Region Combo Box depending on the Area selected in the Area Combo Box. For Example if the user selects Area1 have the Region Combo Box filter/display on those Regions that belong to Area1. I relly appreciate any feedback. Thanks alot!!! Well thats fine, you can call the method from anywhere within your application/class. The method will get whatever text is selected in comboBox1 and pass that to the PopulateCities method for it to add to the specified com ...Show All

• SQL Server Problem creating a Foreign key Constraint

  Hello, I'm having some problems trying to create this foreign key constraint: ALTER TABLE dbo.t2_demaclie ADD CONSTRAINT FK03_T2_DEMACLIE FOREIGN KEY (dclPerfilCompania, dclOrdenPedido) REFERENCES DBO.T2_PEDIDOCLIENTE (cdPerfilCompania, nmOrdenPedido) Server: Msg 547, Level 16, State 1, Line 1 ALTER TABLE statement conflicted with TABLE FOREIGN KEY constraint 'FK03_T2_DEMACLIE'. The conflict occurred in database 'Comfruta_dllo', table 't2_pedidoCliente'. I'm sure there's no other constraint with the same name, and there's no othe one with the same columns... Thanks a lot !! Well, you're going to have a problem creating the foreign key - you may want to work out what the keys in those field refer to. (For example, ...Show All

• Visual Basic force menu dropdown

  Hello, Can someone tell me how to programaticaly (wow) force a top level menu item to drop down For example: Like when you click the standard 'File' menu and you get the lower menu items to drop down. I need to be able to do that by code. Thanks ahead, Aaron Oh I see, the solution I gave was for VB 2005. If you're using VB6 you'll either have to use a Windows API call, or use SendKeys to send Alt+<accelerator key letter> to the menu to drop it down. ...Show All

• Software Development for Windows Vista Visual XSLT under VS2003 in vista

  Most of my work is developing xslt stylesheets for document processing. For this I still use visual XSLT by activestate, as there has not been anything better to use. However, active state abandoned the product a while back due to the costs of intigrating it iinto vs2005. So I have to keep using vs2003. After the upgrade, I can no longer debug xslt with it. It starts the debug server and starts listening on port 9030 (and it appears to do something on 8009 too), but VS never manages to connects and in the end you have to force quit visual studio. I am assuming it is a problem with a port, as I originally had a problem that I couldn't use tomcat at the same time due to the port 8009 conflict. Does anyone know of any other ports or things th ...Show All

• .NET Development Detect Oracle user privileges

  Hi. Can I detect Oracle user privilegies for specified table at run-time I using OracleConnection standart class for development. Thank you. You can try to update/insert to the table and catch the error, then tell the user they don't have the rights. Or you can query the Oracle ALL_TAB_PRIVS table to get a list of the permissions the user has. http://www.lc.leidenuniv.nl/awcourse/oracle/server.920/a96536/ch2143.htm#1162411 ...Show All

• .NET Development Saving an array into a database

  Hi, I have code written that accesses an excel database, creates an array with the info, and then displays it in a listbox. I was wondering if there is a way to save the array into a database. Any Help will be very helpful ha thanks in advance, take a look at this article Saving an array to a SQL Server table with VB and ADO it targets same problem you have but with ADO and VB hope this helps ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Creative X-Fi support

  Hi I was wondering if XNA / XACT can support the advanced features of Creative's X-Fi range of soundcards. I mean things like preloading sounds using X-Ram which is supposed to help increase frame rates. XACT can support multichannel files. So if you author a 5.1 PCM file, XACT can play it back and a user will hear surround sound, as long as their sound card and driver support multichannel out. Or you can use XACT's 3D API's to play back individual sound effects, specifying x,y,z positions and they will also play back on surround sound. However, your questions mentions using XACT for FMV-- XACT would generally not be used to play back audio for an FMV file. I suggest you look at the documentation fo ...Show All