He has been doing it repeatedly! Else I would have left it for the normal lounge flamers :) leppie::AllocCPArticle("Zee blog"); Seen on my Campus BBS: Linux is free...coz no-one wants to pay for it.

Your equation doesn't take into account the most important variable - souls. With a tiny population, a given soul would have to wait a long time to be incarnated. The larger the population is, the faster a soul would become reincarnated. Have you answered an MTQ? Check out the stats! What's the latest butt-scratch count? Check it out!

Baaa If god didn't create man, man would have created god. Tim Smith I'm going to patent thought. I have yet to see any prior art.

Within. Software Zen: delete this;

I'd say running a SQL server is a lot more complex than AutoCAD.

Going through the options: a) has no effect, since that's purely syntactic convenience: SQL Server translates that to PolicyDate >= '2/1/2001' AND PolicyDate <= '3/4/2002' anyway. b) A hash might work better, but it's clear that the index isn't being used, as you say. A hash join constructs a hash table of one side of the join, which the other looks up in, whereas a loop join simply loops over each side of the result set looking for matches. c) According to http://www.sql-server-performance.com/hints_table.asp[^], WITH(INDEX(0)) forces a table scan - precisely what we're trying to avoid. That same page recommends using index names rather than index IDs, because the IDs can change if the indexes are dropped and recreated - in other words, they're fragile. d) Updates any index statistics that are out of date. SQL Server uses the statistics to determine how good an index might be for finding the requested information. e) Rebuilding the index will incidentally update the statistics, but it's a lot of work that might not be necessary (and locks everyone out of the table while it does it). Assuming that appropriate indexes already exist (and I don't know which table contains which fields), then updating statistics might work. If there are no appropriate indexes, it won't help - at least one of the tables will have to be scanned to find the rows matching the WHERE clause, then those rows joined onto the other table. The problem description doesn't say whether the index scan was caused by the join operation or by the original lookup. Answering your question 3, I looked up 'hash join' in my copy of Inside SQL Server 2000 (which I thoroughly recommend). If there isn't a good index for the join (in this case, no index on AgentPolicy.PolicyNumber), a hash join might be cheaper. However, it can only be done for an equijoin (i.e. the join condition uses '=') and can take a lot of memory. The query optimiser won't use it if it thinks it will need to do more I/O to store and retrieve the temporary hash table than it will to repeatedly retrieve the original data. This is one reason to keep hints out of your queries - they tend to be very system specific. What helps one system might hurt another.

You can't create an HttpContext that represents a request - ASP.NET does this. If you need to get this for your application, you can either create an IHttpModule or IHttpHandler that gives you the HttpContext for a request, from which you can get the intrinsic objects (Request, Response, Server, User) which can get you the HttpApplication from the context. The Application property is there so you can access it from either modules or handlers. This is all covered pretty well in the SDK documentation for these interfaces and in several topics for create modules and handlers. -----BEGIN GEEK CODE BLOCK----- Version: 3.21 GCS/G/MU d- s: a- C++++ UL@ P++(+++) L+(--) E--- W+++ N++ o+ K? w++++ O- M(+) V? PS-- PE Y++ PGP++ t++@ 5 X+++ R+@ tv+ b(-)>b++ DI++++ D+ G e++>+++ h---* r+++ y+++ -----END GEEK CODE BLOCK-----

First, I'm not sure either what they mean by "Configuration Manager". However, as I recall, for connection pooling to work all connections must use the same connection string. So if all the users are connecting like this: "Server=MySQLBox;Database=MyDB;Userid=someusername;password=somepassword" then connections won't be shared. However if all the users connect through the same account, or a trusted connection, then the connection string will be the same each time. My guess would be that as it is an intranet application and MS Windows Authentication is available the Trusted Connection route is the correct one. So each windows user (or better role) that should get access needs to be set up in SQL Server (This can be done in SQL Server 2000 Enterprise Manager) --Colin Mackay-- "In the confrontation between the stream and the rock, the stream always wins - not through strength but perseverance." (H. Jackson Brown)

CillyMe wrote: Thanks, but is it possible to Assert in ASP.NET? As far as asserting with a popup, were would it popup a message on a web server? In a Windows application you are assured there is usually a user sitting there in front of the computer. On a web server nobody is usually logged in to the server. I do not know of debugging with Assert popups in ASP.NET. You might need to make a trace listener to handle them. Rocky <>< www.GotTheAnswerToSpam.com

You're right, configure it before loading the application or UI is constructed. Point well taken.

We only have Visual Studio.NET on the multipurpose development server machine. So, we do have the following folder: C:\Program Files\Visual Studio.NET\Crystal Report\ But, no, we don't have Crystal Report installed. I searched Google, there're a few people who share same problem, but I suspect that they have the problems because their ASPNET account hasnt been assigned adequate privileges or ACL hasnt been configured. Thanks though.

Michael P Butler wrote: Code to read and write databases, getting data in and out of forms. Property accessors, copy constructors... the list is endless. You mean, repetitive, automatic things? That's why macro, templates and code generation exist :) To put fun back to code :) Trying to make bits uncopyable is like trying to make water not wet. -- Bruce Schneier By the way, dog_spawn isn't a nickname - it is my name with an underscore instead of a space. -- dog_spawn

Doesn't a Function have to return a value in VBScript? I don't use them often enough to be sure, but I seem to recall that functions have to be used on the right side of an assignment operator, while Subs can be called as freestanding entities. Try changing the Function to a Sub in loadsiteconfig.vb and see if that helps. "Your village called - They're missing their idiot."