BuddhaBoy's Q&A profile

• SQL Server MSSQL 2005 SP2 Upgrade Fails - DB Engine

  Just downloaded and installed mssql 2005 sp2 on one of our servers All components upgrade apart from the database engine. After the first upgrade i rebooted then tried to update the db engine again it failed for a second time. Below is the error from mssql setup, any help would be nice! Event Type: Error Event Source: MsiInstaller Event Category: None Event ID: 1023 Date:  2/20/2007 Time:  12:08:11 AM User:  DNETWORK\dadmin Computer: SGC Description: Product: Microsoft SQL Server 2005 - Update 'Service Pack 2 for SQL Server Database Services 2005 ENU (KB921896)' could not be installed. Error code 1603. Additional information is available in the log file C:\Program Files\M ...Show All

• Visual Studio 2008 (Pre-release) Which WSDL style to use in WCF?

  Hello I have a question regarding which style of WSDL to use in WCF. I believe the default is document/literal. Is it correct Is document/literal wrapped also supported How can I specify which style to use when programming Thanks for your help. Document/literal is the default and preferred way. By default messages are wrapped, but if you want to turn wrapping off you have to use a message contract, like this for example: [ ServiceContract (Name = "EventsServiceContract" , Namespace = "http://www.thatindigogirl.com/2006/07/Samples" , Session = true )] public interface IEventsService { [ OperationContract ] SaveEventResponse SaveEvent( SaveEventRequest message); [ OperationC ...Show All

• Visual Studio Team System question about the trial version of TFS

  I installed the trial version to test it for a couple of weeks and TFS is not allowing me to add domain accounts to it. Is this a limitation in the trial You installed workgroup edition, which is limited to "workgroup" environments, not allowing AD users, and being limited to only 5 users in the "Team Foundation Licencesed users" group. ...Show All

• Visual Studio Team System TestPartner functional tests are removed from test list whenever VSTS is closed.

  I have created several lists of tests in the Test Manager. Each test list contains an ordered test and a TestPartner functional test. After saving the project and re-starting VSTS the TestPartner Functional tests in the test lists I have created are greyed out and have a warning icon on them. The tooltip for the warning message reads..... "The test <TestPartner test name> does not exist in the test list. It may have been removed, renamed or deleted." The TestPartner Functional tests do appear fine in the "All loaded tests" section of the Test Manager. So every time I close and re-open VSTS I have to drag the functional tests from the Test View back into the test lists (which is quite annoying). Does anybo ...Show All

• Visual C# Windows Service Problem

  Hello, I’m hoping someone at MS can help me. I’ve created a C# Windows Service project whose service main function instantiates a class library that spawns a new thread to create a new process with which to launch osk.exe (the Windows on-screen keyboard). The purpose for creating this service is to have the on-screen keyboard appear immediately after startup (before the login screen) on a system that will have no keyboard hardware. I had first built a test program (C# console application) to call the class library and test its functionality and it worked fine. Then I created the Service Project including its installer classes and installed the service with installutil. [Incidentally, all three projects—the class ...Show All

• .NET Development Unable to update data adapter - C#

  Any expert here pls help me up. Recently i was learning about d C#.net. I was following d msdn guide in Updating d data adapter wit dataset. When i try d debug d code line by line, everythings seems fine until d last statement which is update d data adapter failed(I highlight with red color in my code). D exception tat is displayed An unhandled exception of type 'System.InvalidOperationException' occurred in system.data.dll Additional information: Update unable to find TableMapping['Table'] or DataTable 'Table'. This is my code: string cString = "Persist Security Info=False;Integrated Security=SSPI;database=northwind;server=white"; SqlConnection myConnection = new SqlConnection(cString); myConnection.Open(); SqlData ...Show All

• SQL Server Cannot Launch DTA - Failed to open new connection

  Installed SQL 2005 STD and installed SP1 for SQL on a Windows 2003 STD server. I launch DTA and I am logged in with the same windows account which the SQL services use and I get the following message: =================================== Failed to open a new connection. =================================== Could not find stored procedure 'msdb..sp_DTA_help_session'. (.Net SqlClient Data Provider) ------------------------------ For help, click: http://go.microsoft.com/fwlink ProdName=Microsoft+SQL+Server&ProdVer=09.00.2047&EvtSrc=MSSQLServer&EvtID=2812&LinkId=20476 ------------------------------ Server Name: FHCMS,1433 Error Number: 2812 Severity: 16 State: 62 Line Number: 1 ---------------------------- ...Show All

• SQL Server Report footer doesn't export to excel

  Hi, I had developed a simple report, that has header, body and footer. In footer i have copyright. Now the problem is that, when i export it to excel the copyright text i had in the footer doesn't export. any one had any idea. Chinna. If I'm understanding you correctly, the footer is there, but it's not being shown in Excel on the normal view. This is just the way Excel works, and is not RS specific; page headers and footers are only displayed on print preview. The headers in the report are by default rendered as part of the main spreadsheet in Excel by RS, and not as a PageHeader in Excel. If you set SimpleHeaders=true in the device info, the PageHeader would be rendered as a PageHeader in Excel instead of part of th ...Show All

• SQL Server performance differnce between 3027 and 3033

  Hi, I have found major differnces in performance between the two versions - specially with queries that should be answerd from cache if i execute multiple times... Test Query - after the first execute it tooks 1 second with 9.0.3027 and 12 seconds at 9.0.3033. Is this a bug in the last ctp - does this change back in the released SP2 or is the something bad in my models for the latest version we used two equal machines - processed the db on 9.0.3033 and restored the backup on 9.0.3027 query looks like select {[4WochenSet]* [Zeit].[Tag].[Tag]. Members } on axis (0), Descendants ([Immobilien].[Geographie].[Bundesland].&[Wien]&[AUT], [Immobilien].[Geographie].[PLZ], SELF ) on axis (1) from Ang ...Show All

• SharePoint Products and Technologies dcument library help

  Hello everyone, I am trying to get access to documents in a document library and am trying to "server" these documents to an end user. But im having trouble with the basic concepts... I see code examples like this: // get the current site SPWeb site = SPControl.GetContextWeb(Context); // set the library and view to display string docLibName = "Shared Documents"; string viewName = "All Documents"; // get the folder SPFolder docLibFolder = site.Folders[docLibName]; // get library and view SPDocumentLibrary docLib = (SPDocumentLibrary)site.Lists[docLibName]; SPView docLibView = docLib.Views["View_Name"]; // get all the items in the folder SPListItemCollection docLibItems = docLib.GetItemsInFolder(do ...Show All

• SQL Server help with complex SQL query

  I need some help from prog. gurus with sql query. I have a commodity table and I would like to pull information from it based on the conditions. I can write code to pull straight forward information from the table but I need help in writing query such that the later columns are based on the former columns. To clear my question, I am writing the sample code below. The column 4, 5 and 6 are based on column 1, 2, 3. Column6 is column3/column2 (which is simple) But column4 & 5 are too complex for me to write the code for. Column4 is the % of Quantity (cty_code)/(all countries) for that particular commodity. cty_code correspends to a country. Table information: [dbo].[2005exp]( [dom_or_for] [char](1) NOT NULL, [commodity] [ ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Visual C# Express gotcha

  I am used to full blown Visual Studio 2005 but I decided that I'd play with Visual C# Express so I could better get a feel for that IDE since this is the environment for XNA Express. Just so you all know, when you create a project in C# Express it doesn't get saved to disk until you explicitly tell it to save or close the project. Amazingly even if you compile and run the new project it still won't be saved to disk. The upshot of this is that if the IDE crashes or gets terminated unexpectedly there doesn't seem to be any way to recover the project or the files you were editing. Twice I ended up losing the entire project I was working on because of this. I searched the entire disk to try and find my files and couldn't. The workarou ...Show All

• Windows Forms Keep Modal Form in Focus and Prevent

  I have a Parent form (FORM 1) that opens a child form (FORM 2) via .ShowDialog. My problem is that the Child form is losing focus too soon and reverting to the Parent form before I can complete my operations. How can I prevent the Parent form from getting focus until I am ready FORM 1: private void toolStripButtonCopyNew_Click(object sender, EventArgs e) { frmAddNewEst f = new frmAddNewEst("Copy"); f.ShowDialog(); //<---calls FORM 2 //if new estimateID was created then load form if (variable.estimateID != null) { ... } } FORM 2: private void saveData() ( if (chkCopyArea.Checked == false && chkCopyHeading.Checked == false) { ...Show All

• SQL Server T-SQL Trigger challenge

  I have a customer table that contains ID (string), Company (string) that are set to NOT Nulls However , when inserting empty string '' into the table, the NOT Nulls accept it because it is an empty string. So, I want to create a trigger to check if ID or Company contain zero length value (empty string), then raise error "Sorry please enter ID" and do not execute insert As I am new to T-SQL , I am unable to "get the paramenter out of the INSERT query passed into SQL Server from my application" Be plain: 1. In my application , I execute "Insert into customer (ID, Company) Values ('VarID','varCompay')" 2.In the SQL Express, there is a trigger that listen on Customer table for Insert action. ...Show All

• Software Development for Windows Vista where can we find the full functional WF design tool with code writing

  We are independent software provider trying to integrate workflow in our product. Our customer need adjust the default workflow (we have provide) and need to write some simple code in workflow.  So where can we find the full functional WF design tool with code writing We cannot ask them to install Virtual Studio or VS expression. workflow design hosting do not support code writing. Any suggest Thanks Khalid, Is it a full functional WF design tool with code writing Where can I get it I know we can rehosting a WF designer. but our customer I need can write some simple codes. ...Show All