soellnas's Q&A profile

• Windows Forms can anyone help me?

  hello i have made an application for a certain clinic,the patient come to the clinic and makes some tests in the laboratory of the clinic,some tests have two properties Result and referencerange but another tests have another properties(such as for the u ...Show All

• SQL Server full text index is exist or not

  Hi, How to find full text index is exist in the table or not like that how to find normal index is exist in the table or not Thanks in adv. ---> Murali <---- Please refer to Books Online "Obtaining Full-Text Property Values using Transact-SQL Functions" http://msdn2.microsoft.com/ms142579.aspx In your case you should use OBJECTPROPERTY function and TableHasActiveFulltextIndex property. OBJECTPROPERTY(table_id, 'Ta ...Show All

• Visual Studio How to Create a Graphical Designer

  I am looking for documentation or sample code on how to build a standalone GUI designer. The basic functionality is A tool box A canvas that controls can be dropped onto and be (re)positioned and viewed at design time. Property Explorer to set the various properties of a control As this will eventually be used in a commercial product, please limit responses to tools/libraries/SDKs that are freely distributed. Any help is app ...Show All

• SQL Server UDF 10x slower than select query it contains

  I have a table valued UDF with only one SELECT query. It selects from a View, and has a couple of joins and calls another UDF in the WHERE clause. When I run the Select query itself it's duration is around 120, but when I have it wrapped in a UDF, it's around 1200! ALTER FUNCTION [dbo].[fnGetiii] ( bla bla bla ) RETURNS @ItemTable TABLE ( a varchar(2), b bigint, c smallmoney, d varchar(50), e varchar(50), f int, g varchar(50), h datetime, i int, ...Show All

• Visual Studio 2008 (Pre-release) ExactlyOnce via config file

  I'm having trouble turning off the ExactlyOnce setting on a msmqIntegrationBinding via the config file.  I have tried both assurances="None" and exactlyOnceDelivery="Boolean" on the binding configuration element but keep getting unrecognized attribute exceptions. Has the attribute name changed again Hi there, Yes, the attribute name has changed to exactlyOnce . Hope this helps, krish ...Show All

• SQL Server AS2005 Cube Processing

  I have problems with processing cubes on AS2005. I get this error message while processing: Memory error: Allocation failure: Not enough storage is available to process this command. Error in the OLAP storage engine. This machine has 6GB of memory and once it hits 3.5GB the processing stops. AWE is turned on. I would appreciate, if anyone can help on this. Thanks, Gopal Analysis Services is not ...Show All

• Visual C# changing visual studio 2005 code to c#

  i have been working with visual studio 2005 express and would like to learn more about c#can someone assist in converting the code below its used from button 1 click on a windows form. Dim xlApp As Microsoft.Office.Interop.Excel.Application Dim xlBook As Microsoft.Office.Interop.Excel.Workbook xlApp = CType(CreateObject("Excel.Application"), _ Microsoft.Office.Interop.Excel.Application) xlBook = CType(xlAp ...Show All

• Smart Device Development Getting the base directory using CF2 and storing files

  Hi, I have a small PPC 2003 app written using the CF2. I have a few questions: My application will need to store txt files during its execution. In a Windows desktop app I would store these files in the users profile location. On PPC 2003 is there an equivelant folder and should I use GetSpecialFolder() to get its location If there is no special folder can I store text file in the application folder, if so, how do I get the application folder u ...Show All

• SQL Server Schedule backup SQL Server 2000

  Hi all, How can I schedule backup in SQL Server 2000 for ALL databases With SQL Server 2005 I can create maintenance plan to do this, but in the 2000 version I don’t know. thanks!!!! You can do the same thing in SQL Server 2000. Create a new maintenance plan, select All databases, specify backup options and a schedule, complete the wizard. It will create a job that will backup all of the databases using the options that you specified. ...Show All

• SQL Server PROBLEM W/ OLE DB COMMAND

  In a data I'm trying to implement an Ole DB Command to do a database table update.  When I enter my sql command I get an error saying [OLE DB COMMAND [5926]] - unable to retrieve destination columns...  It appears it doesn't recognize the table I'm trying to update, however I do have a sql task in the control flow that is successfully selecting a row from the same table that I'm trying to update (just to prove that I can access that ta ...Show All

• Windows Forms Selecting blocks of cells - determining topleft/bottom right + restricting to contiguous

  Mark, good work, thanks, got me up and running very quickly. Any ideas on restricting the selected cells to a contiguous block. If they are not a contiguous block I can enumerate SelectedCells and equate Selected to false then equate CurrentCell.selected to true. What I need is the test for whether the selection is contiguous - ie all connected together. The simple test is if GetCellCount / 2 is an integer or GetCellCount = 1. ...Show All

• Smart Device Development Error for selecting file which doesnt exist in c#

  Hi How do you go about validating a number which the user enters to ensure that it actually exists in the database. I have a program set up which allows the user to search by number. When they enter the number i want the program to check whether the file exists in the database. If the number does not exist then display an error message to the user. Thanks in advance How to do that depends on what ex ...Show All

• Visual Studio Team System Updated. User in Project Contributors is unable to access Source Control

  Hi all,   I created new project with Source Control folder under Server TF Administrator role. I created new solution with project and some files into Source Control and successfully checked in.   I included new user account into Project Contributors group on TFS, SharePoint Services and Reporting Services. New user connected to TFS, project tree displayed correctly. When user clicked on Source Control item in proje ...Show All

• SQL Server Connection to SQL Server 2005 Express?

  Hi all, I've been reading other posts for awhile now and I can't figure out what I'm doing wrong. I'm a Web Developer and not a DBA. I have SQL Server 2005 Express installed on my machine and it's working just fine. I also have the Management Studio Express CTP installed and working. I'm trying to connect to a database using a username and password (from ColdFusion Server which is working fine for external Oracle and Access databases, so t ...Show All

• Windows Forms ClickOnce - Update from a Mapped Drive

  Hello, Is it possible to have ClickOnce look at a mapped drive for updates instead of a complete UNC path Thanks, Hei ClickOnce should not have a problem. But are you sure that all your users of the app are going to have the location mapped to the same drive all time -thanks Sreekanth ...Show All