woodsmith's Q&A profile

• SQL Server Poor performance when looping through table columns

  Hi   Is there a performant way to loop through all columns on a table accessing lots of properties against the table and each column   If I do this on a single table with 100 columns it takes forever! If I look at Profiler this seems to generate 1000s of queries. I have tried using SetDefaultInitFields (as indicated in Michiel Worries FAQs) but while this reduces the number of queries it still generates 100s of queries. ...Show All

• SQL Server The parameter is incorrect. (Microsoft OLE DB Provider for Visual FoxPro) after SP1

  Having installed SP1, my SSIS packages using the OLE-DB Provider for Visual Foxpro no longer work. Using the latest version obtained from here: http://www.microsoft.com/downloads/details.aspx FamilyId=E1A87D8F-2D58-491F-A0FA-95A3289C5FD4&displaylang=en When attempting to create one SSIS from scratch, the message thrown is: "The parameter is incorrect. (Microsoft OLE DB Provider for Visual FoxPro)." The radio button opti ...Show All

• SQL Server SQL 2005 - Partitioning Tables

  I want to know how to partition a table using two columns (Example: Salesman, OrderDate). All the examples in BOL, uses only one column. My ex-colleague who attended SQL Server 2005 training, said the Instructor had said it is possible. (He left the company after the training!!) Any help in this regard is appreciated. Thanks Baskar Hi UmaChander , Can We expect improvement in the performance in the query after partitioning the ...Show All

• SQL Server not able to login in other computers!

  I'm developing with Visual Studio 2005 Standard Edition and SQL Server 2005 Express Edition, my problem is that as default SQL Server Express uses windows authentication. Since I develop in my own PC and install the software in another PC, my SQL Server Database is useless cause it still tries to log in wih my computer name and windows user. I'm using a conventional intallation project in which I include all the files (fonts, project output) ...Show All

• Visual Studio Team System A book or manual?

  I'm evaluating Visual Studio Team suite for the ability to test web page functionality. I see some promiss but I'm really struggling to see if certain capabilities exist. I'd love a reference manual on how to use visual studio testing ability but the only documentation I've found on the install. Some things I'm trying to uderstand are branching and testing for things like login screens. For example, if one screen comes up the test needs ...Show All

• Visual Studio Express Editions Ctrl+Tab behavior

  Can I turn off the new behavior of Ctrl+Tab of showing a list of files while trying to switch windows I like the old behavior better since I can see the contents of the file I'm switching to. Thanks, Nick Have a look at the following post: http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=62361&SiteID=1 ...Show All

• Visual Studio Creating a new wizard

  Is there a class that implement a wizard framework something where I don't need to handle all the "Next/Back" buttons but simply deal with the content of each page Thanks, Sami. Visual Studio will install a file named Microsoft.WizardFramework.dll. This DLL implements the code necessary to handle creating wizards, you just implement a .NET user control and it takes care of the rest for you ...Show All

• Visual Basic Help with Calender

  Hi I'm really new to programing and am having trouble with a feature of an application i am writing. I need a callender where the user can select a date and another form will popup with space to enter text i then want this to be saved so that when the same date is selected from the calender again it will open up the window with text. As i said I am very new to programing and any help or code will be appreciated. Tris ...Show All

• Visual C++ How to create a .doc file ?

  Hi, I use VS2005 ( VC++ ), How can I create an empty .doc file or open a .doc file and append a few lines of plain text or a hyper link, etc, to the file and the document created, processed by this method will be compatible to which version of MS Word or WordPad Thanks. You should use the richedit control. It has all you need for document managing,creating and opening. ...Show All

• Visual Basic Date Sorting issues in DataGridView Column

  Hi, I am converting a VB6 program to .Net/VB2005 as a learning experience. I'm testing the DataGridView control to display my data and have some difficulties. My data is in a single disk file with user-defined-data-type fixed length records. The first column in my DataGridView displays a transaction date. All the DataGridView columns are textbox columns. The dates load and display correctly but if I click the column header and use the built in ...Show All

• Visual Studio Team System proxy bypassed?????

  I have configured TFS to connect thru the proxy(a different machine ). But the setup works even when i disconnect theTFS proxy server and connects directly to the TFS server.It also doesnt give me any sort of error message. How do I ensure that the connection is being routed thru the proxy To get an overview of how TFS proxy works, refer to http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=299341&SiteID ...Show All

• Windows Forms TaskVision server 1.1 install fails on Windows Server 2003 Enterprise

  After RTFMing the TV Server install doc at http://microsoft.com/downloads/details.aspx FamilyId=53C3B52C-0544-4A03-A79B-ECE6D500B8A7&displaylang=en and making sure that everything is as prescribed there (at least I think so) I'm still getting the error  "The parameter is incorrect."  in&nb ...Show All

• SQL Server Ho do I allow multiple users to share a SQL 2005 Express database?

  Hello, Ho do I allow multiple users to share a database Background I have developed a Windows App in VS.NET 2005 which connects to a SQL 2005 Express database. Now I want to install the app and database on the network and I am getting an error "File 'file_name' is on a network device not supported for database files" What is the best way to get this working Thanks in advance, Phil ...Show All

• Visual Studio Team System help on debugging

  hi, i was working on a custom rule. After developing it, i deployed it and then ran it on some test cases but it's giving some error. The error messages are as shown below 1. Error 31 CA0054 : Error loading rule 'CustomExceptionHandling': The following stream was not found in the assembly manifest: SampleRuleLibrary.BaseRule.xml TestForISRules 2. Error 32 CA0051 : No rules were selected. TestForISRules T ...Show All

• Visual Studio Team System Troubles re-playing a web test

  Hi, I'm having a problem with re-playing web tests. If I record a web test on my local host, then it re-plays just fine without any problems. If I record a web test when accessing another server, then it won't replay. The very first step fails with the following error message: "Reqest failed: Index and length must refer to a location within the string. Parameter name: length". It's the same application running on both servers, but o ...Show All