TSZ's Q&A profile

• SQL Server lsass.exe high cpu, Error 18456

  We just migrated to a new sql server with SQL Server 2005 installed (we moved from 2000). We are experiencing two issues that we cannot resolve: 1. The site and database clients that use this SQL Server run very slow now. We have noticed that the lsass.exe process consistantly uses 25% CPU, +/- 10%. When we stop SQL server the lsass.exe process goes down to 0. What can be causing this The website uses a SQL user account, not a windows user account. 2. We have an error in the event log that might be related to the issue above. It appears every few minutes: Event Type: Failure Audit Event Source: MSSQLSERVER Event Category: (4) Event ID: 18456 Date: 10/25/2006 Time: 11:54:42 AM User: NT AUTHORITY\SYSTEM Computer: MSDB Description ...Show All

• Visual Basic How Can I Determine What Link The Mouse Just Clicked?

  I'm trying to create a download manager, however i don't know how to tell if the mouse just clicked a link that doesn't tell the webbrowser to go someplace. I need to know this so that i can tell the program that when this happens, to start asking to download. Could someone please help me If someone is willing to, do you need some more information well, i was doing it in the WebBrowser control. The structure was that it loaded the web page adn then when the mouse would click the link it would download, but i didn't know when the mouse would click the link i'll try it your way. thanks! ...Show All

• Software Development for Windows Vista Compiling markup with embedded code does not execute the code

  I am playing with creating workflows using xaml only. In it, I am embedding code. The markup compiles without error and runs, however, the code does not execute. First, is this possible. If it is, can anybody explain why it is not working < xml version="1.0" encoding="utf-8" > <SequentialWorkflowActivity x:Name="CustomWorkflow" xmlns:x=" http://schemas.microsoft.com/winfx/2006/xaml " xmlns=" http://schemas.microsoft.com/winfx/2006/xaml/workflow " x:Class="WorkflowDesignerControl.CustomWorkflow"> <DelayActivity TimeoutDuration="00:00:10" x:Name="delayActivity1" /> <CodeActivity x:Name="codeActivity1" ExecuteCode="codeA ...Show All

• Windows Forms "toolbar" applications

  I am interested in creating a "toolbar" interface for a windows application. By this I mean an interface that is loaded onto the taskbar from the toolbars context menu, as is windows media player in mini mode, the language bar, virtual desktop powertoy, etc. I'm not ever sure what the proper terminology for this is and have been unsuccessfully so far in my efforts to google it. Is there a forum here that deals with this sort of thing If not, can anybody recommend any resources that might help Hi, I think the only way this can be acheived without paying for a tool which does this for you is to do this: Make a new form and set the topmost property to true. Then position it over where you wan ...Show All

• SQL Server Replication between SQL Server 2000 and SQL Server 2005

  Do you know if it is possible to synchronize a database in SQL Server 2000 SP3a (Publisher) and a database in SQL Server 2005 (Subscriber) Has anyone tried it What are the most common problems you faced Are there many differences from the Replication process from SQL Server 2000 (publisher) to SQL Server 2000 (subscriber) Thanks Very Much Not sure if this is the issue you hit: Make sure to use SQL 2005 Management studio to create publication and add subscription for SQL 2000 publisher, you can not connect to SQL 2005 from SQL 2000 Enterprise manager thus will not be able to add SQL 2005 subscription from SQL 2000 enterprise manager. Or you can TSQL script to setup replication programmatically. Thanks, Zhiqia ...Show All

• Visual Basic "ENTER" key pressed in textbox?

  I am just learning Visual Basic 2005 and in the process of making my first super simple game but I am stuck with this problem, I have one textbox and one label. When the user hits the "ENTER" key I want it to check if the text in textbox matches the text in the label. As of now I have a button that does it but I want to get rid of it. Thanks for help with this simple issue:) Thanks for quick response and simple solution but I get an error with that code. 'KeyCode' is not a member of 'System.EventArgs' Thanks Again ...Show All

• Windows Forms in a form i need to all the featurs of ms outlook

  in my vb.net windows application on a windows form i need to keep all the featurs of the ms outlook can any one help me how to solve this problem http://www.emailarchitect.net/easendmail/sdk/html/o_smtpserver.htm in order to use the above link code what should i add in my project references and thanks for sending the link but i am unable to use the code can u plz help me ...Show All

• Software Development for Windows Vista Spurious 'device in use' error from waveInOpen and IAudioClient::Initialize

  I have discovered what appears to be a Windows Vista bug. If I change the default recording device in the Sound applet (mmsys.cpl) while an application is recording, all future calls to waveInOpen (WAVE_MAPPER, ...) or IAudioClient::Initialize for the default audio endpoint fail with error code MMSYSERR_ALLOCATED or AUDCLNT_E_DEVICE_IN_USE respectively. To demonstrate the problem, proceed as follows: Start SoundRecorder Start recording While recording, go to the Sound applet and change the default recording device Stop recording (and save the file) Try to start recording again SoundRecorder then reports 'An audio device cannot be found' Restarting SoundRecorder does not help The situation can be resolved by ...Show All

• SQL Server Looking for suggestion of how to manage a DB file when it getting too big.

  Hi all, At our facility, we have a > 350 gigs database and the DB is breaking into 2 files. One file is our Image table with the size of 300 gigs. The other file contains all of the other tables. The image file is getting bigger and bigger everyday, I am worry that eventually when a data file getting too big it could lead into problem. - DB fragmentatio, hard to manage etc My question is anyone has run into this problem, and how do you solve it I am open for any suggestion. BTW: I am using SQL 2000. Thanks in advance. Hmm, I obviously didn't think of this possibility. Data could be written across multiple files! it makes perfect sense now. damm, how could I not see this :-(- sorry for misunderstood your comment and ...Show All

• Visual Studio Express Editions disable on form load

  Hi there i have a really strange question i have a simple form with a combobox from the combobox i have a liust of items which trigger certain events my problem comes when i load the form as a draft job sheet from an xml file it enters text into the combobox and then fires the code that is ralated to selected index change but when it loads as a draft i dont want this to happen is there any ideas would be appreaciated thank tim hi thanks for the reply that was how thinking of overcomming the problem but i thaught maybe there was a better method thanks ...Show All

• Visual Basic Error when trying to run the debugger

  Hi there, I've just started to write my first VB application. I have designed the UI but not done any coding. When I have pressed 'start' on the debug toolbar to view my new UI I get the following error message: ' Error while trying to run project: Could not load file or assembly ‘”Oli’s RSS Reader”’ or one of its dependencies. The given assembly name or codebase was invalid. (Exception from HRESULT: 0x80131047)' I can't think why this is and i'm completely stuck as if I can't debug then I can't build! Any help is appreciated. Thanks Oli Hi DMan1, No 3rd party controls, no references apart from default. I thought it might be some kind of naming rule i've broken Still stuck i'm afraid. I can send you ...Show All

• SQL Server Joins

  Hi, What types of Joins MS SQL has and pls provide definition of each Joins. and with realtime example pls!! which you used in development Thanks Seshu This is a pretty good resource, with examples: Using Joins http://msdn2.microsoft.com/en-us/library/ms191472.aspx It is broken down into several articles covering how to join using inner, outer, cross joins, etc. ...Show All

• .NET Development What is the connection string to write for importing mixed data from excel sheet to data grid

  Please help me about this issue, so that I ll be glad to u.I used IMEX=1.but it is working for some limited rows I can't reproduce this problem. When I use IMEX in the connection string the mixed mode columns display just fine. Could you post your code ...Show All

• SQL Server Generate Detail Line even when no rows returned

  Is there a way to generate a detail line on a report even if the SQL Query returns no rows ...Show All

• Visual Basic what the transactional component do ?

  hi when i add new item i see transactional component what this component can do thanks in advance. I think you may find these are templates for things like COM+ Transactions, given that the template is not included in the Express versions its probably classed as an advanced feature. Looking at the namespace that it uses system.enterpriseservices http://msdn.microsoft.com/library/default.asp url=/library/en-us/cpref/html/frlrfSystemEnterpriseServices.asp COM+ Transactions http://msdn.microsoft.com/library/default.asp url=/library/en-us/cossdk/html/40eccce1-a362-4adc-8060-f6923b9162c9.asp ...Show All