Troy Lundin's Q&A profile

• SQL Server Does anyone have sql2005 EE running on 64 bit Itanium server?

  I don't think mine is using all of the memory it could on the server. I've read that the Task Manager does not give you an accurate measure of the memory usage but 130 MB max does not seem right on a 12 GB server. I've set the minimum to 2 GB in SSMS. The account that is running sqlservice has Lock Pages in Memory privileges . I've turned on AWE in SSMS just to be safe. We are experiencing high CPU usage and my theory is that it is caused my unnecessary I/O due to not being able to cache. The serve has Windows 2003 sp1. The SQL2005 Buffer Manager AWE Lookup maps\sec, stolen maps\sec, unmap calls/sec, unmap pages/sec, write maps/sec are all 0. Any help would be appreciated. Below is the out from DBCC MEMORYSTATUS. This server also ha ...Show All

• SQL Server Full-Text Setup and Search

  Hi, I have a database developed using SQL Server Management Studio Express with Full-Text searching. I can go into the Object Explorer and right click on my database and choose Properties , select File and the 'Use-full-ext indexing' is checked. I'm not sure how I create an index for a table, can someone help I want to create an index for table 'tblLogNotes' and have the following columns: note_id = (PK, int, not null) note = (varchar(3000), not null) log_id = (FK, int, not null) operatorid = (int, not null) note_created = (datetime, not null) I know I did something but not sure what I did, but on one of my tables, when I right click on table and choose 'log_note', I can see that Full-text Specification = yes, (is full-te ...Show All

• Visual Studio Express Editions Why new an int?

  The book "C# in easy steps" says than when declcaring an integer we can write int y = 2; int x = new int(); What is the purpose or advantage of using the new statement with a simple integer or other simple types I'm not %100 sure about C#, but if it works the same as in C++/ C++/CLI: The diffrence is static (int y = 2;) verses dynamic (int x = new int();) allocation. Dynamic allocation is useful if you do not know for sure how much memory you will need at compile time. Any way if you are learning to program don't worry about it and just use the normal method: int y; //or int y = 2; ...Show All

• .NET Development Certificate error using HttpWebRequest with SSL connection

  Hi, I want to set up a SSL connection with client certificate using HttpWebRequest using Visual studio 2005 The client certificate always causes an error, althoug when I use my browser it works fine. This is the complete System.Net trace. It seems to send the client cert twice, the first time it is accepted, the second time it is rejected. Can anyone help me out with this trace thanks System.Net Verbose: 0 : [3320] WebRequest::Create( https://spb121/Sodexho/SoapProxy2/SoapProxy2.aspx ) System.Net Verbose: 0 : [3320] HttpWebRequest#53036123::HttpWebRequest( https://spb121/Sodexho/SoapProxy2/SoapProxy2.aspx#-1062137107 ) System.Net Verbose: 0 : [3320] Exiting HttpWebRequest#53036123::HttpWebRequest() System.Net Verbose: 0 ...Show All

• Visual Studio 2008 (Pre-release) Contract First, ComplexType naming standard

  What do you suppose is the standard for naming types defined in schemas I forgot where I saw this but someone said to postfix with Type Therefore PersonType, AddressType, and etc. Does this matter Suggestions Comments Thank you Michele, Another question, for versioning of contracts.  Should I use the: the version attribute (ex. 1.0) the schema id (ex.  Product1.0) the schema namespace (ex.  http://myorg.org/Product1.0 ) or a combination of them Thanks, Mike L. ...Show All

• Windows Forms Shortcut checking installation...

  I have a slight issue with the deployment of my app. There are two problems that I have come across which involve the same issue. I am using the AppUpdater component and I have built the initial 1.0.0.0 folder into my setup project. I have created a link to AppStart.exe. Everything was running smoothly. Then I came across two issues. Firstly, a client had a application crash due to buggy programming on my part. In order to get out of this, the client had to shutdown the machine. Upon rebooting, the application would no longer launch from the shortcut and required the original msi file. Going to the actual application folder and launching AppStart.exe was fine. Just the shortcuts were not working. Secondly, now the app is being tes ...Show All

• Visual Studio Express Editions VB Express (INKEY$) function.

  I have just finished writing my first VB Express program (Sub Search). I often found myself wanting to do an INKEY$ function as I used to do in Quick Basic. I want the program to pause, and wait for me to hit a keyboard key... then to analyze that keystroke, and branch-off to various points. I have seen references to such a capability (keydown & others) but have not been able to decode the directions to the point that I can apply it to my program. ss4steve wrote: I want the program to pause, and wait for me to hit a keyboard key... then to analyze that keystroke, and branch-off to various points. Renee shows you how to do something when a key is pressed in a textbox...to explain a little further... Quick B ...Show All

• Visual C# Sharing variables between classes

  Hi, I have a project where I have 3 separate classes, 2 of these classes use some methods and variables defined in the third class. To acheive this I'm currently making the variables and methods needed by the other classes 'public static'. However this is causing me problems as my program is storing information when at times I don't want it to and I can't find an appropriate way of resetting them. My question is is it possible to share these variables and methods with the other classes without making them static Thanks in advance. It sounds a bit like you're implementing the class MMC user interface. You've got a treeview on the left, a listview on the right. MapTreeView.cs would then contain the even ...Show All

• .NET Development SOAP deserialisation

  Hi, Do you know how you can deserialize the SOAP message below I receive this message from a webservice. I would be nice if I can use it in my proxy class. Thank you. < xml version="1.0" encoding="UTF-8" > <SOAP-ENV:Envelope xmlns:SOAP-ENV=" http://schemas.xmlsoap.org/soap/envelope/ " xmlns:ns1="urn:xs.wsdl" xmlns:ns2=" http://xml.apache.org/xml-soap " xmlns:xsd=" http://www.w3.org/2001/XMLSchema " xmlns:SOAP-ENC=" http://schemas.xmlsoap.org/soap/encoding/ " xmlns:xsi=" http://www.w3.org/2001/XMLSchema-instance " SOAP-ENV:encodingStyle=" http://schemas.xmlsoap.org/soap/encoding/ "> <SOAP-ENV:Body> <ns1:getDocume ...Show All

• Visual Studio Express Editions VBE .iso vs .img

  Hello! For a newbie that is going to be downloading & burning VBE... I'm pretty new to the .img/.iso formats of these files so what is the difference and which one is the preferred one to use Thanks in advance... Here you can read some more about ISO and IMG http://en.wikipedia.org/wiki/Optical_disc_image It's usually a choice from what your burning/virtual cd software supports. I have NERO and usually chooses the ISO image before IMG or other formats. I prefer ISO, for no particular reason other than it has worked all the times so no reason to try other formats. ...Show All

• SQL Server Web Sync (Anonymous Subs) Reinitialize ALL?

  Hi I have a web sync merge publication with multiple anonymous subscribers. Unfortunately two of the subscribers have experienced errors as follows. ############################################### The Merge Agent failed after detecting that retention-based metadata cleanup has deleted metadata at the Subscriber for changes not yet sent to the Publisher. You must reinitialize the subscription (without upload). (Source: MSSQL_REPL, Error number: MSSQL_REPL-2147199401) ############################################### Now they successfully sync'd within the retention period so I am baffled as to why the cleanup has occured. Unfortunately I can't seem to find a way to reinitialize just a single subscriber. It seems that the only reinitialize opt ...Show All

• Windows Live Developer Forums Programatically display PushPin's Details Balloon?

  I've got a pretty basic map that loads a public collection from local.live.com, adds the layer to the map, and also outputs the entries as a list (as text) where each item on the list is a link such that when it it clicked, the map is centered on that point/pushpin. I'm doing this with a LayerLoaded() call back when the layer is loaded which pases the collection of points. We loop through the points and output an A tag with an appropriate javascript attribute and then write all of this out to a DIV placeholder. I'm looking to add a few additional features: 1. I'd like the pushpins to be numbered, corresponding with the numbers on the list (which are just generated in the order they are written out). 2. More importantly, I'd lik ...Show All

• Visual C# C# size of objects question

  I'm not sure about the size of objects in c#. Lets say I have two classes: Dog, Cat Class Dog { int a; int b; int c; Cat cat; } Class Cat { int a; int b; int c; } What is the size of class Dog, to be specific, does the object cat adds to the size of Dog 4 bytes (pointer) or 12 bytes (3 variables of int) "Cat cat" is a referrence to a Cat so Dog is 16 bytes.  If you changed "class Cat" into "struct Cat"', then the size of Dog would be 24 bytes. ...Show All

• Visual Studio Express Editions SerialPort 101 for a beginner

  Hello, I have spent a lot of time trying to use the serial port command in the toolbox but i was unsucessful. I looked at the samples posted online but i always get errrors. Can anyone explains what are the steps needed to have a sucessful communication (read and write) from and to a serialport.If you can post the code it would be great...Please help Thank you **can you help me figure this out.I am just following what you said. From the beginning. I openned a form in Vb Express and then I dragged the serialPort icon from the toolbox to the form and i defined all it's properties like baud rate, the com port and all that. next i created a button icon on the form and them i double clicked it so that i would get into the form1.vb[desig ...Show All

• Visual C# My enumerator is not returning the count??

  Hi, I have created a class using the KeyedCollection: public class RobotPartKeyedCollection<T> : System.Collections.ObjectModel.KeyedCollection<string, T>, System.Collections.Generic.IEnumerable<T> where T : RobotPart { private RobotPart partToSearch; internal RobotPartKeyedCollection() : base(null, 0) { } public RobotPartKeyedCollection(RobotPart robotPartToSearch) : base(null, 0) { partToSearch = robotPartToSearch; } protected override string GetKeyForItem(T item) { return item.Name; } internal void ChangeKey(T item, string newKey) { base.ChangeItemKey(item, newKey); } public new T this[string name] { get { ...Show All