haiaw's Q&A profile

• SQL Server How to truncate the log file

  How do I truncate the log file using TSQL   My client's log file is 44 gig and there isn't enough HD space.  Thanks I have found that the following will work in the "out of disk space" scenario: BACKUP LOG database_name WITH TRUNCATE_ONLY Then, after you run that command, shrink the database using: DBCC SHRINKDATABASE ( database_name ) Hope that helps. Darren ...Show All

• SQL Server User return value of a SP in another SP (SQL Server 2000)

  Hi group, I need the result of a SP in another SP. The SP I need to have the result of does not have an output param. It just returns a result. I tried the following code: SELECT @WeightedAverage = EXEC uspCalcWeightedAverage @StartDate, @EndDate, @InMarket, @InProductType, @InWeekDay I get the following error: Server: Msg 156, Level 15, State 1, Line 26 Incorrect syntax near the keyword 'EXEC'. Is it possible to fill a variable with the result ...Show All

• SQL Server SQL Express Minimum Requirements Warning on Windows 2000 Professional???

  The computers here at work run Windows 2000 5.00.2195 SP4. Everything checks out with the minimum requirements at http://msdn.microsoft.com/vstudio/express/support/sqlreadme/#_3462_setup_issues_238p However, one of the "Reports" from the installation says the machine does not meet the minimum requirements, but provides no details. It installs and I have Admin rights on this machine, but I can't even connect to the Northwind database ...Show All

• Visual Studio Express Editions Backgroundworker problem

  Hi, I'm new to c# language. I'm trying to make a simple app that reads an xml file and display it in a datagridview. I want to put the reading of the xml file proceses in a seperate thread. I build the simple app without the backgroundworker and it works like I expected. But when I use the backgroundworker component the well known error accurs. Cross thread issue. I thought I used the backgroundworker component in the good way. Here ...Show All

• Visual C# Settings Dialog Help Needed!!

  Hello! I have a toolstrip. I also have an added Windows Form and that is the Settings Dialog. How do I code this: I would like the toolstrip's background image to change to silver.png if the user selects the first checkbox. And I would like it to change to black.png if the user selects the second checkbox. Please help! I added those two pngs to the resource file. I know how to change the background image programitically but how can I make it a s ...Show All

• Visual Studio SourceSafe doesn't acknowledge database

  I have used source safe before but now find myself in a position to be the administrator of it with no one else in the company with any knowledge of it.  The problem I am having is that when I have to work on another computer other than my own and I try to open the database through sourcesafe, it doesn't acknowledge that a database was found.  Even after browsing to the database, the dialogue box for which database to open will remain ...Show All

• SQL Server Can service broker process a email message

  How do you set up the service broker to process an email message, and how do you format that message and send it to the que. Can the service broker alos process an html form from a que. Thanks Service Broker can only be used for exchanging messages between two SQL Instances. You cannot send nor receive email messages directly to/from Service Broker. Why do you need to send email messages to a queue HTH, ~ Remus ...Show All

• Visual Studio 2008 (Pre-release) Not Logging Msmq Messages

  I have this configuration in <system.diagnostics> section <system.diagnostics> <sources> <source name="System.ServiceModel" switchValue="Verbose, ActivityTracing" propagateActivity="true"> <listeners> <add name="messages" type="System.Diagnostics.XmlWriterTraceListener" initializeData="logs\tracelog.e2e"/> ...Show All

• Visual Basic populate a form textbox with results from db query.

  When users open my file in their browser, I want them to click on a button and populate a textbox on a form with the results of a query. Here is the code: <!--#INCLUDE VIRTUAL="/includes/connection.asp" --> <!--#include virtual= "includes/adovbs.inc"--> <script LANGUAGE="vbscript"> Option Explicit DIM mySQL public recnum Public objRS mySQL = "SELECT A12345 FROM Employees" Set ...Show All

• Visual Studio Team System FxCop 1.35 Feedback

  Hi guys. Almost missed this release, downloaded it yesterday and have been playing around with it. Looks good. Here is a couple of minor things that I found: Documentation: 1. The help provided with FxCop still has version 1.32.0 throughout it. The online documentation has 1.312. Also both don't have any documentation on the new rules (ExceptionsShouldBePublic and AttributeStringLiteralsShouldParseCorrectly). User Interface: ...Show All

• Windows Forms Clipboard and Thread

  Hi I like to watch the clipboard in an thread. And when there is any changing i like to get an Messagebox Followoing Code I have: using System; using System.Collections.Generic; using System.Text; using System.Collections; using System.ComponentModel; using System.Runtime.InteropServices; using System.Windows.Forms; using System.Drawing; using System.Data; namespace ThreadTest.OwnClass { ...Show All

• Windows Forms I need to build an application like microsoft money (interface)

  I need to build an application like microsoft money (interfaz), and i don't  how...... i need to know how build that interface with VS.NET Windows Forms in Visual Basic, and with good performance..... Thank you for help and time You may  ...Show All

• .NET Development Operation must use an updateable Query

  Hi, I am using VS 2003 and C# with OleDb connection to read and write from Excel spreadsheets. I have no problem reading Excel data but when writing to Excel I got this error on this line: oleCmdInsert = new OleDbCommand(@"INSERT INTO [Sheet1$A1:A1] VALUES ('ABC')", _oleConn); oleCmdInsert.ExecuteNonQuery(); Here is the error: System.Data.OleDb.OleDbException: Operation must use an updateable query. at System.Data.OleDb.Ol ...Show All

• Windows Forms interface not registered?

  Hi, I'm trying to save an HTML file to a MHT file. This is what I'm doing: CDO.MessageClass msg = new CDO.MessageClass(); msg.CreateMHTMLBody("http://www.microsoft.com/", CDO.CdoMHTMLFlags.cdoSuppressNone, "", ""); ADODB.Stream stream = msg.GetStream(); stream.SaveToFile("test.mht",  ...Show All

• Windows Forms Installer Class - upgrade settings

  Hi, I have an installer class which overrides OnAfterInstall with a call to Settings.Default.Upgrade(). The code is called when the application is installed, however the settings are not upgraded. Anybody has an idea what is wrong here Thanks, Tom The problem is that Settings.Default.Upgrade has to be called from within your application. Effectively, you are upgrading your setup application settings, not the s ...Show All