Tzu-Yie's Q&A profile

• Visual Studio Team System Source tree collapses - get specific version (forced)

  Unexpected behavior. Source tree collapses for other expanded team projects when doing a get specific version with "Force get of file versions already in workspace" checked. I am assuming that you are referring to the treeview in the Source Control Explorer (SCE) showing multiple expanded team project subtrees. SCE used to have this problem of not remember the treeview expand states. I believe this problem has been fixed in VSTF RTM. -Tan ...Show All

• Software Development for Windows Vista Alert ! Vista Explorer only supports 16'383 File Copy Operations !!!

  after copying about 16'383 files you must re-boot Vista, because Vista Explorer begins making nonsense. Try it that way: make a new directory somewhere on your harddisk open Notepad and immediatley save in your new directory (the Notpad .txt file can be empty or not) select that saved Notepad .txt file with Vista Explorer do exactly the following 16 times - it will take longer and loger any time of course (up to minutes in the last cycle): ctrl-a    ctrl-c    ctrl-v   (Select all files in the directory, copy them, paste them) === I'm shure you will get a message " ... out of memory ... " - and you have to reboot for a stable system. And your new directory will have less the ...Show All

• Windows Live Developer Forums Placing a pushpin in a on a specific location

  hey, how do you replace map.GetCenter() with a custom location so that the pushpin is placed at a specific position on the map Thanks ...Show All

• .NET Development Sql server 2005 ==> 1000 times slower than sql server 2000 ! WHY ?

  I'm using the developper edition of sql server 2005 with VS2005. Sometimes it works very very slow. I don't know why ! The processor is at 5% but the execution blocks at adapter.Fill(ds). This is the code: public static DataSet GetDataSet( string sql, params SqlParameter [] parameters) { SqlConnection con=GetConnection(); using ( SqlDataAdapter adapter= new SqlDataAdapter ()) { using ( SqlCommand command= new SqlCommand (sql, con)) { foreach ( SqlParameter p in parameters) { command.Parameters.Add(p); } adapter.SelectCommand=command; DataSet ds= new DataSet (); adapter.Fill(ds); command.Parameters.Clear(); con.Close(); return (ds); } } } Is ...Show All

• Smart Device Development how to read an incoming email in pocketPC 2003?

  Excuse me anybody know about how to read an incoming email in pocketPC 2003 I have tested a lot times,and I have downloaded VOmapi,but still not got exact email body content,Please help me,Thanks! http://msdn.microsoft.com/library/default.asp url=/library/en-us/dnppcgen/html/ppc_2002part2.asp I debug the MAPI2 project based on this article in EVC4.0 and POCKETPC 2003,I found the email'body display exactly in the first time running,but when I select another email (this mail'body shorter than the first email's),I found the second mail's body display not exactly.It display more content than its exact content. anybody can help me Thanks! ...Show All

• SQL Server Convert DT_14 to DT_18

  Hi! I have a Fact_data flow with several Lookups. In one there's OLE Db source DT_14 (persons id's) which need to be compared to a column DT_18 from Dim_salesperson. Thats how I could collect the ID's from Dim_salesperson into OLE DB Destination. How could I compare, DT_14 data with DT_18 First converting DT_14 to character. Secondly char to DT_18 I would be so grateful if someone could give an idea... curiousss wrote: First converting DT_14 to character. Secondly char to DT_18 Assuming you are talking about DT_I4 and DT_I8; that approach sounds reasonable. Have you try it ...Show All

• SQL Server SQL Server 2005 Std Ed SP2. - Lock Pages In Memory

  How do I determine if Lock Pages In Memory is applied I have the Policy to the Service Account. Thanks - Covi Thank You for replying, I have Locked Pages In Memory set on to the Service Account. How can I confirm other than looking at the setting that it is truley being applied to SQL Server 2005 Std. Ed. Is there a counter or something that confirmes the setting is being applied by SQL Server. ...Show All

• SQL Server trigger for running totals

  Hello, I haven't had a lot of experience with triggers and I am trying to create a statement that will update one table with totals from columns in another table. Here are my two tables: tblProjects projectID projectName projectStatus PCCount PCComplete 177 proj1 Complete 100 100 178 proj2 In-Process 200 150 179 proj3 In-Process 50 0 tblPhases PhaseID projectID phaseName PCCount PCComplete 4 177 phase1 36 36 12 177 phase2 64 64 20 178 phase3 50 50 22 178 phase4 150 100 I want to have the PCCount cell for a specific project in tblProjects contain the sum of the counts of the PCCount cells in tblPhases for each PhaseID tied to a specific ProjectID. In other words, for every project in tblProjects, there are one or more phases ...Show All

• Smart Device Development Struct and bytes array

  Hello! There are some problems with put struct on bytes array in CompactFramework. I try to use Marshal.PtrToStructure, but it does not work in PocketPC, because attribute FieldOffset() can't work with non intersect fields in my structure(field alignment requirements ). Please, prompt me what other way exists. Thanks! Thanks! I have managed memory block (array of bytes receiced from remote device) and I want to put structs on this memory without take to pieces every struct fields. ...Show All

• SQL Server Failed to install: Cumulative hotfix package (build 2153) for SQL Server 2005 (KB918222)

  Hi experts! I try to update SQL Server 2005 SP1 with the Cumulative hotfix package (build 2153). I need to do this, because I get an error this hotfix is said to fix... and of course - the update completely crashes (sending an error report to microsoft).   Here is what the log looks like:   Failed ACL:   SetSecurityFileDescriptor is failed at the error code 5; Converted SDDL: '(A;OICI;FA;;;S-1-5-21-1276437202-3579633377-1796755180-1012)'         Error Code: 0x80077342 (29506) Windows Error Text:   Source File Name: sqlca\sqlsddlca.cpp Compiler Timestamp: Tue Apr 11 11:45:24 2006      Function Name: ExceptionInSDDL Source Line Number: 65   ...Show All

• Visual Studio How do I prevent a Solution Item from being opened on AddFromFile?

  Hi, I've developed a Project group wizard that adds items to the solution items of a solution, the problem is that when I add a testrunconfig file or an xml file to the solution items by using: Project prjSolItems = (( Solution2 )solution).AddSolutionFolder( "Solution Items" ); prjSolItems.ProjectItems.AddFromFile("C:\\SomeFolder\\localtestrun.testrunconfig"); The IDE opens a dialog with the test configuration and I have to press close for my wizard to continue. Is there a way of preventing this model dialog from opening Thanks Gabo Thanks for the reply, I've also checked the MSDN site as well and it is posted there but MS says that it will not be fixed in the next v ...Show All

• SQL Server Encrypt data in a Stored Procedure

  I am trying to insert data in a table using a stored procedure, but somehow I cannot store the values passed by the stored procedure in the table. Table has two fields FIRST_NAME, LAST_NAME with varbinary data type(I need to encrypt the data) My stored procedure is as follows. Please let me know what i am doing wrong! *************************************************************** ALTER PROCEDURE [dbo].[SP_InsertInfo] -- Add the parameters for the stored procedure here @FIRST_NAME varBINARY(100) ,@LAST_NAME varBINARY(100) AS OPEN SYMMETRIC KEY key DECRYPTION BY CERTIFICATE cert BEGIN SET NOCOUNT ON; -- Insert statements for procedure here Insert into [dbo].[INFO] (FIRST_NAME, LAST_NAME) Values ...Show All

• SQL Server Table Usage Monitoring

  Is there a way to track tables/indexes/stored procedures that are being used I know that the Profiler can do this but I am looking for a way to query a system table to get this information. Oracle has a way to turn on/off monitorint for tables and indexes so I was wondering if this info is avaialble and if so if something needs to be done to activate the collection of the info. Thanks No, this information can only be collected by profiler or by the logic that you implemented in your stored procedure as somebody accesses them. HTH, Jens Suessmeyer. --- http://www.sqlserver2005.de --- ...Show All

• Visual Studio 2008 (Pre-release) Imaging problem in June CTP

  Bitmaps do not display in the Image control using the June CTP. I've seen some "DLL conflict" errors in my efforts to work out how my code needed to be changed from Beta 2. Seems similar to the thread http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=507038&SiteID=1 but the fix there does not work. Any ideas John Well now I know it's not just me. I should have mentioned in my other post that I am using the June CTP. It's the first time I've installed it and looked at WPF so you can imagine my confusion. ...Show All

• Visual Studio Team System Team Foundation and Reports

  Hi guys, I am new to team foundation. I have to generate reports using Team foundation. Any idea how it can be done. Thanks, Aditya You can start by reading Team Foundation Server Reporting  http://msdn2.microsoft.com/en-us/library/ms194922(VS.80).aspx Then if you have specific questions I would ask in the Team Foundation Server - Reporting & Warehouse forums http://forums.microsoft.com/MSDN/ShowForum.aspx ForumID=480&SiteID=1       ...Show All