mrmckeb's Q&A profile

• SQL Server Conversion 2000->2005 problem

  Hi all, How can I convert a 2000 SQL database into a 2005 Thanks, JR One thing to note. The database you converted from SQL Server 2000 to SQL Server 2005 CAN NOT be converted back to SQL Server 2000 due to some metadata changes during the process - even if it was an attach/detach process ...Show All

• SQL Server File group as variable

  Hi Champs! How can i create a table on an filegroup that comes from a variable Using EXECUTE the following does not work: declare @var char set var = 'filegroup' Create table table] ... ... ON [@var] /Many thanks ...Show All

• Visual Studio Team System TFS SP1 install - After the install... we cannot connect to the server

  Hi, We have installed the SP1 of TFS here and after that it I'm unable to connection to TFS !! I'm unable to find a way to fix the problem... please help me :-P I have check in the "Event Viewer" and I got the following messages: Event Type: Error Event Source: Tfs Event Category: None Event ID: 3059 Date: 7/01/2007 Time: 8:18:17 User: N/A Computer: HRISDEV01 Description: TF53010: An unexpected condition has occurred in a Team Foundation component. The information contained here should be made available to your site administrative staff. Technical Information (for the administrative staff): Date (UTC): 7/01/2007 7:18:17 Machine: HRISDEV01 Application Domain: TFSServerScheduler.exe Assembly: Microsoft.TeamFoundation ...Show All

• Software Development for Windows Vista Is ASP.Net suitable for hosting long running workflows?

  Given an approval scenario where a user is assigned a task and given a number of days to complete it, how can I set a timeout on the workflow instance Jason, Thanks for pointing to my articles. I would like to inform you, the article WS-Transfer for Workflow will be soon replaced by the WS-ResourceTransfer for Workflow, based on the new specification WS-ResourceTransfer . This is an extension to the WS-Transfer to deal with fragment-based access to resources. Here is one example - demo how the Web Browser Ajax client can talk to the WS-RT Web Service. Thanks Roman ...Show All

• Windows Forms Strange behaviour when changing language

  Hello, I have visual studio 2005 I have a form with a datagridview on it. I change a property (for instance the AllowUsersToAddRows property from true to false). If I change the language of that form from default to another language and then back again, the property AllowUsersToAddRows has changed back to true again. Does anybody know of this problem or knows a workaround Greetings Robert Hello, I tried changing the properties in both the default and the localized version of the form. But again after changing back to the default form the properties are back to their original settings. The default language of my program is English so I also tried to change the properties in the English language but again a ...Show All

• .NET Development Create Comma Seperated Text File with C#

  Dear All, I am new to C#, so apologise if this question sounds a bit simple. I am required to create a console application, that will allow the user to enter stock information.  The application is to read in a stock file (maststck.txt), and update the file with an amendment file (amend.txt).  Both files need to be comma seperated files. The stock file contains the following info; Product code; 4 digits Quantity: 4 digits Buying Price; 4 digits Sale Price; 4 digits. The amendment file contains the following info; Product Code: 4 Digits Amendment Type: 1 Character ('I' for issue from stock, 'R' for a addition to stock, 'B' for a new buying price, 'S' for a new selling price, 'D' for a deletion of ...Show All

• Visual Studio Team System Process Template change

  I want to remove a few workitems I do not use in my process template. For example.  I have no reason to create a "risk" workitem.  I know that if you alter this xml.  And remove the entries for the workitemtype that you don't want created it will work fine for any new project created using this template.  (see xml below). However I don't want to create a new project, we only use one project.   Is there a way I can remove the ability to create certain workitem, ie "risk" in an existing project    It should no longer appear when you right click on workitems and choose "Add work item" from ProcessTemplate.xml <task id="WITs" name="WorkItemType definitions" plugin="Microsoft.Pro ...Show All

• Visual Basic storing excel.xls files in db - truncated. CSV files instead?

  My application read/writes binary file data from the filesystem to the data base and sometimes back again This is all in vb.net 2005/sql2005. It works fine except for excel file, .xls. They are the exception. All data is stored in a varBinary(max) column. Images, pdf's, word docs, whatever all work fine, but not excel. Even very small test spreadsheets of 5k fail. "binary data would be truncated" is the exception. Has anyone experienced problems with this type of file A bytes a byte, I thought I call the procs like this: (1) entry.Blob = ReadBinaryFile(tbLookup.Text) (2) If Not EntriesDB.AddEntry(entry) Then MessageBox.Show("The Entry was not added. ", "Data Base Error") 'entries = ...Show All

• Visual Studio Express Editions Application version

  Project properties, Publish tab shows Publish Version: Major 1, Minor 0, Build 0, Revision 32. But My.Application.Info.Version has .Major, .MajorRevision, .Minor, and .MinorRevision. Why the different names MsgBox("Application version: " & My.Application.Info.Version.ToString) shows "1.0.2427.27691". Is there a way to display the values from Publish tab (1.0.0.32) Thanks to Brendan, I deployed the app; it works fine - displays the Publish values. Thanks for your help. ...Show All

• Visual C++ XML in Unicode

  Hello, I am trying to create an xml file using CFile and Cstring to add the content. The file is successfully created but it wouldn't show the content. The error message is 'invalid character .....'. If i change from CString to CStringA, it works fine. So it's clear it is the unicode issue. I need to make create the file in Unicode. So what is the solution to this problem Thanks Wordpad and Visual Studio both have options in Save As dialog to save as Unicode. Note this question is NOT about the C++ language, making this thread off-topic. If you have questions on Visual Studio IDE, there is a forum for this. ...Show All

• .NET Development MS06-061

  last night, wedenesday, i, for the first time, noticed a microsoft vulnerability on my pccillen scan; referring me to the vulnerability addressed in the microsoft MS06-061 bulletin . i can't figure out how to solve this particular vulnerability. "the microsoft vulnerability" MS06-061; rated as "very risky," by my pccillen security software; continues to be identified by my security software; no matter what actions i take! i am dedicated to the following ongoing practices AND have taken the following steps, attempting to address this vulnerabilty, with no success: i am religious about updating and scanning my computer (I scan it daily, with "full system scans"; using not only my pccillen, but a ...Show All

• Smart Device Development Please help: How to find out executables path?

  Hello and thank you for reading! I am trying to find out the path an executable was started from. In former times a solution was to take the CWinApp member variable "m_pszHelpFilePath", which contained the complete path to the applications help file. So one could cut away the tail of that string, the name of the help file itself: the rest was the applications path: CString cPath(AfxGetApp()->m_pszHelpFilePath); int iPos = cPath.ReverseFind('\\'); cPath = cPath.Left(iPos+1); But in Visual Studio 8 the "m_pszHelpFilePath" member was commented out for CWinApp on mobile devices: #ifndef _WIN32_WCE_NO_HELP_SUPPORT // THIS LINE WAS ADDED // Default based on this module's path. LPCTSTR m_pszHelpFilePath; #endif // !_ ...Show All

• Visual Studio Team System Installing TFS on separate servers

  I'm not sure if this is even possible. I'm not finding any information on how to do this. We are thinking that we would like to point the TFS to an existing SQL Server and to an existing Sharepoint Server installation. Most everything that I've found refers to installing TFS all on one physical server. Once in a while, you see an item on a separate SQL Server, but it doesn't sound like it's not very straight forward. Is there a document somewhere that describes how to install TFS on one server and utilize existing installs of Sharepoint and SQL Server - Craig. In V1, you have to use the whitepaper we created: http://msdn2.microsoft.com/en-us/teamsystem/aa718901.aspx We're working on supporting this in a future version, as it ...Show All

• Visual Studio 2008 (Pre-release) Control Rendering Space For a Line

  Hi, I have such a piece of XAML <Page xmlns=" http://schemas.microsoft.com/winfx/2006/xaml/presentation " xmlns:x=" http://schemas.microsoft.com/winfx/2006/xaml " > <Canvas Width="500" Height="500" Background="BlanchedAlmond"> <Canvas Width="300" Height="300" Background="Blue"> <Line X1="150" X2="350" Y1="45" Y2="150" Stroke="White" Canvas.Left="0"/> </Canvas> </Canvas> </Page> The White Line is the child of Blue Canvas, is it possible that the part which is getting drawn in the Almond canvas, stays invisible, while the Blue Canvas shows t ...Show All

• .NET Development asp.NET SECURITY

  1) how the asp.net application would be deployed into DMZ network model 2) Will the web and application end support a clustered environment (ie. is it serialisable ) ASP.NET is not supported here. Please use the following forum for ASP.NET questions: http://forums.asp.net/ ...Show All