Bob Rich's Q&A profile

• SQL Server Mirror database-How do I remove it from being the mirror

  I was trying to test mirroring and now would like to delete the mirror database but it says I need to remove database mirroring first. I deleted the endpoint and cannot figure out how to remove the mirroring. Can someone please help. Hi Pamela, Deleting the endpoint does not remove mirroring, only disconnects it. You can remove mirroring by executing the T-SQL statement below. Note, however that since you removed the endpoint, you may need to execute the statement on both partners in order to remove the two copies of DB: ALTER DATABASE <your_db_name> SET PARTNER OFF. Thanks, Kaloian. ...Show All

• SQL Server Custom Task: How to access/modify the Expression Collection of a package

  Hi, I created a Custom Task which it has a Property called ConfigFilePath. I'm overriding the Validate() method from Task. I want to throw an error if my property ConfigFilePath is empty and if the expression for this property is empty. So far, I can check if the property is empty but I don't see how I can access the Expressions Collection of my Custom Task. Any thoughts I'd appreciate your help. Hi Michael, Let me see if I understood you. You're saying that I cannot have access to the Expression collection of a task All I want to do is for example, if you have a Script Task and there is a syntax error in the Script Task, after you close the Visual Studio GUI and return to the BI GUI you see that the Script Task has a red cross. This ...Show All

• .NET Development GetResponse method from System.Net.WebRequest

  Hi I've written this code for retrieving some web pages using the WebRequest and WebResponse methods: private void webDownload() { foreach (WebPage w in webList) { // Initialize the WebRequest. WebRequest myRequest = WebRequest.Create(w.Url); try { //get the response WebResponse myResponse = myRequest.GetResponse(); //the code for the decodeData method is taken from [1] String htmlContent = decodeData(myResponse); myResponse.Close(); //here I'll do some tiny operations with the html.. // .... } catch (WebException e) { if (e.Message.Contains("(4 ...Show All

• Software Development for Windows Vista Windows Vista SDK July CTP and Extension for VS.NET 2005

  I succeed to download and install Windows Vista SDK July CTP. But now i am facing a problem. Before going to problem i want to explain you how did i install it. .NET Framework 2.0 SDK .NET Framework 3.0 RunTime Windows Vista SDK July CTP Visual Studio .NET 2005 Professional But the problem is that i don't get any project templete for Windows Vista Development. You know that Orcas for July CTP is not released yet and i am not able to install that also. How should i start development for Windows Vista SDK July CTP using Visual Studio .NET 2005 ! I don't see any option for that Please Help me in this regard, Thanks & Regards, I installed the orcas for june CTP and it gives me various WinFX projects if I choose to create new p ...Show All

• Smart Device Development Pause Aplication

  I want to pause my application in specific precedure for couple of seconds but I dont want to use System.Threading.Thread.Sleep coz I want all buttons to work during pause. I was thinking about using Timer that counts down but have some problems with implementation i posted here: http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=711772&SiteID=1&mode=1 I also thought I could use it in a separate thread but also have problems to do so coz the method is run via delegate. Sorry if someone will feels this thread is spam but I wanted to poste something more general and I open for sugestions how to do it. I stuck with this porblem for 2 days now and realy have to move one the program. And maybe it sounds lame but plz help. ...Show All

• SQL Server Horizontal table

  I have seen the blog article about creating  horizontal tables but it says that you need to have a static number of rows. Is there a way to do this if you have dynamic rows   I need for information to flow down the page and then start at top of the next column and then flow down again. I need 3 columns. Unfortunately, there can be very little or a lot of information in each section.  I need to do this: Contract 1                          Contract 4                         ...Show All

• Visual Basic how to work with dll's

  Hi there, I'd like to ask how i can create a custom DLL with bitmaps in it and after then how can i get those bitmaps in my application and i'd like to do the same with strings. I'm using vb.net 2005. thnx for the replies. Creating a New "Class Library Project" will compile to a dll. You can store your strings in a collection or as a resource....you can store the bitmaps in a resource file or in an imagelist....You can also use your local project resource files to do this.... ...Show All

• Visual C++ How do I run another application from an application using a button?

  How do I run another application from an application using a button Is there a function in Visual C++ to do it Note that your question is actually two questions. How to do something when a button is clicked How to run another application All of that is outside the scope of this forum. See The scope of this forum . ...Show All

• .NET Development Please help me! Anybody can tech me how to write a [WebMethod] that can search Database(ServerSide) and return infomation!

  Hi all, thanks for come in!! My problem is: I write a web sercive which have two method, GetFreinds and GetFriend. GetFreinds Method can return all friends infromation from database when invoke this method, I use DataSet to do this and it works!     [WebMethod]     public DataSet GetAllFriends()     {         // Step 1. Create the connection string and command string                string connStr = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + this.Server.MapPath("Friends.mdb");         string comStr = "Select * from Friends";  &nb ...Show All

• .NET Development Windows Update and the .NET FW 3.0

  Hi All, Does anyone know if and when the .NET FW 3.0 will be pushed out to Win XP users via windows update I seem to recall that's what was done when .NET FW 2.0 was released but I haven't seen the FW 3.0 available via windows update yet. Anybody know whats up with that Thanks in advance, Andy Hi, I meant, will it ever automatically be pushed out via the windows updates Kind of like security patches and so forth--those are automatically pushed out to the end-users if they've set their automatic updates to lookup and/or automatically download and/or install updates. I'm just curious. -Andy ...Show All

• Visual Basic checking radio buttons in group box

  how do i check what is checked in a group box control containing radio buttons i tried something like for each control as radioButton in groupBox ' if control is checked if control.checked then ' to see which is checked select case control.name case ... ... end select case end if loop but it didn't really work, how should i do it Your 'end if' and 'next' words are in the wrong place and 'control2' is needed in some spots where it says 'control' Public Class Form1 Private Sub Button1_Click( ByVal sender As System.Object, _ ByVal e As System.EventArgs) Handles Button1.Click Dim fromVal As String = "" Dim factor As ...Show All

• .NET Development Save loaded assemblies in AppDomain to file

  Hi, I was wondering if the following is somehow possible: I'd like to get certain assemblies in an AppDomain and write them to file, so they can later on be examined with reflector or similar Thanks, Tom Hi Tom, I am not sure if I did understand you correctly. When an assembly is loaded it is normally loaded from disk except if it is generated at runtime for e.g. deserializing types of a xml file. If you want to copy certain assemblies to C:\Temp you can use the following code: using System.Reflection; using System.IO; foreach (Assembly *** in AppDomain.CurrentDomain.GetAssemblies()) { File.Copy(***.Location,Path.Combine("C:\\Temp",Path.GetFileName(***.Location))); } Y ...Show All

• Visual C++ How to Create a new GUID

  Hi All, I am developing in unmanaged C++, ATL, Win32. The .Net Framework has a function to get a new GUID. How do I create a new GUID without using .Net function call Thanks   David N. wrote:   How do I create a new GUID without using .Net function call http://msdn2.microsoft.com/en-us/library/ms241442.aspx ...Show All

• SQL Server SQL 2005 Express - sqlserv.exe memory usage always increasing.

  Hi, I'm hoping that some might have an answer for me after much net searching. I have a server (200GB disk space, Dual 3.8 GHZ processors, 4GB memory) that hosts 6, very small, SharePoint sites (WSS 2.0) and SQL 2005 express handling 1 config DB and 7 content DB's. The biggest DB at the moment is only 300 MB and the sites are not actively being used yet, they are only open to a select number of users (+ - 25 in total) who are using them as reference "areas" at the moment. Each site is running in it's own application pool as well. I find that the sqlserv.exe process increases in memory usage and does not seem to decrease. It gets to the point of 960 MB usage and then databases cannot be used (SQL 2005 Express max memory ...Show All

• Smart Device Development Pocket PC applications

  Hi all l recently purchased myself a pocket PC running Mobile Window 5.0 . l have Visual Studio Pro 2005 and downloaded Pocket PC SDK (174 MB) l am familiar with Visual Basic and would like to make a couple of simple applications that can run in my pocketPC . l am looking for articles and/or tutorials and/or any help which will describe STEP by STEP how one can transfer an application made in Visual Basic with VSPro 2005 to the Pocket PC and see it running . Thanks in advance geobas wrote: l have made an application and went as far as seen it in the emulator and it's functioning there . So where do l go from there . What are the steps to pass it to the pocket PC ...Show All