GrayMatter Software's Q&A profile

• Visual Studio Team System Restoring single TFS on a different server

  Hello everyone I was wondering if someone can share how to restore a single tfs installation to a different server I have already used http://blogs.msdn.com/vstsue/articles/511396.aspx to restore tfs but now I would like to restore on a different box for disaster recovery purposes to make sure that hole is filled. Thanks Shahab Here's a collection of documents describing how to move Team Foundation Servers in various ways. Please let us know if this doesn't cover the scenario you're interested in: http://msdn2.microsoft.com/en-us/library/ms404879.aspx ...Show All

• SQL Server SSIS Data Flow task fails to load all text from flat file

  Hi Guys, I have a flat file which is loaded into the database on a daily basis. The file contains rows of strings which I load into a table, specifically to a column of length 8000. The string has a length of 690, but the format is like 'xxxxxx xx xx..' and so on, where 'xxxx' represents data. So there are spaces, etc present in the middle. Previously I used SQL 2000 DTS to load the files in, and it was just a Column Transformation with the Col001 from the text file loading straight to my table column. After the load, if I select len(col) it gives me 750 for all rows. Once I started to migrate this to SSIS, I allocated the Control Flow Task and specified the flat file source and the oledb destination, and gave the output column ...Show All

• SQL Server Error: The backup of the file or filegroup "sysft_XXXX_FT" is not permitted because it is not online

  Hi There, I am trying to do a full back up of a user database which has full text indexing on it. I use the maintenance plan wizard to set up a full backup. For some reason, I get this error. ================= Executing the query "BACKUP DATABASE [XXXX] TO [XXXX] WITH NOFORMAT, NOINIT, NAME = N'XXXX_backup_20060819040020', SKIP, REWIND, NOUNLOAD, STATS = 10 " failed with the following error: "The backup of the file or filegroup "sysft_XXXX_FT" is not permitted because it is not online. BACKUP can be performed by using the FILEGROUP or FILE clauses to restrict the selection to include only online data. BACKUP DATABASE is terminating abnormally.". Possible failure reasons: Problems with the query, " ...Show All

• Visual Studio Tools for Office VS2005, office projects do NOT appear, even after installing VSTO

  hiya, I installed the VSTO on a fully up to date win XP pro machine. The install was successfull (well, I received a message saying so) I re-booted my machine. The office projects do not appear in the project templates list. Any idea why cheers, yogi hiya, No I don not see theVSTO option listed. All I see is: Microsoft Visual Studio 2005 Version 8.0.50727.42 (RTM.050727-4200) Microsoft .NET Framework Version 2.0.50727 Installed Edition: Professional Microsoft Visual Basic 2005 77626-009-0000007-41315 Microsoft Visual Basic 2005 Microsoft Visual C# 2005 77626-009-0000007-41315 Microsoft Visual C# 2005 Microsoft Visual Web Developer 2005 77626-009-0000007-41315 M ...Show All

• Visual Studio 2008 (Pre-release) Basic WPF Question

  Hi, I just started looking at WPF, xaml. I am going though one of those Microsoft E-Learning courses. From that I see in my Visual Studio 2005. File/New/Project, that I do not have the .NET 3.0 Framework choice. What actually do I need to start projects like the above. I have VS 2005, Windows XP. I am guessing that I need to do some downloads, not sure what though. Thanks Jeff Hi Eddie, I did not have .NET framework 3.0 so I downloaded both. I am a little hesitant to install Fidalgo, sounds like a install at your own risk. Though I want to try some of this out. Thanks Jeff ...Show All

• Visual Studio Team System Field won't copy from another field on New Work Item Activation

  I'm trying to create a new work item type for my company. One of the fields they want to track easily is the alarm's initial priority when it was first opened. I figured this would be easy by adding a new field called "Initial Priority" and copying in the value from the Priority field when the work item was created. However it does not seem to be working for me. In the Transitions section under the Transition from "" to Active, I have the following, but it doesn't seem to work. < FIELD refname = " AuthNet.Fields.InitialPriority " > < COPY from = " field " field = " Microsoft.VSTS.Common.Priority " /> </ FIELD > When the new work item is saved, ...Show All

• .NET Development Inserting and retreving images from DB

  Hi there I am facing a problem with SQL Server Express. I want to save an image in the DB and then retreive it from the DB later. I realized that there is a field in SQL Server of type "image". I think this is for saving images and other files like small videos. However, since I am programming in C# I don't know whether there is a datatype "Image". If tis is true how can I manage to save and then an image from SQL Server Express using C# Regards You need to use stream in .net, please refer to the following KB 326502 HOW TO: Read and Write BLOB Data by Using ADO.NET Through ASP.NET http://support.microsoft.com/default.aspx scid=kb;EN-US;326502 ...Show All

• SQL Server OLEDB Destination question

  Situation I have a package with an execute SQL task that truncates the destination table as the first step in the control flow and a data flow task that reads data from a flat file and loads a sql server table. Once in a while the package bombs because it cannot get access to the flat file. The end result is that the table is empty because the truncate runs first. Obviously, I need to address the file contention, but I was wondering how to address this issue in general since anything that causes the data flow to blow up would leave the table empty. I would rather have the table with day old data than empty, since it is not mission critical and the users can at least look at yesterday's data as opposed to nothing. Question ...Show All

• Visual Basic how can I creat a shortcut in clickonce ... ?

  when I publish my project, ClickOnce Technology not support a shortcut .. so is there any way to create it If you're asking for a desktop shortcut (or any other shortcut other than the one ClickOnce adds to the Start menu | Programs for you), then the answer is currently no. ClickOnce does not provide a mechanism to do this in the current version. It's definitely a requested topic, so I'm hopeful that it's something the team will be able to add in a future release, but that will be then & this is now. You can find some more details here: http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=138691&SiteID=1 hth, e- Eric.Knox@microsoft.com ...Show All

• Windows Forms Form Loaded Event

  Hi, Is there an event that is called when a form and all of its controls etc have been loaded. I need to make a SQL queery  to the database and would like to do this as soon as the form and all it's controls have been loaded. I have a MDI from that  contains a split container which  contains a panel containing various controls, if I place the  SQL query to the database in the form load event  it effects the speed at which the form controls load. Although this time is very small and does not really cause an issue, I would like to remove it, and only call the SQL query when the form and all controls have loaded. I have tested many of the form events but fail to find one that will do t ...Show All

• Visual Basic MultiColumn Listbox(add item: Object Text, Object)

  How do I add a new Listbox item where item1, column1 holds a TreeNode object text; item1, column2 holds a TreeNode object. The ListBox would display item1, column1(TreeNode object text) but hide item1, column2(TreeNode object). I have a TreeNode search procedure that stores the .Find TreeNode results (TreeNode object only at this point) in a ListBox. I want to store both the Node Text (column1) and Node object (column2) as one item in the ListBox but want the user to only see the Node text (column1). Then I want to make TreeView1.SelectedNode = Me.ListBox1.SelectedItem... and the TreeNode object (column2) - the actual TreeNode object returned from the .Find function. Thanx in advance! Why do you need two columns then if you ma ...Show All

• Windows Forms Tooltip component to have TTS_CLOSE...

  Any way to pass TTS_CLOSE to the Tooltip component so that it will have a 'close window'... You can get some information and wonderful examples in the following link http://msdn.microsoft.com/library/default.asp url=/library/en-us/dv_vstechart/html/pinvoke.asp ...Show All

• SQL Server How to send a report on data change?

  I have this report that uses one table. At some random times during the night this table will be updated. Is there a way to trigger the email report whenever the table changes its data Not according to what he is saying. He wants to update his tables (on some external data store, not RS) then notify RS to run the subscription. This is exactly what the FireEvent will get him. ...Show All

• Windows Live Developer Forums Error

  I cant get windows live to work. I keep geting this error code:8004882c Anyone know what this error is Hey Friends... I'm really so afraid with some Windows/MSN Developers, what kind of Impact Analysis they do I've got the last windows security update and my messenger stoped to work! Incredible, isn't it The same error code has been reported to me... what the hell can I do I'm using MSN 7.5 version and I really don't update to Live version because I don't wanna be a dummy tester in this "beta" (yes... beta, yet!). I'm wainting for your reply... thanks. ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. GameFest information

  Hi I attended the XNA talks at GameFest. I was wondering... How much of the information provided about XNA can be talked about here thanks! Michael Klucher - MSFT wrote: P.S. For other people who did not attend please note we will be getting slides and audio of the presentations online as soon as we can. Waiting anxiously for this. The clips I saw and heard merely whetted my appetite. ...Show All