Jorge L. Perez's Q&A profile

• SQL Server SSIS SQL Agent Schedule job problem

  Hi everyone, I have a log table that track my SSIS scheduled jobs. This SQL Agent job runs every 15 minutes for now. The problem is, when I check the status(log) table, I see it fails and succeed at random. I have checked the history and I can't figure out why it is doing this. Has anyone any idea what is going on At least for the fact that the package succeeds after it failed shows that nothing is wrong with it. Again when I query my deti ...Show All

• Smart Device Development Native DLL, how can I deploy different DLL's based on device - IE: Emulator (X86/Arm/MIPS) etc

  I have a native DLL.  How can I deploy different DLL's based on device - IE: Emulator (X86/Arm/MIPS) etc. I've seen SQL Server CE do this (seperate cabs for each platform), how can I do the same Thanks! If you asking about production deployment, you need to build several CABs one for each supported processor. You probably would have to tweak INF file to do that. If you’re targeting PPC 2002 or above, all you need is an ARM ...Show All

• Visual Studio Team System VisualStudio does not see multiple test classes defined in same file

  This may be a known issue. A quick search did not find anything, so I'm posting it here. I added two unit test classes to the same *.vb file. If you do so, the tests are not listed in the View Tests in Visual Studio. If you break the two classes out into separate files, they are listed properly. I do not normally put more than one class into the same unit test file and it is not a big deal. I didn't find anything in the documentation, however ...Show All

• .NET Development XML serialization

  Hi, From the following code public abstract class Vehicle {     public string licenseNumber; } public class Car : Vehicle {    public string name; } ... Car c= new Car(); c.licenseNumber="Lic001"; c.name= "Fiesta"; what is the simplest way to get  the following serialized XML output <Vehicle licenceNumber="Lic001">     <Car name="Fiesta">     &l ...Show All

• Architecture db design question. . .

  My boss and I are having a disagreement. In our schema (SQL 2000), we have SSN nullable indexed. A year ago, we took a job that allowed one of our clients to do some batch processing that updated their HR database personnel into our database. The driver on this was an employee number. If the employee number is found, data is updated, if not it is inserted. Everything worked fine when it was one branch office. ...Show All

• SQL Server SQL 2005 Developer Installation Problem (WMI Permission)

  I am getting following error from SQL 2005 Developer installation. " SQL Server Setup failed to modify security permissions on WMI namespace \\.\root\Microsoft\SqlServer\ServerEvents\SQL2K5 . To proceed, verify that the account and domain running SQL Server Setup exist, that the account running SQL Server Setup has administrator privileges, and that the WMI namespace  exists on the destination drive." More information about my box. - Acc ...Show All

• SQL Server Subscription Delivery to My Folders

  Dear Anyone, Is it possible in the subscription feature to deliver the reports directly to the user's My Folder For example, if I have a data driven subcription of which I want to deliver in excel format the reports of my users in their respective my folders. Is this possible Thanks, Joseph ...Show All

• Software Development for Windows Vista What is the purpose of message pump?

  Hi all, I am new to Windows development and currently trying to wrap my head around the purpose of the "message pump" as seen in this document. http://msdn.microsoft.com/library/default.asp url=/library/en-us/dllproc/base/waiting_in_a_message_loop.asp From the document, I guess the message pump is pretty much this chunk of code // Read all of the messages in this next loop, // removing each message as we read it. ...Show All

• Software Development for Windows Vista All started workflow instances

  How can I get all the started instances of a given workflow type. I.e. not just those in memory (as some will have been unloaded to to the persistance store while they wait for an event or timeout). Ta in advence, Michael If you are using SqlWorkflowPersistenceService you could use the service's GetAllWorkflows method. PjV ...Show All

• SQL Server Cannot Open User Default Database (error 4064)

  Hi, SQL Server 2005 installed on my computer. i was trying to make a login page with VS.2005 pro. But i got some errors on Website Administration Tool. Whatsoever, i registered a database (aspnetdb) . Then, i think i made my default database to aspnetdb. Something went wrong and i decided to delete aspnetdb and start whole procces from the begining and i did it. AAANDD WHOOOLA. I got this error: Cannot Open User Default Database, Login Failed M ...Show All

• Visual Studio Express Editions Uses of VC++

  What does it mean on the download/install page where it says: "You can use Visual C++ Express to build powerful .NET Framework applications immediately after installation. In order to use Visual C++ Express to build Win32 applications, you'll need to take just a few more steps." And is there a button to compile and run your C source code without messing around in a cmd window Hi! It's advertisement :) Visual Studio have ...Show All

• Visual Studio Team System I have install TFS in local system account, can I switch to AD account as user ?

  Hi. I have already install the TFS in Local system account, but later I decide to use AD account as user to login. Can I switch this by config I saw the installation guide, it says... no way..... Single-Server Deployment To set up and configure Team Foundation Server using a single-server deployment on a computer joined to an Active Directory domain, you need three Active Directory domain user accounts as outlined in the fo ...Show All

• Windows Forms How can I add lines in a richTextBox in C# ????

  Hi, I’m working Visual C# .NET 1.1 I have got a richTextBox control with 4 lines: Line 1 Line 2 Line 3 Line 4 Now I want go add one line between Line 1 and Line 2 for example. Line 1 New Line Line 2 Line 3 Line 4 But I don’t know how I can do it. I have tried with richTextBox1.Lines[1].Insert It is possible to add a new lines between others Any example Any help Thanks in advance !!!! ...Show All

• Visual Studio Paging in toolbar off-by-one

  I'm using the ReportViewer control in a WinForms project, using Local processing mode.  On the report itself, it always correctly shows the current page and total number of pages in the report using Globals!PageNumber and Globals!TotalPages.  However, in the toolbar page navigator, the total number of pages is always initially shown as one less than the actual number of total pages. For example, I've got a report that actually has ...Show All

• Windows Forms How to guarantee modelessness in .NET Form in Class Library?

  In VB6, the App.NonModalAllowed property would tell you whether you could show a modeless form or not. The docs for .NET say... "No equivalent. This was a read-only property related to ActiveX .dll files. The .NET common language runtime automatically manages this behavior." ...which does not explain what is happening.  I'm guessing that the clr shows the form as modal if non-modal is not supported. I have a .NET class library which ...Show All