RtMahi's Q&A profile

• SQL Server Vista 5270& user instance mode

  Is there any means to enable "user instance" mode on Vista for sql express Thanks. ...Show All

• Visual Studio Team System TFSDeleteProject.exe is friggen useless....

  After trying to create a project unsucessfully (see this: http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=128046&SiteID=1 ), I decided to clean a little house and try again. The utility returns: C:\Program Files\Microsoft Visual Studio 8\Common7\IDE\PrivateAssemblies>TFSDele teProject.exe /force /TeamFoundationServer:vsts-host Test001 Warning: Deleting a team project cannot be undone.  Are you sure you want to del ete the team project (Y/N) y The item '/Test001' cannot be found. ---> The item '/Test001' cannot be found. But when I go back into VS2005 and make an effort to create another project named Test001 it w ...Show All

• SQL Server Insert into more than one table

  I have this select command SELECT intUserId FROM tblUser I want to insert every intUserId into tblUserBla,tblUserBla2 I know that i can do this INSERT INTO tblUserBla (intUserId) SELECT intUserId FROM TblUser But, how can i perform a insert into tow tables, in one statement this will be the body of the after insert trigger on the first table insert into [2nd table] select intUserId from inserted which will insert only the newly inserted IDs ...Show All

• SQL Server Recursively Calling A Stored Procedure Problem

  I am writing a stored procedure that fetches the topmost value from a table, based on an ID parameter. If this value is a number the stored procedure should simply return it. If the value is an operator the stored proc needs to recursively call itself until it has two operands to use the operator on. Fairly simple logic. However I am running aground trying to get this into T-SQL. Basically I have this call in the sp: (CREATE PROC EvalFormula @blablabla) SELECT @pop=(SELECT val FROM formula WHERE f_id=@f_id AND position=@pos) SELECT @pos=@pos-1 IF @pop LIKE '%+%' BEGIN exec @rc=CalcStack @f_id,@pos,@output select @lhs=@output exec @rc=CalcSt ...Show All

• SQL Server Changing Column size/type with Derived Column

  I have a number of date columns that are parsed as DT_WSTR (6) and I have written a Derived Column converting them into DT_DATE via this (found on the forums) type expression: (DT_DATE)(SUBSTRING(Date,6,2) + "-" + SUBSTRING(Date,8,2) + "-" + SUBSTRING(Date,1,5)) But I really want to replace the current column, not create a new one. If I use "replace" the data is forced to be a DT_WSTR (6), and I get a truncation error at run-time. Simeon A column is identified by it's lineage Id. Deleteing a column and adding it back, even with the same name and same data type properties will cause it to change lin ...Show All

• SQL Server Login failed for user...

  Hi! I have msde (that installed with an application) on the old computer. Now I am setting up a new computer and I want to use SQL Express with this application so that I could easier manage databases. I have installed SQL Express 2005, attached databases from the old computer, created an ODBC system data source and created user "AD" to use with this application. Now when I try to log on with this program I get the following error message: Login failed for user 'AD'. In trace says it is "Error: 18456, Severity: 14, State: 8." I have tried changing many settings, but it still doesn't work. So I would really app ...Show All

• Windows Forms Transparent Panel Headaches

  Hi, I'm having a really frustrating problem when using transparency in a Panel, if anyone has any suggestions I would really apreciate it. My problem is the following: I have a Form with a Panel contained on said Form. The Panel has the BackColor property set to "Transparent". I would like the background of the Form to be visible through the panel (I assume this is what setting the BackColor property to transparent means ). When my form first loads all is well - the underlying Form is visible through the transparent Panel. However, if I minimize the Form and then Restore it - now my transparent Panel displays what is underneath the ...Show All

• Visual Basic How to access SMTP IP of a message using CDO (1.x)

  Hello I would like to know How to access SMTP IP address  of a message using CDO (1.x). I can access SMTP Header of a message using CDO but i want only IP address. Chaitanya ...Show All

• Software Development for Windows Vista Workflow Designer Rules Support

  Hi, I'm in the process of trying to setup a demonstration application which shows an example of workflow and rules management. I need to basically setup a workflow, set some properties, then run the workflow from the designer. Part of this demo include the use of an IfElse activity and a Policy activity which link with the rules engine portions. I've trundled through the examples and the current samples get things about 75% of the way there, and I've probably gotten another 5-10% there by looking at the threads here, but I'm still stuck. Here is what's happening: 1. Create a new workflow 2. Drop an IfElseActivity on the design surface, thro ...Show All

• Visual Studio Team System Login problems?

  What am I doing wrong I have 2 clients (Domain users) with identical working places. Visual Studio 2005. Team Foundation Server Beta 3 Refresh. One client workspace is connecting to TFS with TFSService account and the other is using my Domain account. Both connect to TFS via Visual Studio IDE and work: They see their tasks, source code, project portal... However MS Project 2003 SP2 works with TFSService but doesn't work in my machine: --------------------------- Microsoft Office Project --------------------------- TF80071: Team Foundation encountered an error while accessing the work item database.  Please contact the Team F ...Show All

• Visual Basic MDI help

  Hey everyone, I'm new to using mdi forms.  Basically, the problem is that when I maximize my child form an extra line is added to the top of my main form with control box/max/min buttons for my child form.  I don't want that line on there at all!  I've tried everything, disabled everything.  Any ideas on how to shut this off would be great! Here is a screen shot of what I'm talking about. http://www.accs.net/users/anonymous/mdihelp1.jpg Hi, I forgot to mention that I handled the SizeChanged event of my child form. Here's the code:    if (this.WindowState == FormWindowState.Maximized) {    ...Show All

• Visual Studio Team System Upgrading from limited version

  Can anyone tell me if it is possible to upgrade the RC version of TFS (one which is limited to 5 users) to full version since we now have bought the full version. If so how I have uninstalled and installed the TFS Server, but trying to add users using TFS Team Edition on a different desktop, but it keep telling me: Team Foundation Error TF50626: Maximum users (5) in licence group. Unable to add John Smith. Any ideas Thanks. UPDATE: I have found out that that file 'Microsoft.Teamfoundation.dll' is version 8.0.50727.147 . So it is the RTM version, yet it won't allow me to add any more us ...Show All

• Windows Forms About Layout Panel in Whidbey - An Overview

  There are three container controls are used in Whidbey environment, which allows you to arrange controls on your form using  different layouts.  These three new container controls are  1. FLowLayoutPanel,  2) TableLayoutPanel and 3) SplitContainer 1. FlowLayoutPanel FlowLayOutPanel control allows you to add child controls, which dynamically repositioned to flow in a particular direction  bas ...Show All

• Visual Basic Text from a notepad

  when i click button1 i want it to read the text from a certain notepad and then put all the text from the notepad into a textbox, how thanks If you are operating that notepad, you can always do a control-A, Control-C to copy the contents to the clipboard - from there it is very easy to programmatically move code from the clipboard to your textbox. If My.Computer.Clipboard.GetText().length <> 0 then    Textbox1.text = My.Computer.Clipboard.GetText() else    beep    Textbox1.text = "The clipboard is empty" endif I hope this helps ...Show All

• Visual C++ building WinXP x64 application

  Hi want to compile/build a piece of code that was written in Visual Studio 6 for use under WinXP x64. I would like to use my 32bit machine, compile and build and than put the exe on the 64bit system and test it there. How can I do it, are there tutorials somewhere Any help is appreciated please help Thanks Maik Yes, Visual C++ 2005 runs on a 32 bit system, and builds apps for 64 bit. -Kev ...Show All