stranger in a strange land's Q&A profile

• Visual Studio Team System Import Fails if varchar/nvarchar set to MAX length

  I have a SQL 2005 table with the following that I am trying to import in to my DB project:: CREATE TABLE [dbo].[Test_XML] ( [id] [uniqueidentifier] NULL, [name] [nvarchar] (50) NULL, [description] [nvarchar] (MAX) NULL, [testxml] [xml] NULL ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY] I get the following error: Error 1 Unexpected token was encountered. If I change the [description] [nvarchar] (MAX) NULL, to [descript ...Show All

• SQL Server How to stop a package

  Hi, In one of my packages, I have a script component to do a transformation and I am inserting the output to table. Within that script component, if the data does not match my requirement, I have to stop the job. For that, I am using 'componentmetadata.fireError' to raise an error. The problem is, now even when an error is raised, the job completes by loading the remaining records and then aborts. But I want to abort the job as soon it raises ...Show All

• Visual Studio Team System Uninstalling SDK samples

  Hi I've built the SDM SDK samples and after playing with them I now want to uninstall them. Using control panel->remove software which runs the WiX uninstaller created for each project doesn't get rid of the icons still showing on the toolbox... is the uninstalling process supposed to properly get rid of registry entries I was expecting the uninstaller to totally clean any samples traces in VS... am I wrong ...Show All

• SQL Server The transaction log for database 'mydatabase' is full. To find out why space in the log cannot be reused, see the log_reuse_wait

  Every time I get this error, at different points of testing inserts and deletions on my table: The transaction log for database 'mydatabase' is full. To find out why space in the log cannot be reused, see the log_reuse_wait_desc column in sys.databases Why do I keep getting this All I'm doing is deleting several hundred thousand records and inserting them into a couple of tables. i shouldn't have to truncate my log every time or my application ...Show All

• Visual C# rounding up

  Is there a way to make a value round up in C#   Example,   make 2.35  round to 2. 5 or round to 3. ...Show All

• Software Development for Windows Vista Tutoral - Lab 3 Ex 1 Tk 3 logging

  In the task, it adds a listener writing to WFHOLTrace.log. I noticed that there is another log created, named WorkflowTrace.log. Anyone have an insight into this I think it has something to do with : < switches > < add name = " WorkflowTraceToDefault " value = " 0 " /> ... </ switches > if you remove the WorkflowTraceToDefault, this trace file won' ...Show All

• SQL Server Poison Message Sample in BOL

  Hi,  We've been trying to diagnose a problem with service broker's poison message detection and tried to run the sample script in BOL to see how it solved the problem.  It appears the example doesn't seem to work correctly,           IF (@messageTypeName =               '//Adventure-Works.com/AccountsPayable/ExpenseReport') &n ...Show All

• .NET Development Is the NET framework 2 the final version or beta?

  Is the NET framework 2 the final version or beta My hosting provider is running NET Framework 1.1 and I hope for an upgrade… It has just been announced that Visual Studio will be released on November 7th: http://www.informationweek.com/story/showArticle.jhtml articleID=164301022&tid=13692 ...Show All

• Visual C# classes best practices

  Hey guys, I am still new at this and was wondering what the best practices for creating and handling classes were. Is it better to build my classes inside one major C# file or do I need to create an individual file for each individual class or is it just better to have my classes embedded in the particular form I am working on Which is the best approach and best practice for classes Thanks, ~zero In my opinion it does not really m ...Show All

• Windows Forms How to set the DateTimePicker background color?

  Hello, I have a simple newbie question: How can I set the background of a DateTimePicker control. I have tried several things but the backcolor doesn't change. I can set all colors of the popup calendar but not the background color of the " ...Show All

• Visual Basic setup project can not build

  Hi, I am using vs 2003 to build a setup project but got this error message "Could not find file ..., Not enough storage is available to complete this operation." I checked the path of the file, it is correct. After I remove this file from the setup project, I can build it successfully and the result msi file is about 250MB, the file I removed is about 260MB, is there any limitation about the size of the file in setup project or the tot ...Show All

• Windows Forms New whitepapers for building DataGridView custom cells and columns

  Hi all, We just posted two new whitepapers about building custom cells and columns for the DataGridView control: Building a custom RadioButton cell and column for the DataGridView control ( Source and Sample Code ) Building a custom NumericUpDown cell and column for the DataGridView control ( Source and Sample Code ) The docs, source code and sample code are under http://www.windowsforms.net/WhidbeyFeatures/default.aspx P ...Show All

• Visual Studio Express Editions Not a member

  Results' is not a member of 'Working_Week_2_Coding_Assignment.Form1'. Why would I get the error message madref You would get the error message because the compiler believes that 'Results' is not a member of the class. You should take a look at your code and ensure the class (or a base-class) does have a member named 'Results'. ...Show All

• SQL Server file attribute using a control

  I have managed to capture the file path through some SSIS tasks. Now I am looking to read get the File Name present for a file in this path. How can I possibly do this Do I have to use the script task and write something up in VB.NET Hope there is an easier way out. I have been trying to figure out the File SYstem task. But that seems really complicated as well. Please let me know. This is an emergency for a special DEMO. Thank you!!! ...Show All

• Visual C# help with string!!!

  ok i have a project, in my poject  i have a client and a server the client send data to server over tcp/ip on a socket My data arrives as a bytes and then they are converted to chars.. Here`s the code a little bit CSocketPacket theSockId = ( CSocketPacket )asyn.AsyncState; //end receive... int iRx = 0; iRx = theSockId.thisSocket.EndReceive(asyn); char [] chars = new char [iRx + 1]; // decodes the bytes S ...Show All