NRJ's Q&A profile

• SQL Server How do I find the total memroy consumed by a SQL2K5 instance

  My Box: I have an SQL2k5 Dev 64 bit running on a Win2K3 64 bit box with 12 GB of RAM with two dual cores intel xeon processors. My concern: Task manager never shows sqlserver.exe consuming more than 500 MB of memory even when running very big jobs.( for e.g. joins on mutliple tables of 10 Million plus rows with lots of calculations while also using some CLR UDFs) My question: Is the task manager best way to find the total memory consumption by a SQL2K5 instance is there any other way to find the total memory consumption by SQL2K5 Apprciate any answers or leads. Thanks Saptagiri Tangudu PNT Marketing Services Inc. You can obtain the values from sys.dm_os_performance_counters as well. Same value ...Show All

• SQL Server How do you use SQL parameters to UPDATE a column?

  Hi all, I have a problem here where I am trying to use SQL Parameters to update a column in the database, but the problem is that I need to concatenate the same column to the SQL parameter. The code I have is below, but it throws a Format Exception... UPDATE tbl_NSP_Inspection SET Description = Description + @InspectionDescription ...It is because I am trying to Append teh data in the description column to the SQL Parameter ( @InspectionDescription). How do I actually do this using SQL Parameters Thanks Hi I know this is in the wrong forum, but I am using SQL Mobile 2005 (Everywhere). I just posted a general SQL Parameters question here as I thought I would get a better answer as the same principles applies to both SQL Server and SQ ...Show All

• .NET Development SSL Termination and ASMX

  Hi I've run into the following problems when using asmx pages behind a load balancer with SSL termination: 1. The wsdl generated by the asmx page contains the url of the web server rather than the url of the load balancer. How do I override the url put in the generated wsdl 2. The asmx test pages post to the web server url rather than the load balancer url. How do I override the url that the test pages post to Thanks If anyone is interested, I resolved the problem by taking the following steps: - Copy the default wsdl help generater aspx file into my project - Change all urls in the copied file to be relative instead absolute - Update the web config in the project to use the copied wsdl h ...Show All

• Smart Device Development How to add a self register dll in a solution and cab file

  My project needs a dll to be registered in gac of device.[it is System.SR.dll resource dll] How Can Add a simple folder in my solution and then add this file in the project. ThenHow can I add this file in the cab file so that it will be self register Thanks for reply, I want to bundle the "System_SR_ENU_wm.cab" with my setup file made with vs2005 device cab project.so that it can automatically install to the device. Please let me know how will I do that or give any refrence Your quick reply is highly appeciable. Thanks ...Show All

• Software Development for Windows Vista New Screencast: Introduction to State Machine Workflows

  Folks, I finally decided to get around to doing a screencast. Aside from a few problems where my microphone turned me into a heavy-breathing stalker, I think it turned out quite well. It's 24 minutes long, so it may take a few minutes to download if you're not on a good broadband connection. Click here for the blog entry and the screencast . Enjoy! Few comments: 1) You don't need to make your EventService serializable. Simply call EventHandler with null as sender in your raise events. However, derived from ExternalDataEventArgs SomeMyEventArgs have to be marked as serializable. 2) There is nice Ctrl+[dot] combination in VS, to implement interfaces (when cursor in on interface reference in class declaration), to inser ...Show All

• SQL Server CE support from ASP.Net 2.0

  MS states that CE does not work with ASP.Net applications 'by default'. What is needed to change this default Bascially, my desktop app. is configured from a browser app. (ASP.Net 2.0) and I want to use CE as the datastore for the application. Thanks. I don't think this is such a good idea. SQLCe is not designed for this type of application and while it can be adapted for use with ASP.NET, I don't recommend it and (frankly) don't want to encourage you to do so. The information on how to use it on ASP.NET has been published... ...Show All

• Visual Studio can I disable the SourceControlProvider in VC 8.0?

  Hi, I transfered from VC 7.1 to 8.0 just now when I worked on VC7.1, I change the reg HKLM\SOFTWARE\SourceCodeControlProvider\ProviderRegKey to emtpy to avoid the the VC binding my local file to the version control software without changing any local project file to remove these information. but in VC8.0, I remove the key as before, also, I remove HKCU\Software\Microsoft\VisualStudio\8.0\CurrentSourceControlProvider but it seems VC80 can always find the version control software when i open the solution and open the version control software to ask me login and binding... I just really don't like VC do the checkout automaticly, and I wander is there a way to disable it easily. any suggestion will be apprieated and thank you very much in adv ...Show All

• Windows Forms Problems with ListChanged Event

  I dont know what I'm doing wrong I have a Strong Typed Collection that I'm using to databinding my controls. It implements CollectionBase, ITypedList, IBindingList The add code: object IBindingList.AddNew() { return this.AddNew(); } public MyPersistentObject AddNew() { MyPersistentObject obj = Activator.CreateInstance(typeof(MyPersistentObject)) as MyPersistentObject; int index = this.Add(obj); return this[index]; } public int Add(object value) { OnValidate(value); OnInsert(internalList.Count, value); int index = internalList.Add(value); try { OnInsertComplete(index, value); } catch (Exception ex) { internalList.RemoveAt(index); throw ex; } if (ListChanged != null) ListChanged(this, new ListChangedEventAr ...Show All

• Visual Basic Inherited Controls

  I frmB inherits a label and ComboBox Controls frmA is there any way that i can repostion those controls on frmB Hi You should be able to attach a reference to the controls in frmA from frmB using MyBase.Controls(ControlName) eg .. somewhere in frmB dim lbl as label = directcast(mybase.controls("Label1"), label) Give me a shout if that does not work Richard ...Show All

• SQL Server unable to connect to sql server from handheld device via usb activesync and sqlclient

  I have tried using the SqlClient class to connect to the database, but I haven't had much success. Here is my setup: Desktop/Workstation has Windows XP, ActiveSync, .NET Framework 2.0, and SQL Server 2005. The production Workstation will have 2000; so I do want to ensure SQL Server 2000 compatibility with my solution. Handheld device is an Intermec 751g with docking station, hooked to PC host using USB connector cable and ActiveSync, Windows CE 4.2, .NET Compact Framework 2.0 with SP1 and latest patch. Development tools consist of Visual Studio 2005 and C# .NET language. Note that when I attempt to ping my desktop from the handheld command prompt I get "transmit failed, error code 11010". Also, I am able to access ...Show All

• Visual Studio Team System Skip generation of ChangeSet list

  Is there a way to skip the generation of changeSet list I am trying to fold in a new Build box and the generation of changeset task take 10 minutes. Therefore it takes me forever to fix simple build box settings b/c I have wait for the build to finish up before I test again. Thanks a million in advance, BJHop Hmmmm... I tested it and overriding that target does skip the "Generating list of changesets..." step. The message is still printed in the build report, but it doesn't do anything. The other option is to use the command line to stop the build. The syntax is identical to delete (mentioned above) but you use the word Stop instead of Delete. If you stop the build and then delete the build each time you sh ...Show All

• Visual Studio SourceSafe 6 & Vstudio 2005.

  Hi, I have Professional Edition of VStudio 2005, I'm starting a project with others 4 or 5 coworkers, we have the license for Visual SourceSafe 6.0. We don't have information about how to configure and use SourceSafe and Vstudio 2005. Could you send me a link or something that can help us Thank you. Here is a link to a website that one of our Devs wrote to explain how to use VSS 6 with VS 2005. http://alinconstantin.dtdns.net/WebDocs/SCC/Default.htm - Barry ...Show All

• Windows Forms How to create a NotifyIcon with 2 ContextMenuStrips - LClick and RClick

  Hi, I want to use a NotifyIcon with two ContextMenuStrips - one that works on a left mouse click, the other on a right click. I've tried the following in a MouseClick() event: If (e.Button = Windows.Forms.MouseButtons.Left) Then NotifyIcon.ContextMenuStrip = MyLeftClickMenu ElseIf (e.Button = Windows.Forms.MouseButtons.Right) Then NotifyIcon.ContextMenuStrip = MyRightClickMenu End If But the behaviour is erratic - the menus don't show or show the wrong one. This should be simple (I know Nortons Anti-virus uses 2 ContextMenus). If you can help, I would appreciate it. I'm using VB.Net 2005 Beta2 on XPSp2 Thanks. Did anyone get the same problem with me when left-click ...Show All

• Windows Forms How do I duplicate the behavior of the [?] HelpButton feature in my own button

  I would like to display my own button instead of using the system's HelpButton to mimick the behavior of the HelpButton. The event that I would catch and handle when the system's HelpButton is clicked is Form::HelpButtonClicked event. I do not want to handle this event, I want to raise this event if it is the appropriate thing to do in order to mimck the system's HelpButton. Can anyone help put me in the right direction to mimick the system's button Thanks in advance, RhR OK, then more specifically, how can I raise the Form.HelpButtonClicked event I tried using OnHelpButtonClicked. When I tried to raise the event, nothing happened. What are my options so that I can mimick, with my own button ...Show All

• Visual Studio 2008 (Pre-release) CheckBox's Size

  Hi Is it possible to change the size of the inner square box inside a checkbox i mean the square where the checked mark(Tick) appears....if so then how Cheers Jithendrian In the controltemplate of the checkbox, find the Element (Name="Border" ) and change the height and width of the Border you can find the control template here http://windowssdk.msdn.microsoft.com/en-us/library/ms752319.aspx ...Show All