Allan Kemp's Q&A profile

• Visual Studio Team System DisposableFieldsShouldBeDisposed and HashAlgorithm

  HashAlgorithm-derived classes use Clear() as the publicly-available dispose().  Safe to ignore but would be nice to factor in specific classes with methods other than Dispose() or Close(). Yes, we will be quiet if there's a call to clear on a HashAlgorithm instance. The Design Guidelines agree with you. The example of effectively renaming Dispose to an alternate form such as Close or Clear is specifically ...Show All

• Windows Forms Deployment Project

    I have the results of a large deployment project that have to be installed. The prerequisites are: To test and see if the V2.0 framework is installed and if not install it To test and see if the MDAC V2.8 is installed and if not install it To test and see if SQLServer Express is installed and if not install it Also the customer project comes with a .MDF database that has to be added to the newly ins ...Show All

• .NET Development CPU usage

  I have to write a small service which will monitor the CPU usage and if a particular process consumes more than a predefined amount of CPU for a certain duration of time (that is, if this process is responsible for "hanging" the server), this service will kill that process and then restart it (of course, only if this process is one of the "custom" programs, not a system process). My question is: is there a programm ...Show All

• SQL Server Drag & Drop Multiple Query Files Into Management Studio

  In SQL Server 2000, you could have a Query Analyzer (QA) query window open to a particular database, and drag and drop a group of query files from Windows Explorer on it. QA would then open a query window for each of the files, and automatically default it to that database. I am trying to get the same functionality in SQL Server 2005 Management Studio, but it nags me with the "Connect to Database Engine" dialog box for every file. W ...Show All

• Visual C# byte to integer conversion - client server programming

  hello... I have written a client in java and a server in C#... when i write those programes in my computer, opening same port and listening to same IP...everything works fine. But when I move my server to another computer(also running win XP pro), at one point of the communication, i need to make multiple readings from server on integer value sent by client. The way i did it is by converting the integer into 4 bytes BYTE, and send it ...Show All

• SQL Server copying data to SQL Server from an Oracle database

  What is the most straightforward way to copy tables and views from an oracle database into a sql server 2005 database thanks for any suggestions. Marilyn Mount your Oracle server and database as a linked database in your SQLServer environment. Then perform a standard insert-select (or select into). If you also must make data transformations you should use DTS (or what's the name nowadays is). Best r ...Show All

• Visual Studio How to exclude a project from a source controlled solution

  Hi Using VSS 2005,  We have a source controlled solution and we need to exclude 2 projects from the source control – but have the in solution -. I haven’t found that option when I right click on the projects. How can I exclude them from source control   Thank you, Alan Hi Alan, Projects cannot be excluded from source control once the solution has been added to source control. The idea of ...Show All

• SQL Server how to fixed the size of the report and landscape view state?

  Good day. How to make or fixed the size of the templates and how to make the report in landscape mode i have make a layout in the landscape mode but the priblem in print preview it is not in the landscape mode. thanks your help is greatly appreciated Check the width and height property of the "Report" and "Page". Both should be proper, for your report to print (preview) in landscape. ...Show All

• Visual C# How do you change the value of an already created cookie?

  Below is the code I'm currently using on my login page to save the username and password. I'm going to later encrypt it but for now I'm simply setting it.  HttpCookie UNcookie = new HttpCookie("TheUsername",txtUsername.Text); UNcookie.Expires = DateTime.Now.AddYears(1); HttpCookie PWcookie = new HttpCookie("ThePassword",txtpass.Value); PWcookie.Expires = DateTime.Now.AddYears(1); Response.SetCookie(UNcookie); Response.SetCookie(PWcook ...Show All

• Visual Studio Team System modifying task template for existing project

  I need to make Start Date and End Date fields in Task editable. For this I can download the process template, remove "ReadOnly" attributes for the fields in task.xml and upload the template. The problem is that the new setting will apply to new projects only. Is there any way to apply it to the existing project Yes, you can use "Witimport.exe" located in the %installdrive%\Program File ...Show All

• SQL Server Script Transformation

  A new question ! When you use a script transformation you have input rows and output rows. Is it possible to have a different number of rows at input and output Thanks   Coroebus wrote: I get an error with my script : PipelineBuffer has encountered an invalid row index value. Dim NbCode As Integer = 20 ' set the nb of code per row Dim liste As String = Nothing ' the string containing the output row ...Show All

• Visual Studio LAN Booster

  Unable to use SourceSafe LAN service, performance of SourceSafe operations will not be optimal. I have been working on this for the past 3 days. This was a SourceSafe database created in 6.0 and was working correctly with 6.0 integration. This is what I have confirmed: The Visual SourceSafe LAN Service is running. I installed the COM Internet Services Proxy on the Server (saw in a different post) and rebooted the server. Added Tun ...Show All

• SQL Server Can't get SQL Manager to connect to server instance SQLEXPRESS

  I installed SQL Server Express and SQL Server manager, then tried to start manager. SQL Service is running, but SQL Manager attempt to connect to SQL Server instance times-out even though I correctly identify instance as SQLEXPRESS Everything seems to be normal - both SQL Server and Manager are on a single Windows  XP home machine. Any suggestions. Thanks Hi, There are only two datatypes that could handle da ...Show All

• SQL Server SQL 2005 Very Slow on Itaniam 64bit

  Hi, I am facing a very wierd problem with SQL 2005 Itaniam 64bit with 4 processor machine. A simple SQL Select Statement: Select * from table The statement takes almost 45 minutes on a table of 7 million records, while on SQL 2000 32bit 2 processor machine it takes 10 minutes. The checked the index, and rebuilt it several times and still the problem persists. I tried the database fine tuning wizard but still no effect. Tried ...Show All

• Visual Studio Express Editions How do I calculate a person's age?

  Visual Basic 2005 Express Edition: I need to display a selected person's age in years. Lastname, Firstname Age: 99 LastName, FirstName and BirthDate are from my SQL database table. Pocket, Polly Age: 6 hi, you can try something like this Sub Main() Dim birthday As DateTime = "29/10/1975" Dim age As Integer = DateTime.Now.Year - birthday.Year Console.WriteLine ...Show All