Robert Vabo's Q&A profile

• SQL Server Problem Rendering to PDF File

  I have a data driven subscription set up on a report that emails out to over 200 people based on the report running a parameter for each person. The report attaches to the email as a PDF file. The report renders fine and is emailed to everyone except for one person. I figured out that the report is not rendering to a PDF if I run the report for this person. The only issue I can possibly see as the problem is this person has the largest report compared to everyone else. If I set the report and subscription to render to any other format but PDF just fine for this person, however, I really need to be sending the file as a PDF, just like all the ...Show All

• SQL Server Strange performance problem or bug in SQL 2005.

  Hi, I execute a stored procedure in my database from code using DataReader or DataTable from my ASP.NET 2.0 application. No matter what object data are put into it take about 12 s! Performance is very slow even terrible, because before using SQL 2000 database it was 200-300 ms. I fought it is a bad execution plan, but when I execute the same procedure usinf Management Studio it takes 100 ms! I have tried many times to execute it in these 2 different ways and results are always the same. When I look into profiler it shows: for execution from my code: Batch, CPU about 12000, Read 602975 for execution from Management Studio: Batc ...Show All

• SQL Server Merge Join Problem

  Hello, I've got a problem with the merge join operator. I'm trying to Join two tables using a left outer join. Here are my tables : TABLE AGENT AGENT_CODE; REGION_ID; COUNTRY_ID AA;01;01; BB;01;01; CC;01;02; CC;02;02; DD;01;01; 600 records in this table. TABLE DELEGUE AGENT_CODE; FIRST_NAME; LAST_NAME AA; Maradona;Diego; BB; Maradona;Diego; DD; Zidane;Zinedine; 145 records in this table. This is what i expect in my left outer join: AGENT_CODE; REGION_ID; COUNTRY_ID;FIRST_NAME; LAST_NAME AA;01;01;Maradona;Diego; BB;01;01;Maradona;Diego; CC;01;02;NULL;NULL CC;02;02;NULL;NULL; DD;01;01;Zidane;Zinedine 600 records in the destination table, with ...Show All

• Visual Basic Blair Allen Stark

  Here is the problem I am working on. It asks me to use the method CalculateCharges, but I don't fully understand how to do this or how it works. I would be grateful for any input. Lab Problem III A parking garage charges a $2.00 minimum fee to park for up to three hours. The garage charges an additional $0.50 per hour for each hour or part thereof in excess of three hours. The maximum charge for any given 24-hour period is $10.00. Assume that no car parks for longer than 24 hours at a time. Develop a console program that calculate and displays the charges for each customer who parked a car in this garage yesterday. ...Show All

• SQL Server updating XML in SS05

  When I update portions of an XML document in SS05, am I forced to update the entire document. The XQuery standard seems to imply this, so I'm wondering if the good folks at MS have offered us perhaps their own way to avoid doing a full document refresh on a single change. Help ...Show All

• SQL Server SSRS 2005 Report in SSIS task

  In one of my SSIS Project tasks I insert some records into a table. I want to somehow fire off an SSRS report and send this report to some staff members. how would I add a component to reference or run an SSRS report off the table I just inserted to all from SSIS I assume I'd h ave to create the report in SSRS first, then somehow reference it from SSIS and then figure out a way to run the report, maybe export it into Excel format and send to the users....not sure how to go about all this in my SSIS package. Reporting Services is a web service and as far as I know all RS functionality can be invoked via a WS call. So, one would think ...Show All

• SQL Server accuracy vs generalization

  Hi! So sorry for posting yet another one of my silly posts about the correct way of doing things! I am using Stored Procedures to do various things in my database (inserting/deleting/updating) and using SQL Server 2000 SP4 The current situation is that I have a stored procedure which checks certain user details and returns either -1 or 1 as a success indicator to the caller. Now, obviously if we executed several queries in this stored procedure, performance will be an issue. However, I have no idea how to balance up the whole "more useful information" vs "general information". What I mean is thi ...Show All

• SQL Server UDT not being created at Subscriber

  Hi, We are using a SQL Server 2005 RTM (publisher and distributor), the subscriber is a SQL 2000 instance and we are getting errors during the initialization because the publication is not creating the user-defined data types at the subscriber. We are using Transactional Replication with pull subscription. The article is created with "Copy Default Bindings" and "Copy Rule Binding" options via Management Studio but when we later go and look at the Publication properties these values are False. We can overcome this issue by creating the UTD at the subscriber but i would expect them to be created. Has anyone else come accross this Cheers ...Show All

• Visual Studio Team System Recreating TF DIR using the TFS API

  I want to recreate the equivalent of "tf dir $/Foo /server:<servername>" where I don't have $/Foo mapped into a local workspace.  It looks like VersionControlServer has the GetItems() methods I need to list the repository contents. However I can't figure out how to create a VersionControlServer instance.  Any ideas on how to get a hold of a VersionControlServer instance   FYI, this is for a Monad (MSH) provider that I'm experimenting with. Here's an API example that uses GetItems() to display the sizes and dates of files in a format similar to cmd.exe's dir command. http://blogs. ...Show All

• .NET Development Not Implemented SoapException

  Hello, I'm developing a Pocket PC application that uses a web service to retrieve data. I'm using CF2.0, programming in C# and using VS2005 Team Suite. The problem I am having is as follows: I have developed a web service that works on it's own. When testing through a browser or desktop form the HelloWorld() method works perfectly fine. When accessing the same method through the Pocket PC emulator or a Pocket PC device, it returns a SoapException with a "Not Implemented" status code. Here is the code for the client application: using System; using System.Collections.Generic; using System.ComponentModel; u ...Show All

• Visual C# MDI Menu merge not working

  Has anyone had any success menu merging with the toolstripmenuitem in an MDI app There doesn't seem to be any way to merge without duplicating menu items in the child menu. eg: Parent: File ->New ->---- ->Exit Child: File ->Save Results in (at best!): ->New ->---- ->Exit ->Save Plus, if there's multiple child windows, the inactive windows display the child's menu. When they regain focus the menu disappears, when they lose focus it reappears. Thanks, R. thanks for the suggestion, but this doesn't produce the right results either. I think the MergeAction has something to do with it but I'm not sure how. ...Show All

• Software Development for Windows Vista Designtime changed values (by code)

  Hello, I have an other problem with the dependency Properties. I have a custom Designer for some of my custom activities. On DoubleClicking the Avtivitiy a form is shown with wome different inputs for the user. On Closing the form the entered values will be saved in the Properties of the activities. The Problem is first time i change the values everything works correct. But if i try to change the values after reloading the workflow, they don`t change their values anymore. It only works if i type the values directly into the Property Grid. Example of saving the values in the form: private void btnOK_Click(object sender, EventArgs e) { ...Show All

• Visual C++ How to delete a member function in VS2005 like in VC6?

  In VC6, I can delete a member function by selecting the member function and select delete from pop-up menu, after that, both the declaration & definition are deleted in .h & .cpp file. I like this function very much because it's very convenient. But now in VS2005, where is that function Hi Xei Fu, This functionality is no longer available in any version post 6.0. Feedback from  customers in 6.0 was that the functionality was confusing. You might want to enter an issue on the MSDN feedback center so other custoemrs can vote on it: http://lab.msdn.microsoft.com/ProductFeedback/ Thanks. Ronald Laeremans Visual C++ team ...Show All

• Visual Studio Team System Backup you data with Team Foundation Server Beta 3

  Since the documentation looks to be outdated: What are the steps to take to backup all the data within TFS3. It should be a backup of all tables (including SharePoint Services and Reporting Serves data) from SQL Server and a backup of Windows SharePoint Services. Is that it Are the attachements now stored within the database Thanks, Neno Yes, all of the mutable data is now within the database.  So backing up TFS is just backing up all of the SQL databases on the data tier.  Our admin and operations guide will have details on how to do that but it's pretty straight forward. ...Show All

• Visual Studio Express Editions Code required for clearing text boxes

  Im new to C++, and i would like to know the code for clearing a text box when you click on a menu button. Please follow your thread at http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=387614&SiteID=1 . ...Show All