Just to add that this also works on Windows server 2008. I think the most useful thing this added for me was a folder containing a reference to all .Net Framework and COM libraries, and allowing an easy way to un-install any of these.

I have 2 sets. I had one set for about 2.5 years and then the light in the lcd stopped working - you could still see the characters however and there was nothing else wrong with the system. So I contacted Logitech about it, and they sent me a brand new set of speakers. And if the speakers are not loud enough, turn up the boost: http://en.wikipedia.org/wiki/Z-5500#Easter_Eggs[^]

Hi, I have found the solution, so am just posting an answer in case anyone else comes across this. Read the following link for information: http://sqladvice.com/blogs/gstark/archive/2008/02/12/Arithabort-Option-Effects-Stored-Procedure-Performance.aspx[^]

Hi I have an interesting problem. I have written an SP to return some stats. When I run this through SQL Management studio - the result returns in 2 seconds or less. Now when I call this through asp.net - it takes anywhere from 2 minutes to 10 minutes+ (asp.net times out). I have tested this on my machine, and one of our offline production web servers. Now, when I attach the debugger to my asp.net code, where it makes the call, results are just as quick as when i run it through the management studio. Yesterday I thought I was onto something - the user I was connecting with, was being used by multiple sites and applications. I created a new user and tried using this. Now asp.net was returning the records as quickly as expected. However, this morning the performance has gone back to what it was, and it takes ages to run. I have connected to SQL management studio using the user credentials that the asp.net site is using (SQL connection string). When I run this, results return in 2 seconds. I also looked at the activity monitor - when I run this through management studio, CPU time shows as around 1000. When I run it through asp.net - this rises to between 100 000 and 400 000 in the CPU time. I am not using cursors, this is just a select, and usually returns 10 - 50 records at most. The query does access multiple databases, some of which are on a linked server. Thanks, Wayde

Thanks for the reply. I was just kind of hoping there was a way to store the value in a temp variable on a row by row basis, but using inline views does the trick as well - so thanks.

I am building a query which returns a few calculated values. Some of these are as simple as ColA - ColB, while others are far more complex - but are often based on the result of a previous result. My question is, how can I reuse these fields that I have calculated? A lot of the time that I do these calculations, I also need to exclude some values in the WHERE clause, based on these answers. Example: SELECT ColA - ColB [Result] FROM Table WHERE (ColA - ColB) > 0 How could I calculate ColA - ColB just once - and use the result of that in the where clause or another column? Thanks in advance

Hi, thanks for the advice. I will try this and see what happens - I had registered the controls in the web.config file, but I will try put it onto the page and see what happens.

Hi I was running my application just fine, but when it came to trying to precompile the application, I got an error saying "the type or namespace name 'x' could not be found. What I have is few pages, and a folder called usercontrols with a few controls(ascx) inside it. What I do is load both controls on a page, and inside the one control I use the FindControl method, and attempt to cast it to the control type (as I said, this was working perfectly during my testing), and then set a few properties of the control. Now I do the same thing on one of my pages, and it works fine. This is the line of code i use: usercontrols_ContributionEditorControl contribCtrl = (usercontrols_ContributionEditorControl)Page.FindControl("contributionEditorControl"); Is there a way I can force asp.net to see that I have all these controls in the controls directory? I dont even mind if its possible to turn this warning off (though I would rather get it fixed), but I do need it to work this way. Or is there another way to set the controls properties from within a control?

Hi, if you dont mind me asking, I have been searching but have been unable to find out what connections this monitor accepts. Does it have DVI? Thanks! Wayde

Hi, I have a table that contains a column of type XML, and an XSL style sheet is stored within these. Inside each XSL, there is a value called TargetURL - which I would like to update to URL. The text replace function does not work with XML, and I did not find anything in google. Does anyone know how this can be done?

Hi, not sure if this error has been reported - but my user details are lost when I close the browser (even though I asked to be remembered) - also, when I select the asp.net articles section, the "Latest best picks" always shows as empty, as does the last 10 updates. Thanks

Hi, assume I have two tables called Orders (ID, DateCreated) and a child table called OrderDetails (ID, OrderID, ProductID, Quantity) What I need to do is calculate the average last 6 orders. Now if there are only 5 dates worth of orders I would need to know this value as I need to divide the sum(Quantity) by the number of orders - which cannot be greater than 6 previous orders. I have tried a few different select statements, but cannot seem to get the result I am looking for. Oh one other thing, I would be selecting these records by ProductID. Any suggestions at all? Thanks

However, even if they were awarded that try, you still would have been a point behind us. Though if you really want to talk about disallowed tries - SA had two of those in the world cup final in 1995. So it does happen.

Hi, I have a table that potentially will span across multiple pages. The table has a border around it, however, when it flows onto the next page, only the left and right boreders show. Is there a way that I can get it to show the top and bottom borders when it spans multiple pages? So on the first page it has the top, left and right. The last page will have left, right and bottom. The second page just has left and right borders. So obviously I am trying to get the bottom and top borders to display always. Note though, that individual rows do not have borders. Thanks in advance.

Thank you for the answer.

Hi, I have a question. If I create a webservice that happens to have two threads for seperate tasks - when I use lock, I understand that the 1 thread will not run until the other finishes its task that is locked. My question then, does this lock per request, or for the entire application? I am just worried what would happen if 3 requests came in at the same time. Thanks in advance!

Hi, I am using a wizard control, and I notice that when it places the "next" button, it puts this in a table, then in a td with align=right specified as a style. Now I want to remove this style. I thought the best way to do this is to override the control, however if i do that, I cannot find what the rendered html looks like to overwrite. Does anyone know how you can overwrite this before the control gets generated?

Hi, thanks for your reply. I have looked in the web.config now, but cant see what I would need to change. Do I need to do something to tell it to look in the bin folder? By the way, the javascript error message I am getting is: 'Sys' is undefined

I was developing an application using Ajax.net from Microsoft. Testing on my machine went well, so I uploaded it to our server (its a shared server, so only ftp access). Now I know the web host has not installed this component on the server I am using - but when I tried to access the page I created, it fell over as it was missing the files from the install. I then added these to be included in my build and uploaded again. Now the page works - but with no Ajax features, it keeps refreshing as normal. When loading the page, it does report a javascript error that its missing something (I cant remember the name right now - and being at work now I am not able to check this either). Anyway, my question is if it should be possible to run Ajax.net on a remote server in this way, or if they would have to install this. Thanks

Hello I see your original question changed. Rather than turning off the validation at the top of the page as you do, you could also use the Server.HtmlEncode method For more information, read this: http://www.asp.net/faq/RequestValidation.aspx[^]