RCH1968's Q&A profile

• SQL Server Performance of sqlserver drops few times per hour

  Approx. 3 times per hour sqlserver is writing data for 8 to 10 seconds. What it is writing i dont know, but the result of this is that the duration of executing queries is much larger then normal ( 10 times ). Normally the query takes up to 400 milliseconds, and during this writing problem, it takes 6 or more seconds. Sqlserver is not doing backups when this happens. Does anyone have any idea Great 2 answers and they both helped me :) Thanks people it was the checkpoint. Now i need to find a way to do more checkpoints in an hour. Anyone an idea Thanks ...Show All

• SQL Server Dynamic data source name...

  Sorry if this is a pretty basic question.. but my team here is working on SQL Reporting app for the first time. is it possible to put the data source name/connection string in a config file (like web.config) and have the reports use that from there What is the standard way of doing this while trying to deploy the reports on different servers Thanks Can any one please explain more on the solution for dynamic data source connectivity in reporting services 2000 * Use the SOAP API by calling SetDataSourceContents If any one has implemented it, can you please provide a step wise pointer to how to get this done. Will be of great help! ...Show All

• SQL Server Using Sql Server in DB Program

  I am about to build a program that will require the use of DB. In the pass I used Access as my back end, but this time I would like to use Sql Server. I just have a few questions before I begin. 1. After deploying and installing my program, do I need to have sql server installed on users system or can the DB file exist on its own and just use ADO.NET to access the file (As I done in the pass to access my Access mdb file) 2. If I can deploy a sql file -- can it be done with Sql Server Express 3. If it can't be done, what db program should I use Thank Jens for replying. I was actually referring to what you responded in point #3. I have a couple of more questions: 1. Which on ...Show All

• Visual C# how to add custom control to datagrid cell

  hi i carated custom control, how can i embeded that contol to datagird cell oh... you used third party software. To extend this, you should read the product documentation. normally, in the datagrid from .net framework 1.x, to create custom control, you should inherits from System.Windows.Forms.DataGridColumnStyle class. ( In this class documentation, there is a example how to extend it.) I hope it'll help you, soemoe. ...Show All

• Visual C# WinForms Problem

  I am working on a winforms app that utilizes ODBC to acces paradox tables and a WinMobile database(.sdf) in order to sync table records. My problenm is that as soon as I add a grid with one of the Mobile database tables I get this error Unable to load DLL 'sqlceme30.dll': The specified module could not be found. (Exception from HRESULT: 0x8007007E) From this code [System.Diagnostics. DebuggerNonUserCodeAttribute ()] private System.Data.SqlServerCe. SqlCeDataAdapter Adapter { get { if (( this ._adapter == null )) { this .InitAdapter(); Error on this line.... } return this ._adapter; I thought that was contained in this reference System.Data.SqlServerCE which is a reference in my project. ANy one kno ...Show All

• Visual Studio No "PATH" updates after installing VS 2005 on Windows XP Pro x64 2003

  Hi, I just installed VS 2005 on a build server running XP Pro x64 2003. I was surprised to see that my PATH was not updated with all the typical directories for accessing VS binaries (like devenv). I had it recently installed on a 32-bit machine and the paths were all there. I'm just wondering if this is something specific to x64 or did I miss something in the installation. I don't recall seeing anything asking me to specify to update the environment. I know I could just add the paths myself, but I'm developing an install procedure and this seemed unusual to me so before adding this to my set of instructions I just wanted to see if it's normal behaviour. Any help would be appreciated. Thanks! Tony ...Show All

• Visual C++ Importing excel sheet data into spreadsheet

  Any one plz help me in "importing data from excel sheet into a spreadsheet" programatically in vc++. The C++ Language Forum is restricted to questions regarding the C++ Language, as implemented by the VC2005 compiler. It also includes the STL and other standard libraries, but as such not any Microsoft- or third party APIs or SDKs. See http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=789657&SiteID=1 . Please direct this question to one of the automation or office development newsgroups at http://msdn.microsoft.com/newsgroups . Thanks! ...Show All

• Visual C++ Command line error D8037

  Hi, I am trying to build a ASP.NET site to compile C++ source code. I have used the Process object to set up the environment variable, and call cl.exe to execute. It works if I run the code through visual studio - it compiles and outputs an .exe. However when accessing from the web, it doesn't and give the following error. cl : Command line error D8037 : cannot create temporary il file; clean temp directory of old il files I have set the environment variables according to vcvarsall.bat in the C:\Program Files\Microsoft Visual Studio 8\VC directory. I can compile the code in both the visual studio 2005 and manually from the vs2005 command prompt. Please does anyone know how to solve this problem or any su ...Show All

• Visual Studio 2008 (Pre-release) Bind to ComboBox

  I am trying to bind a property of my business object to a ComboBox, but I am not having much success. I have already bind data to a TextBox easily, but I am having problem with the ComboBox. The ComboBox ItemsSource is set to one of my business object that contains all the selections. This is working fine, I can see all the selection is my ComboBox. The selected value of the ComboBox is binded to a Guid property of another business object (IndividualLanguageTypeId property) Here is the XAML of my ComboBox : < ComboBox SelectedValue = " {Binding IndividualLanguageTypeId} " x:Name = " ComboBox5 " IsSynchronizedWithCurrentItem = " True " DisplayMemberPath = " Description " SelectedVal ...Show All

• SQL Server How to insert a new record (and get it's identity), if a record is not found

  What I'm trying to do is write a query (actually it will be a sub-query) that gets the ID of a record using a standard SELECT/WHERE, but if the record is not found then I want to insert a record and return the ID of the inserted record. So far I've got this (which doesn't work!) SELECT ISNULL (( Select ContactID AS ID FROM [TileManager] . [dbo] . [Contact] WHERE ( [Salutation] = 'Mrs' AND [Forename] = 'Freda' AND [Surname] = 'Bloggs' )), ( INSERT INTO [TileManager] . [dbo] . [Contact] ( [Salutation] , [Forename] , [Surname] ) VALUES ( 'Mrs' , 'Freda' , 'Bloggs' ); SELECT @@IDENTITY AS ID )) Any help would be greatly appreciated. Rob: Be careful using t ...Show All

• Visual C++ stdio.h errors in Visual Studio 2005

  I just finished installing VS 2005 (is it that hard for microsoft to just let people download like, a zip file of it, rather than an img file, which i had no idea what to do with at first ) and tried the following code: #include <stdio.h>    // include the standard input/output header file void main(void)    // our program starts here {     printf("Hello World!");    // print "Hello World!" into the console     return;    // return void to windows } It was part of an origionally blank win32 console app called test.  When i tried building the solution or compiling the file separately, I got all those errors: ------ Build started: Project: Test, Configuration: De ...Show All

• SQL Server How to display Interactive Excel file using sql reporting services

  I need to display an raw data and graph in multiple work sheets in excel features having formula's and color combination from sql reporting services . So that users see the graph changes when user change the data in the excel file . I would like to get sample solution in .net without using any third party component which is listed below with .net environment for interactive excel . http://officewriter.softartisans.com/officewriter-128.aspx#EXCEL http://www.softwarefx.com/SFXNetProducts/CFXforNET . Also wanted to know using sql reporting services is it possible to show line graph in web page Client Machine will have Spreadsheet: Microsoft Excel 2000 Windows 2000 Internet Explorer 5.0 ...Show All

• SQL Server Possibly incorrect query result

  /* Test table */ create table test (c1 char(1), c2 varchar(1)); insert into test values ('',''); /* Query */ select c1, len(c1) len_c1, c2, len(c2) len_c2 from test The result of the len(c1) expression is 0. I would expect the correct result to be 1, since "c1" is a fixed-length character string type and the values are right-padded with spaces to fit the defined length, in this case 1. I'm using SQL Server 2005. Regards, Ole Willy Tuv LEN Returns the number of characters, rather than the number of bytes, of the given string expression, excluding trailing blanks . Change LEN to DATALENGTH and run this select c1, datalength(c1) len_c1, c2, datalength(c2) len_c2 from t ...Show All

• Software Development for Windows Vista How to get possible state transition for a given user

  Hi, How can I get the list of possible state transitions for a given user in State machine workflow The PossibleStateTransitions gives all possible transitions. Thanks, Navneet Thanks for sharing your answer, this is a community and the product team is here to help, but the great thing is that anyone should be able to reply. So thanks for sharing your answer. On your other note, SonaliC's post was marked as answer because there was no response for over 2 months, and in those situations, we mark the last post as Answered. ...Show All

• SQL Server use exists in join

  Hello, Can i somehow use exists() function in JOIN ON clause for example SELECT * FROM Table1 INNER JOIN ON Table1.Col1 = Table2.Col1 AND EXISTS(SELECT * FROM Table2 WHERE Table2.Col2 = Table1.Col2) It doesn't work on my query. So, basically i want to do an inner join so that Table1 gets filtered. Then I make sure that every entry in the filtered Table1 has an existing related entry in Table2. i need to do exists because there could be more than one relation in Table2 for each entry in Table1, but i don't want multiple repetition of entries in the filtered Table1. (Not sure if i am making it clear!) I need distict selection, but i am adding NEWID() at the beginning of my query so distinct doesn't work for the rows. with my current query, i ...Show All