Richard Ambrose's Q&A profile

• Visual Studio Team System Error 28703

  Installing Foundation Server Trial Edition in Single Server mode. I am installing under a domain account that has admin rights to the local box, and is also the account that runs all SQL Server 2005 services and is explicitly in the SysAdmin role on the SQL Server Have separate domain level accounts (non-admin) for the Foundation Server Service and Reporting Service. At the end of the installation I get : "Error 28703. Unable to ...Show All

• SQL Server Making "incremental" updates to a data warerhouse

  We have a legacy database whose data needs to be included in our yet-to-be-built sql 2005 data warehouse. Some of the tables don’t have any natural candidates for a primary key. (Of course, we also need to add other data to the mix.) Suppose we load the empty warehouse initially. In following loads we don’t want to include those records that haven’t changed from the first load (“duplicates”) but we also don’t want to delete the conte ...Show All

• SQL Server Creating SQL Server 2005 Mobile Edition On Desktop

  Hello Everybody I want to create SQL server 2005 mobile database on desktop programmatically with some inital data for my application and load it into device. We can create database only in VS2005 server explorer or SQL server 2005 application. Anybody having this solution for this prob.   Regards Chikuu         Have you had any chance to look at: http://fo ...Show All

• Visual C++ massive compile time errors in stadrard header files

  I just installed Visual Studio 2005 Professional Edition Dec 2005 Disk 3070 DVD. It came with a subscription. It wiped out .NET Framework 2.0, previous betas of all sorts, etc. Now I am at a clean slate. I made a batch file with a command line which seems to work fine-- in the first approximation shall I say Here it is CL /nologo /W3 /Gm /EHsc /Zi /Od /D "WIN32" /D "FDEBUG" /D "_CONSOLE" /Tp%ProjDir%\SockeCPlt6.cpp /Fp"makingfile.pch /YX /Fo"D ...Show All

• SQL Server Easy Reporting

  Hello, I am searching for a reporting tool in which I can graphically and easily report on the cubes built using SQL Server Analysis Services. I don't want build complex reports using SSRS, but instead use something like MS Office Data Analyzer. The version of Data Analyzer I have goes back to 2001. I am able to view reports based on SQL 2005 SSAS but was wondering if there is a new version of this product or perhaps a totally new product tha ...Show All

• Visual C# A common application for recursion

  Hi, A common application for recursion is the problem of generating all possible permutations of a set of symbols. For the se consisting of symbols A,B and C there exists six permutations - namely, ABC, ACB, BAC, BCA, CBA and CAB. The set of permutations of N symbols is generated by taking each symbol in turn and prefixing it to all the permutations which result from the remaining N-1 symbols. It is therefore, possible to specify the perm ...Show All

• Visual Basic Migrating from Ms Access to SQL Server 2000

  Hi, Is there many changes need t o be done in order to change my DBMS. Currently, i'm using Microsoft Access in my VB.net program. however, i need to change the DBMS to SQL Server. So what should i do can i still use back the same coding what namespace should i include Hi there, Firstly, I would consider using the Access Upsizing Wizard to migrate your database from MS Access to SQL Server if you have not done so already. If you've mig ...Show All

• Software Development for Windows Vista 5342 install problem

  I keep getting an blue screen after first reboot when trying to install 5342.  I have a asus k8v se deluze motherboard with latest bios. amd 64 3000+, geforce 6800gt, 1 gig ddr.  Everytime it goes to reboot after intial installing screen it goes to windows setup boot screen then crashes.  I installed 5342 using same iso on another machine with much less hardware and installed fine.  Anybody have any ideas   I tried insta ...Show All

• Visual Basic A Modest Proposal for Microsoft

  I've been a Basic programmer for over 30 years and that whole time I've endured the constant reminder that I'm not a "real" programmer. I know better and you know better but still there's that stigma associated with being a Visual Basic programmer vs. being a C++ or a C# programmer. Now that I use VB.Net it really couldn't be further from the truth since VB.Net does everything any contemporary OOP language does. So here's my sugg ...Show All

• SQL Server How to convert a timestamp into dateTime in SQLServer 2000

  Hi Everyone,   We have a table in SqlServer 2000 with a column type TimeStamp and contain value such as 0x00000000656AC51F. Are there any way for me to convert that value back to DateTime I tried to use cast function like: Select cast (MyTimeStampCol as DateTime) myDate from MyTableand I encountered error below.   Msg 8115, Level 16, State 2, Line 1 Arithmetic overflow error converting expression to data type dateti ...Show All

• SQL Server How can i insert a default row if it doenst exists already?

  Hi, I am currently loading dimensions using a Sql Server Destination and i was wondering if i can create a middle step to insert a certain row so i would identify in my dimension the undefined records... I know i can do it with sql statement but i was wondering if there is a better way. Best Regards, Luis Simoes Script and Unions will do the trick, but how often do you populate a Dim table from scratch Would it not be easier to in ...Show All

• Software Development for Windows Vista DirectX.AudioVideoPlayBack Volume problem

  Sorry am new to this and couldn't find anywhere else to post this! I have been writing an audio player program in C# and keep coming up with a problem everytime i try to change the Volume. It plays fine otherwise. the error comes up with DirectxException "Error in the Application", like i said i'm new to all of this so it might be something very easy, but i am pulling out my hair! Thanks for your help Dyl. ...Show All

• Visual C# Out of Memory?

  When using my application I seem to get an Out of Memory error at random. I cannot find any common "action" that leads to this. additionally it occurs more frequently when the application is either minimized for more then 5 minutes or is a background window (not the active application) for more then 3-5 minutes. It doesn't happen all the time. I seem to only get it once a week at most. It does not seem to occur when the application is ...Show All

• Smart Device Development Windows CE - CEPC Display Problems

  I'm trying to determine if developing my industrial PC using WinCE is possible. I've downloaded the WinCE500 demo version and I've done the following (with only slight variations): Made a simple CEPC OS design with the Display Driver: VGA Linear (flat) Framebuffer Made a bootdisk using CEPCBoot.144 Ran vesatest.exe to find valid run modes (800x600x16) Ran "LOADCEPC /V /E:0:0: /L:800x600x8 eboot.bin" Successfully uploaded the NK.BIN fr ...Show All

• SQL Server seperate fields for first, last and middle in access db

  I woluld like to join the 20 or so queries I have to seperate last name, first name, middle initial, second first name, second middle initial, title. all values are in one field. I there a sql statement i can write to seperate into different fields you really should redesign that table. . . its not "normal". Google "Normal Form" +database ...Show All