Search results for query: *

Hi, I have an internal web application running on an intranet. Everything works fine, until an individual users session times out. When they return to the application, after the timeout period has expired, and click on a link which should launch another ASP the response "Page Cannot be...

Thanks Bastien, but we've tried that and its still doesn't release the memory.

Don't know whether this will be an ASP or IIS solution, but... We have some ASPs that use large multi-dimensional arrays, and we are finding that once finished the resource is not being released, therefore leading us into eventual memory problems on the IIS server. Is there a command, or a...

Cheers James, much appreciated.

Hi, I have a requirement to run a query using data from 2 or more tables. These tables exist on 2 different SQL Servers. Is it possible to JOIN these tables in a T-SQL Query? Thanks Dougie

Thanks Guys, exactly what I’m after. Cool feature as well. Dougie

Is it possible to pass a value to a DTS defining the path to a file, and somehow using that variable within the DTS transformation to say "the text file is here". Your help much appreciated Dougie

Aha!! Have created a couple of very simple asp pages. One which writes a value to a cookie, and the other reads the cookie and displays the value. On my system, which does not experience the above problem, it works fine. On the other systems it fails. Install the security patch for IE from...

codestorm, Thanks for your reply. Have investigated both suggestions but have still not found the answer. <%@enablesessionstate=false%> is never used in the pages, I even tried <%@enablesessionstate=true%> to no avail. We do use policies in our company for limiting user access to the desktop...

I have been scanning loads of techie websites, microsoft knowledge base, and tek-tips in search for the answer to this problem, but to no avail. Sessions variables are getting bad press, but unfortunately a re-write of this complete application to use client-side cookies, or storing variables in...

Oops! stupid me! &quot;matching first then the non matching values&quot;

I tend to agree with pankajv in that these solutions are over complicating it. It simply requires, SELECT * FROM tbl ORDER BY col1, col2 Have tested this and it produces exactly the result as displayed in the initial post.

Doh!!!... of course!!! Thats fixed it, cheers Rick. I had installed the service pack on my own machine, but had forgotten all about it on the client. Dougie

Thanks Bernadette, Have created another similiar DTS on the server, even created a further one on the other client PC. Unfortunately they both still fail with exactly the same error. Dougie

Hi, I have a DTS package which runs successfully on my own client PC. However, when I attempt to run it on other machines, using the same account, the steps copying data from a file to a table fail with error -2147217887 (80040E21). Have tried reinstalling SQL on the failing machines but this...