Ed_Zero's Q&A profile

• SQL Server TSQL Change: BINARY_CHECKSUM(*) no longer works on INSERTED or DELETED tables with non-comparable types.

  Hi, I am currently migrating from Sql Server 2000 to 2005 and am trying to use the new Team Suite for DB Professionals. One of the triggers we have, which works fine in 2000, produces errors in 2005. You can reproduce this problem by creating a trigger like this: CREATE TABLE LastModified ( PrimaryKey INT NOT NULL PRIMARY KEY, DateLastModified DATETIME NOT NULL DEFAULT(GETDATE()) ) GO CREATE TABLE MyTable ( PrimaryKey INT IDENTITY(1,1) PRIMARY KEY, SomeTextField TEXT NULL, SomeVarChar VARCHAR(200), SomeBitField BIT = 1 ) GO CREATE TRIGGER TestTrigger ON MyTable FOR UPDATE AS SET NOCOUNT ON UPDATE LastModified SET DateLastModified = GETDATE() WHERE PrimaryKey IN ( SELECT I.PrimaryKey FROM ( ...Show All

• Visual Basic File not found, even though it exists!!

  I have already posted this item in the DirectX forums, but without success. Hopefully someone can find an answer! Hi I'm making an MMORPG in DirectX7 (NOT DirectX9, simply because DirectX7 is easier). I have made a 261-frame rendered intro sequence, and I have placed all these images into a DLL, which works fine and has absolutely no problems whatsoever. The problem is, when I extract the images to disk, then try and read them again in a surface loader, DirectDraw returns a File Not Found exception, even though the previous line of code tested the file's existence and found that it really did exist! Here's the code: Sub LoadIntro() Dim k Dim ddsd As DDSURFACEDESC2 ddsd.lFlags = CONST_DDSURFACEDESCFLAGS.DDSD ...Show All

• Visual C# Getting the HTML of a web-page

  Hi, I'd like to get the HTML code of a web page for which I have the URL, using C#, without opening that page in an instance of the web-browser control - how can I do this (VS 2005) Thanks How to get a page source code of URL programmatically ...Show All

• SQL Server How to enforce SQL Server 2005 to use Worktable?

  I have a problem in SQL Server 2005. In some cases SQL Server produces an execution plan of complex query (8 joins of views, some of views contains couple of joins) which does not contain a woktable creation in tempdb. As a result time of query execution increasion for about 5 seconds to about 4 minutes. All necessary indexes are created. It sims all data located in cache. Is there any way to enforce SQL Server to create worktable Query SELECT [a0].[id],[a0].[Priority],[a0].[Heading],[a0].[DocumentDate],[a0].[LastName],[a0].[FirstName],[a2].[Name],[a1].[Position],[a4].[ContactTime],[a4].[Subject],[a0].[WorkPhone],[a0].[MobilePhone],[a0].[FaxNumber],[a0].[PrimaryEmail],[a5].[ContactTime],[a6].[Value],[a7].[id],[a7].[id_class],[a8].[id ...Show All

• Visual Studio Express Editions How to detect when wave file has finished playing?

  I had to use the kernel call sndplaysound rather than any of the newer audio players because my vb.net program must handle both PCM and non-PCM wave files. If I choose to invoke sndplaysound so that control returns to my program immediately, is there a way to detect when the wave file has finished playing The reason that I ask is that I am locking the keyboard during play, but I want to have a mouse click be able to stop the play. Thanks in advance, Ron in Rochester I've used the mcisendstring API with window media player. It has two modes. One as A says, will lock up the gui. The other is an asyncy mode. When running asynchronously it has a peroperty that will tell you if it's playing which I polled ...Show All

• Windows Forms Capturing Keystrokes

  Is there a way i can capture application-wide keystrokes in my application Basically, i want an event to fire whenever i press Ctrl+Shift+C anywhere in my application. It only needs to capture it if the application has focus i.e. i dont need to capture keystrokes sent to other applications. Is there an easy way to do this, or an example someone can give me for it If only there was a in MyApplication_Keydown in the application events section... Great - thats exactly what im looking for but with a slight problem... Are you able to convert that into vb.net ...Show All

• Windows Forms DeployVB Application

  I would like to deploy a VB 2005 application that will run from a CD ROM without loading anything onto the user's computer. I would like for the user to plce the CD ROM in the CD Drive, navigate to the start Icon, click it, and run the app. I do not want there to be any upload to the user;s computer. Is there a way to do this without loading .NET or any other file to the user's computer Or you could write an application in something like C++ that is not dependent upon the .NET framework. You would be surprised at how many users worldwide have a version of the .net framework installed on the machine - as it does go out as an optional update in windows update and with Vista the .NET 2.0 framework will be installed from the outset w ...Show All

• SQL Server Distributed data synchronization - Comparing timestamp

  Hello, I am designing a distributed application where a central SQL Server 2005 database will need to be synchronized with remote SQLExpress databases via a WebService. Data can be edited at the cental db (by our connected applications) or on the local SQLExpress dbs running on the users machines (by this disconnected application). Now, how can I use the timestamp column to determine the most recent update. The most recent update to me is not the user that most recently invoked the syncing WebService, but the most recent time when the change was made to the data locally vs the change time at the central server. Because a user could make a change on his laptop on Monday but not synchronize it till Friday. I dont want the Mon data to o ...Show All

• Visual Basic unable to create exe with multiple forms

  Hi, I have a VB application with 2 normal forms and 2 dialog forms.I am not able to create an exe of it.I tried with File->Make option.It creates a scrap clickable exe which fails to load.Could anyone please tell me the possible problems. Regards, Swapna Is this VB6 that your trying to use, as I seem to recall Make was an option rather than a build in .Net When you say the craps a scrap clickable exe. Are you trying to run the EXE on the same machine as the development machine or is it a different machine. If its a different machine, then there may be other required files that you may be missing . In VB.Net applications, the .NET framework must be present for the applications to run, in the case of older versions of ...Show All

• SQL Server Response time of Reporting Services

  Hi ! We have a web application. We have receive some feedback from our client about the response time of ReportServer. Here is the problem. Let says that for a couple of hours nobody has request any reports from ReportServer. Then someone is requesting a report. In this case the time before the ReportViewer will start to query the report will be longer than usual. It's like some kind of process is shut down and ReportServer need to start this process before processing the report. Once this report will be display the problem disapear. What i mean is that if someone is requesting another report it will be as fast as usual. But once again if for a couple of hours nobody is requesting a report, the next time someone will request a report it w ...Show All

• Visual Studio 2008 (Pre-release) A component to display a database table

  hi i have this code : string myQuery = "SELECT Name From [User]" ; OleDbCommand cmd = new OleDbCommand (myQuery, myConn); OleDbDataAdapter da = new OleDbDataAdapter (cmd); DataSet ds = new DataSet (); da.Fill(ds); Object []temp = ds.Tables[0].Rows[0].ItemArray; object has the returned items of the select query.... i want a component to display the returned records same as datagrid in .NET Web development ...any suggestions thx If you only want to display the data (i.e. the user will not edit the values) then use the ListView. If you need editing capabilities, there really is no out-of-the-box way to do that. You might want to give the Infragis ...Show All

• Microsoft ISV Community Center Forums Ideas for storing results from multiselect listbox

  I need to store the results from listbox where the user may make multiple selections, any suggestions Hi I would use an array, which you can redim to fit the number of selected items, or if you are more adventurous try using a collection. ...Show All

• SQL Server Transport Security vs Dialog Security

  In an environment where there are many initaitors speaking to a central target with frowarders in between, from what i can understand this best policy is to disable encryption on the endpoints, since dialog encryption will be enforced this is all that is really required, is this correct. If the endpoints used encryption the message would need to be encrypted and decrypted at each forwarder resulting in slower perfromance, where as dialog encryption would only encrypt at the sender and decrypt at the target, so is this the best way to go Secondly is it best practice to open a dialog initally and send messages over this dialog for years never ending the conversation This way the services only have to authenticate eachother once, if the ...Show All

• Visual Basic Moving a form.

  Hi there, Currently in my application I have made it so I have no form border. I have put in my application.exit and minimize code but I'm wondering what the code is to move the form around ONLY when pressing down on a button/control. Thanks, AliQ Hi, I've been playing with this which moves the FORM to 250,250 on button1 being clicked. The second Sub will move the FORM around when you click a mouse button on it, but i'm still working on doing this while a button is down. Me.DragDrop may be the way to go ahead with this, i'm not sure. Regards, S_DS Private Sub Button1_Click( ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click Dim mouseEventArg As ...Show All

• SQL Server Request for feedback - Aliases have been deprecated for some time and will be removed soon

  As documented in SQL Server BOL, aliases have been deprecated for some time and we are planning to remove them from the product in the next release. We will greatly appreciate any feedback or comments regarding this change. We would like to know how our customers will be affected by this change and analyze if there is anything we can do to help you to make the transition easier. Thanks a lot, -Raul Garcia SDE/T SQL Server Engine Alias were superseded by roles in SQL Server 2000, for more information you can visit the following BOL pages: · Deprecated Database Engine Features in SQL Server 2005 (under “Features Not Supported in the Next Version of SQL Server” ): http://msdn2.mic ...Show All