John123's Q&A profile

• SQL Server Set maxtransfersize for a DB Maintenance Job Log Dump

  My SQL 2000 installation has been running along very well for many months now with SP4 installed, but I've begun to have the "insufficient system memory to run this query" error outlined in KB904804 ( http://support.microsoft.com/default.aspx/kb/904804 ). I can add the maxtransfersize parameter and get it to work in QA, but I have all of my log dumps configured under Database Maintenance Plans. Is there any way I can force the maxtransfersize to be applied within a database maintenance plan Extract from other post To be more certain, you can run a Microsoft utility called VMstat.exe, which I believe you can obtain from the MS support, to monitor memory fragmentation in the SQL Server process. ...Show All

• Visual Studio Team System Emergency: Deleting Custom Work Item Type

  I played with custom workitem types and stuck in the middle. I created some workitem types that are irrelevant and they create errors everytime my team opens any workitem related interface or Team Explorer pane like "One form per Work Item"; we ignore the error and continue working; but it is annoying, undesired and some feature that VSTS must support as deleting a custom work item type if you are the TFS Administrator. I want to delete "the work item type" at all with no glue back. I deleted some unrecognized rows from SQL Database but still there they are. You are correct, we store the information in our database. Someone else might be able to help you with exact information or steps for deleting WIT - it could ...Show All

• Visual C# typeof permissions

  hello, I've been getting an error in my code, that I think occurs when I try to get the typeof my created object: System.Resources.ResourceManager resources = new System.Resources.ResourceManager( typeof (Control_object)); Are there security permissions needed for this to work properly, without getting a security error Thanks for any help. From what I can see in the stack trace, the error seems to be occuring on the next line, where you call MyClass myobj = resource.GetObject("MyName"); The exact syntax of how you wrote that line would be helpful. ...Show All

• Visual Basic ListView control Problem - missing blue rectangle around selected item

  Help please, I did simple form containing Tabcontrol and Listview on one Tabpage. During initialization I put some items and set selected property of one of them to true. When the form is shown no blue rectangle arround selected item Similar problem is when I switched between tab pages. I selected by clicking one item. The blue rectangle is ok. Then I switched to the second tabPage and then returned back to first one with selected item in Listview - the blue rectangle disappeared. How to solve this problem Could you help me please. What I'm doing wrong (I' tried to call refresh, focus on listview control no improvement in behavior). Thank you in advance. Vlastimil ...Show All

• Visual Studio Express Editions create folder on remote computer

  Is possible to create folder on remote computer in visual basic express edition ...Show All

• Windows Forms Select a form on clicking anywhere on form...

  Hi... In my MDI application...when i am opening many child forms & all the forms are visible on screen to select the form & to make it front i have to click on the title bar of that form(on header). So Can i select a form & make it front & active on clicking it anywhere on the form if more than one forms are active & visible.... Thanks & Regards, Vinay You should be able to click anywhere on a form in order to bring it to front and make it the active form so long as there isn't any explicit code in your app preventing that... or another application that it's forcing itself to stay on top. Is clicking anywhere on one of those forms not doing it for you ...Show All

• Visual C++ How to save and load a struct of values to and from a file?

  I seem to recall a way to save a structure into a binary (or dat) file, but i just cant look it up anywhere. It involved something like instantiating a struct of variables, filling them with values, then saving it via pointer into a file. One can retrieve that pointer, then cast it into the appropriate struct to access those values. I think i got this from a games programming tutorial, but that was a long way back. Now i need to utilize it for a time series application, but cant find it anywhere, please help.. #include "stdafx.h" #include <stdio.h> #include <assert.h> int _tmain(int argc, _TCHAR* argv[]) { // Sample structure struct { int member1; char member2; } test; test.m ...Show All

• SQL Server Problem to run SSIS package on a 64 bit

  Hello, I can't run package with the SQL server agent on a 64 bit server. I use Operating system (CmdExec) with the following command ("D:\Program Files\Microsoft SQL Server (x86)\90\DTS\Binn\DTExec.exe" /FILE "E:\Deployment\D_POS_v1.1.dtsx" /MAXCONCURRENT " -1 " /CHECKPOINTING OFF) to run my package. In the advanced options in Operating system (CmdExec) I specified the following path:C:\WINDOWS\SysWOW64\cmd.exe The error message is: Started: 2:02:57 PM Progress: 2006-11-29 14:02:59.62 Source: Mise a jour de D_POS Validating: 0% complete End Progress Progress: 2006-11-29 14:02:59.62 Source: Mise a jour de D_POS Validating: 5% complete End Progress Progress: 2006-11-29 14:02:59.62 Sourc ...Show All

• Visual C# Why is fixing runtime bugs expensive?

  I am a novice C# programmer. In the title “Learning C#,” the author states that it is much more expensive to fix a bug at runtime than at design time or compile time. I am wondering if it would indeed be as expensive as he says if the application goes through an SQA cycle before it is deployed. Whether you catch it at design or compile time, or rather at runtime, why would there be more or less cost involved Please shed some light on this. I think you're missing the point, TAG. Lets say there is a logical flaw in the design that would cause the resulting program to behave incorrectly in some cases.  Lets say that, in order to fix this error, it would require that we change a number 10 functi ...Show All

• SQL Server Could not find stored procedure 'msdb.dbo.xp_sqlagent_notify'

  I have started getting this new error after installing SQL 2005 service pack 1 whenever I start the SQL agent : Log SQL Agent (Current - 6/5/2006 12:28:00 AM) Message [298] SQLServer Error: 2812, Could not find stored procedure 'msdb.dbo.xp_sqlagent_notify'. [SQLSTATE 42000] (DisableAgentXPs) I don;t see any problems because of it but would like to fix it because it is an error and might be affecting something I don't know about. Thank you. please post this question to the " SQL Server Tools General " forum, as someone should be able to help you there.   Thanks, Peter ...Show All

• SQL Server MS SQL 2005 performance issues

  After migrating to 2005, I started noticing some performance problems with my queries. Here is one of them. The query takes some 40 seconds to execute for the first time with intense disk operation. Next time I run it the result comes back in less than a second. however, if I make a minor change to one of the parameter, it takes ~25 seconds with 100% CPU utilization and 0% of disk utilization. So, I'm assuming that all data has been cached, but I can't imagine why it takes so long to retrieve data from the memory BTW execution plans look completely identical for those queries. Here is the query example: select quotes.quote_id from indicators indicators_1, quotes, quotes quotes_1, quotes quotes_2, ranges ranges_1 where not (1. * q ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Little question

  I have one question : Can I create 3D fighting game like Tekken 5 with XNA Game Studio Express Thx Anything is possible with XNA, as you have to do the coding yourself, remember that XNA is not an engine all it is is a set of tools to get you started, you still need to do a lot of the work yourself. ...Show All

• SQL Server SQLCMD error

  hi i am using the SQL Server 2005(Express Ed). I am at the client end, i mean i have installed the client tools on the workstation & server is over the network(local). when i try to execute the command at dos prompt C:\>SQLCMD it throws Missing Data Source Name Usage: SQLCMD -d dsn -u user -p password -i filename Why but if i execute the same on the server its working fine. now i wan to execute a set of sql statment from the client (at dos prompt) how can I do this if i do like this C:\>sqlcmd -d dm2006 -u sa -p sysadm -i ss.txt (that is with dsn,username,password, filename) it ok but when i use the SQL Query as C:\>sqlcmd -d dm2006 -u sa -p sysadm -q "SELECT * FROM MISC ...Show All

• Visual Studio Tools for Office VSTO2005 Excel- Insert Comment into cell

  Hi, I am using VSTO 2005, Excel workbook project. I would like to insert a comment into a cell on a worksheet- does anyone know how to do this programatically (i.e. same as right-clicking on a cell, and selecting "Insert comment"). Thanks. Correctly, questions concerning the object model should be directed to the appropriate newsgroup, as listed in the "Please Read First" message at the top of this forum. http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=174275&SiteID=1 Only questions concerning the VSTO technology should be asked in this forum. In any case, you should mention the programming language you're using if you want a code sample in that language. Th ...Show All

• Visual Studio Team System BuildStatusChangeEvent doesn't work.

  After many tries with BisSubscribe I managed to get BuildCompletionEvent working. BuildStatusChangeEvent still doesn't wotk for me. There is no information about it in tbl_notifications table in TfsIntegration database so I assume it isn't fired. BTW, what is the connection between BuildCompletionEvent name and that from tbl_event_type (which includes spaces) And one more thing. Why there are connections between connections between tbl_notification rows describing build completion and tbl_client_event containing XML description of check-in Marcin Your post is intresting have you thought about more filtering such as adding only builds that are marked with Build Quality tags Anyway, the pr ...Show All