Wint's Q&A profile

• Visual Studio Team System Uploading Process Template

  I have created a new process template from the existing Agile development one on our test foundation server. I would now like to take this template and load into another team foundation server we are setting up that will be used for production. When I try to load the above template it fails with this error message in the log - ---begin Exception entry--- Time: 2006-06-06 10:17:13Z Module: Template Importer Exception Type: System.Net.WebException Exception Message: response not OK WebException: Status : UnknownError Stack Trace: at Microsoft.TeamFoundation.Server.ELeadService.UploadMethodology(String filename, Int32 templateId) at Microsoft.TeamFoundation.Server.ELeadService.AddUpdateTemplate(String name, String description, String ...Show All

• Windows Forms Read profile and membership properties in a Winform application

  Hi All, I'm developing a small website with a backoffice winform application. The website has a profile section with user preferences, and I'm using the profile manager in web.config. The backoffice (winform) application needs to read some profile properties per user. I can access the membership information, but I didn't find any class or method to read the user profile, with their custom properties. I already referenced the System.Web namespace and included the membership and profile information in the app.config file.. Thank's for any help, Fabio A point of clarification is needed here, just because something is organized under System.Web does not mean it is intended only f ...Show All

• Visual Studio Express Editions Building a database?

  I havent learned to do and reference to database in VBE yet but untill I do, I was wandering if its possible to reference cells in an excel file in VBE and maybe even read and write to them Absolutely...two ways of going about this: ADO http://msdn.microsoft.com/library/default.asp url=/library/en-us/dnanchor/html/adonetanchor.asp Automation http://msdn2.microsoft.com/en-us/library/f27xe9xb.aspx ...Show All

• SQL Server New to SSIS, where to research how to normalize and re-key tables and lookups?

  I am just getting started studying SSIS with Kirk Haselden's "Integration Services" book. The problem I am trying to solve would seem easy enough to solve in code, but I am still early in the book and would like to be able to focus on the aspects of SSIS that would help me expedite this with SSIS, or to find out early whether what I need to do cannot be easily done. The problem itself is simple enough: I have a database of roughly 100 tables. Ignoring the poor normalization in the database for the moment, my more pressing problem is that that I need to rekey all of the main OLTP tables from a mashup of different key schemes to UNIQUEIDENTIFIERS. For example, Client table is presenrly keyed on an INT, Client Number. ClientFile ...Show All

• Software Development for Windows Vista Pattern for email approval?

  With a workflow hosted by a desktop application, we want to add an email-based approval to a workflow. It is clear how to send an email as part of a workflow, but what do you recommend for waiting for approval-via email Because the workflow is hosted by a desktop application, the workflow runtime might not be running when the approval email is returned. Michael I would take a look at the Human E-mail Workflow sample, which listens for incoming e-mail. If the workflow runtime needs to continue running after the user closes the Windows app, then you should consider hosting the workflow runtime in a service (i.e., a Windows service or a web service). You can create an ExternalDataExchange service that periodically polls for inco ...Show All

• SQL Server Use Variable as Table Name

  I am trying to write a stored procedure that accepts a table name as an argument and then displays all of the columns of the table. My code does not work and I don't know why any ideas set ANSI_NULLS ON set QUOTED_IDENTIFIER ON GO ALTER PROCEDURE [dbo] . [selectTable] @tableName varchar ( 50 ) AS select * from @tableName ; I get this error: Msg 1087, Level 15, State 2, Procedure selectTable, Line 5 Must declare the table variable "@tableName". Please help. why cant you just write exec(@sql) why do you need the Set @t = and the @ID is not used anywhere in the proc... i think you can acheive the same thing with the code below S ...Show All

• Smart Device Development Activesync on a headless Device Emulator OS design

  Hello, I'm trying to get ActiveSync to connect to a headless (well, at least shell-less) OS image built atop the Device Emulator BSP that ships with Windows Embedded 6.0 Platform Builder. I've included SYSGEN_AS_BASE and run connmc.exe and the 'PC Connection' applet within control panel to generate the appropriate RASBOOK entry/selection within the registry. The RASBOOK entry (called `DMA) is setup to connect via Serial over DMA, using the default 19200, 8, N, 1, Hardware settings. I cradle my device emulator via the device emulator manager and then attempt to manually run repllog.exe from the target control shell. Note that I haven't hooked into an event to launch repllog.exe automatically yet (is this OK ). The typical ActiveSync connect ...Show All

• SQL Server hopefully an easy one

  I need to determine the top 20 most frequent occurences of a value in a specific field using SQL. you mean something like this use northwind select top 20 customerid, count(customerid) as ordercount from orders group by customerid order by ordercount desc ...Show All

• SQL Server Problem referencing a global temporary table

  I'm having difficulty referencing a global temporary table in a stored procedure. My stored procedure will execute correctly for days on end, but then all of a sudden it will stop working and I will get messages like: Invalid object name '##TableName'. and Cannot drop the table '##TableName, because it does not exist in the system catalog. ========================================================================== In my stored procedure I am first creating my temporary table using the syntax below. I need to create a seed value from a parameter, so that is why I am using the SET @SQL and EXEC(@SQL) statements: SET @SQL = 'CREATE TABLE ##TableName ( [Value1] [varchar] (11) , [Value2] [numeric](13, 0) , [Value3] [varch ...Show All

• Windows Live Developer Forums Window Live Alerts SDK

  Hi Is there any forum present where I can post all my queries regarding Windows Live Alerts SDK Regards Makarand Thanks for reply. Here are few of my queries regarding Windows Live SDK 1) When I use Deliver method and send message to contacts which have signed up with Windows Live Alert however they are not a part of any Subscription groups, alerts are not send to individual contact. To send message to individual does he needs to be part of at least one group 2) For Status Codes like ReturnURL element invalid or missing, FeedURL element invalid or missing, ActionURL invalid or missing is there any regular expression we have to follow Many times we get these errors and don't know where exactly we are making mistakes. ...Show All

• Visual Studio Tools for Office Creating a VSTO 2005 SE Add-In

  dear all After creating the excel add-in using VSTO 2005. i have installed Add-in setup on client machine. How can i invoke function from excel sheet on click event of the cell on client machine. ...Show All

• SQL Server chi-square test

  hi all: do ms sql 2005 have chi-square test sincerly! ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. How do you implement Fog into a scene?

  Hi All, I have finally got some 3D up and running so things are whizzing about (which is always fun to watch... for a while, yeah I know, small things...) and I was wondering if anyone had any examples of putting fog into a scene. I tried last night and succeeded in turning all my meshes to white, not matter how far away they were from the camera. No matter what I did to the values, nothing changed. As always, any help is greatly appreciated. Cheers LeeC22 wrote: Shawn Hargreaves - MSFT wrote: The BasicEffect FogColor property is a Vector3, so it ranges from 0,0,0 = black to 1,1,1 = white, not all the way up to 255. For a mid-grey fog color, you can either set 0.5f, or use the conversion methods on the Colo ...Show All

• SQL Server Connect 2 different DBs in Same server

  HI all I want to connect the two different DBs in the same Sql Server. I have the SP that calls the other SP in different DB but in the same server. Both the DBs have diffrernt user names and login.. how can i do this.. ...Show All

• Visual C++ Building a code library

  I am writing a COM component. However, there are files that I would like other developers to use as an SDK. How do I build a code library In particular, I would like to supply 3 classes to other developers so that they dont have to redesign the wheel if they wish to use my library. I am using VS2005 I understand that developer will need to register a the DLLs. However, should I want to introduce another library that I feel that developer of plug-ins for my system may find handy, how do I do that. eg. I have 3 classes that I woould like to provide as utility classes, how do I create a link library for those classes My question here is not as much about COM but just how to build a link library in general ...Show All