Juan Camilo's Q&A profile

• .NET Development XSD and Database schema creation

  I have a XSD but would love to 'generate' a SQL DB schema from it. Anyone know of any tool or how to do this usnig VS Thanks in advance. Do you have any specifics of what the database schema should look like You can try out the SchemaGen feature in SQLXML 3.0 - check out http://www.microsoft.com/downloads/details.aspx FamilyID=51d4a154-8e23-47d2-a033-764259cfb53b&DisplayLang=en - The usage of bulkloa ...Show All

• SQL Server How to truncate the log file

  How do I truncate the log file using TSQL   My client's log file is 44 gig and there isn't enough HD space.  Thanks The log will truncate if 1) simple recovery mode is set and 2) checkpoint is issued or the log is backed up. Otherwise, you need to truncate it every now and then manually. Try this: DBCC SHRINKFILE('mastlog'); The preceding truncates the master DB log file. 'mastlog' referes to ...Show All

• SQL Server get error code 1603 while installing sql server 2005

  hi, while i installing the visual studio beta 2 with sql server 2005, it get error code 1603 while installing sql server 2005. and my desktop pc installed only visual studio 2003. I have no install visual studio 2005 beta 1. and i try uninstall all visual studio s/w and jz install 2005 beta 2 but it stil get this error. I have update my desktop ,scan using MBSA and update all those necessary update. i have the sa ...Show All

• Visual C# How to create local instance of the remote object

  The question is How to create local instance of the remote object For example, the server class MyClass in computer A contains a method create() to create a file in "c:\", if the client in computer B creates a remote object from A :  MyClass mc = new MyClass() and call the method create(): mc.create(), it will create a file in the c:\ of A, not B. How can I create a local instance of MyClass so that when ...Show All

• Windows Forms Windows Forms Control Deployment

  PROBLEM: I have made custom contorls and used them in a few projects.  Is there a way, that when changes are made to a custom control, it does not have to be re-drawn on the form manually. For example, if i use a custom control ten&nb ...Show All

• Visual C++ Sorting of msflexgrid control in VC++

  I want to sort data that is being displayed in my msflexgrid control. All data of a column needs to be sorted on the selection of the column header. Just like we can sort the items in our inbox in outlook by clicking on the tab headings "From", "Date", "Subject", etc. This is a very simple task in VB. But I am unable to find the method to implement it using VC++. Can somebody please help Thank you Ronald. That was exactly wh ...Show All

• Visual Studio 2008 (Pre-release) LINQ Preview and VS2005 RTM

  What exactly are the implications of installing the LINQ preview against VS RTM I mean, does it replace the c# compiler In that case, does the new compiler work seamlessly against standard .NET 2.0 / c# 2.0 applications (I mean, is it safe to use the new compiler for standard development ) Regards, Juan No, it doesn't replaces an original C# compiler and you'll have two compilers. Besides you may not install " ...Show All

• SQL Server RS 2005 and winforms control: sample please!!

  here is the deal: what are the steps for a client app to run a report published on rs server I know how to refer to the server and the report. but the auth steps need some details added. example:  client and server are not on the same LAN and not in a common domain. client needs to auth to the server to get the report. examples needed in detail: forms auth windows user asp.net membership auth. can client certificates help if so what steps ...Show All

• SQL Server CREATE SCHEMA in db A from a stored procedure in db B

  Hi All I have a SP that i create tables and other objects on another database. Creating table work well. declare @s nvarchar ( 2000 ) set @s = 'use db01' set @s = @s + 'CREATE TABLE ABC (recid int) exec ( @s ) ------------------------------------------------------------------------ But if i try to create a schema it gives error : 'CREATE SCHEMA' must be the first statement in a q ...Show All

• Windows Forms Close multiple forms

  I've create a no. of Windows Forms and they are related in the following sequence. FormStart --> FormA1 --> FormA2 FormStart --> FormB1 --> FormA1 --> FormA2 The problem is when I reached end of FormA2. I need to provide a method to close all the Form and back to FormStart. How can I achieve this I can't simply use me.owner.owner.close as the no. of level is not equal. There could be another way to do this but I pic ...Show All

• SQL Server Non aggregate case

  Hello, In the same fact table, I have real values and min/max values. The type of value (real, min, max) is a dimension. So, I want to aggregate value only for real value, because for min/max values, all the leaf are filled by my program. So, it's possible to say "I want the not aggregate value in the database" in MDX query Thank you, Guillaume. Thank you ! Ok, now I created 2 NamedCalcula ...Show All

• Windows Forms Localized Deployment, localized .NET installer

  Hi, I want to localize the deployment (Russian and other languages) of my Win Application. I know how to localize the MSI (localization dropdown option), but how to localize the .NET installer I read in the help article : ms-help://MS.VSCC.v80/MS.MSDN.v80/MS.VisualStudio.v80.en/dv_deploy/html/eee53da5-bc30-454f-9271-ff35f02313a8.htm that one can download localized merge modules (dotnetfxredist_x86_language.msm) from the MS website, but I ca ...Show All

• Visual Studio Team System Estimate Extensibility

  My current work item tracking system allows estimates to be done for a work item for each of the different stages of development (e.g. functional spec creation and review, code and unit test, code review, etc.). I would like to extend the estimates functionality in VSTS to support this. But I don't just want to add a bunch of hardcoded fields -- I would like a grid that contains a one-to-many relationship from the work item record to the esti ...Show All

• SQL Server SQL Server 2005 SP1 installation hangs at authentication verification

  After the installer has asked for authentication mode and has started verifying the authentication it simply hangs. I've let it sit there for an hour before taking the installer forcibly down but nothing seems to be happening except for two osql.exe processes showing up in the task manager. I've tried both windows authentication and SQL server authentication but the outcome is always the same. At the same time I'm, however, able to login to t ...Show All

• Visual Studio Team System How to Create Tests Lists

  I wanted to create a build that would run some tests. I select Run Test and see vsmdi file in the dropdown. But there are no test lists to run. I have developer version of VSTS is there a way for me to create test lists. Thank you, Shimon. In theory, the answer is "Get the Test Edition or Team Suite".  Test lists are created in the vsmdi using a tool named Test Manager which is included in the afo ...Show All