Mitchell Slep's Q&A profile

• SQL Server Need help with a simple query

  Hi Everyone: I am new to SQL, and I would like to request if someone could provide me with a query that could do a find and replace in a column in MSDE. I have an image path column in a table, the current image path is set to /images/xxxx.gif I would like to add another folder so the image  path looks like this --> /images/imagesA/xxxx.gif The problem is i have 4500 records to update, so I cannot do this manually, so my question is can someone provide me with a query that can do this find and replace, i guess in this situation you are finding /images and replacing it with /images/imagesA Please advise. Thanks. It wo ...Show All

• Visual Studio Team System Failover design for TFS deployment (was What data lives on the app tier)

  Anyone have a walkthrough of failover design with TFS if there exists any I'm in the midst of trying to design a distributed development system with TFS dual server layout in the backend and 2 different proxy servers and need more information. /Andreas Documentation for AT failover and DT clustering is not available yet, but should be included with the documentation update in the upcoming RC release. TFS supports high-availability at the data tier using SQL clustering. When thinking about the hardware for a high-availability deployment, the MSCS cluster is going to be the area that requires the most pla ...Show All

• SQL Server BI/SSIS Developer environment?

  Which sql components are needed to develop/execute packages within BIStudio considering that SSIS is centralized in one sql server Is Source Safe 2005 integration within BI has the ability to add/update packages to a SQL server location instead of a system file Thanks, Greg. I can only answer your first question. When you install Business Intelligence Development Studio from the Client Tools node in SQL Server setup, the components necessary to develop and test Integration Services packages are also installed. However you cannot run packages outside the IDE on a client computer configured in this manner. The best way to run a package f ...Show All

• Software Development for Windows Vista Reloading a persisted workflow instance

  Hello everyone, We are trying to develop a generic workflow host service that can run any workflows submitted to it. The service will use workflow persistence to save workflow instances to the disk whenever the instance is idle (WorkflowRuntime.UnloadOnIdle = true). Now we are facing one problem. We want the service application to be able to resume the workflows in the event of an unexpected service shutdown or even a proper shutdown. From the documentation it looks like that a persisted workflow file (using file persistence service from the samples) is all you need to reload any given workflow instance. Upon reload that instance will star ...Show All

• Windows Forms How can disable the context menu?

  I have created a menu ContextMenu1, I hope the pop menu don't display in some situations, how I can do thinks! private void ContextMenu1_Popup(object sender, System.EventArgs e) { if (condition==true) { // Don't pop the menu, how can do I } } In VS 2005 with ContextMenuStrips, handle the ContextMenuStrip.Opening event, which gives you a CancelEventArgs argument.  Set e.Cancel = true to cancel opening the ContextMenuStrip. ...Show All

• Visual C# how can i format 5 to May?

  or 1 to January You can use the DateTimeFormat property of the Culture. This is an array of strings. Since arrays start at index 0 in C#, you'll have to substract 1 from you month: int month = 5; MessageBox .Show(System.Threading. Thread .CurrentThread.CurrentCulture.DateTimeFormat.MonthNames[month - 1]); Please not that this will display the month name in the local of the current thread. If not locale is explicitly set, it will be the current locale set in the regional settings. If your local is set to Dutch, it will display 'Mei' instead of May. If you want to make sure you always have the English month name, you s ...Show All

• Windows Forms Strings Problem?

  Hi, VB.NET I have one combobox, one button and Datagrid. The combobox was loaded directly from Customers table. CompanyName. The following code no work, but error no report: Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load         SqlDataAdapter2.Fill(DataSet12.Customers)     End Sub     Private Sub button1_Click(ByVal send ...Show All

• Visual Basic Create Unique File name in ASP on Windows 2003 server

  Hello,      I am having a problem with an older .ASP application that was using the following code I wrote to create a unique file name : Set fso = CreateObject("Scripting.FileSystemObject") mTime = Mid(Now,Len(Now)-10 + 1,1) mTime = mTime & Mid(Now,Len(Now)-8 + 1,2) mTime = mTime & Mid(Now,Len(Now)-5 + 1,2)   Set f = fso.OpenTextFile("d:\inetpub\internal\public\webapplications\jetforms\" & mTime & ".dat",ForWriting, True) This works fine on a Windows 2000 server, but once I moved it to a new server running Windows 2003 it doesn't create the file. I can populate the variable mTime ...Show All

• Visual Basic want a ado datashape command

  I got four table structures as follows CREATE TABLE [dbo].[Sector] ( [SectorID] [int] NOT NULL , [SectorName] [varchar] (50) ) the data is as follows ---------------------- 10 Energy CREATE TABLE [dbo].[GroupMaster] ( [SectorID] [int] NOT NULL , [GroupID] [int] NOT NULL , [GroupName] [varchar] (50) ) the data is as follows ----------------------- 10 1010 Energy CREATE TABLE [dbo].[IndustryMaster] ( [GroupID] [int] NOT NULL , [IndustryID] [numeric](6, 0) NOT NULL , [IndustryName] [varchar] (50) ) the data is as follows ------------------------------------------- 1010 101010 Energy Equipment & Services 1010 ...Show All

• SQL Server accessing components and task from scripting task

  Hi, I have to researching of how to accesss package tasks and component using the SqlServer.Dts.Runtime class and so far, I havent found any solution. For example, if you package has a scriptiong task and a data flow task(<- which contains a data source component). Is it possible to use the scripting component to access the data source component in the data flow task and manipulate its properites like sqlcommand etc. Emmanuel An easier and more direct way to do this is to store the sqlcommand for the datasource in a package variable and set the variable value in the script task or even at the time of executing the package. ...Show All

• SQL Server SSIS Script Component

  Dear all, Such a pain, I know. Yesterday I did a couple of questions regarding transformation rows and very kindly I obtained answer (Thanks Jamie and Michael) But now I face another stupid issue and is how to map source with destination columns inside Script Component Task. On my Flat File Source I’ve got defined thirteen columms (from Column0 till Column13); that’s fine. And then, I’ve got a sql table as destination with another names, of course… Inputs and Outputs option from Script Component Editor leaf has been commited both (Input 0 and Output 0) but I wonder how the hell I’m refer to them here: Public O ...Show All

• Visual C++ Would like to have a button open a new window or program

  What i would like to have when im finished is a program that will have a main screen and that will open a another screen that will have several programs that will be all in one program instead of having to install all of them is this possible and how do i go about it James, No one will answer because all your questions are too general. These are steps you need to take before asking a question: 1. Try and solve it yourself 2. Look up MSDN help/documentation 3. Search Google 4. Search the forums Only then should your post a question on the forums. You also need to provide more information. ...Show All

• SQL Server Any solution for that?

  I've got a .dts which load data to several Sql2k servers by Copy SQL Server Objects Task. I'd like to add another task for a Sql25k but I can't because of it's requesting SMO. It seems that such task need DMO. I know that there are other ways for do such stuff in that DTS but I wonder if there is any trick or shortcut for to avoid this barrier. ...Show All

• Visual Studio Express Editions Detecting dropped serial connection

  Hi, Does anyone know whether there is a straightforward technique using the serialport component to detect a failed serial connection. It's not a dialed connection that I'm using, just a simple PC - device link without handshaking. JonT If you only has a 3-wire cable (TxD, RxD and Gnd) and want to detect a disconnection, you may do it the following way if you are using a standard RS-232 connection: Connect a 15 kohm resistor between RxD (Serial Data In) and DTR or RTS on the PC. Then set DTR or RTS to logical zero, which will apply approximately 12V on DTR or RT ...Show All

• SQL Server SQLExpress Installation Problems

  Please refer to this thread but it Falls into Both Thanks http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=224810&SiteID=1 Zack ...Show All