Apache by itself won't be making the connection, just as IIS by itself doesn't (you're thinking about ASP most likely, which makes ADO calls, but does so in the context...

SQL's normal behavior is to continually request memory as it needs it. Unlike other apps, however, it'll hold that memory unless it gets a request from the operating system to...

The page size is 8 KB.

An extent is 8 contiguous pages, meaning it's 64 KB.

3 pages across 3 extents means you have pages scatted across 3 separate extents. SQL...

So one persistent connection... multiple runs within that connection.

Okay, you probably want to run a Profiler trace just to verify the connection is staying open and the commands are being...

Global temporary tables (##) will stick around until the session ends (basically the connection is ended). Local temporary tables (#) will stick around to the end of the stored procedure....

I haven't seen any way, documented or undocumented. I'll take a look and see if I can dig up something. Renaming the key would be logical but didn't do anything....

The problem isn't that you're trying to execute the ActiveX script multiple times. The problem is your trigger is calling a SQL Agent job and only one instance of a...

Let me make sure I'm understanding what you're trying to do.

You want to lock records and control record locks in Oracle through the linked server connection from SQL Server? And...

These may be of use to you:

INF: How to Monitor SQL Server 2000 Blocking

http://support.microsoft.com/default.aspx?scid=kb;en-us;271509

INF: Understanding and Resolving SQL Server 7.0 or 2000 Blocking Problems

http://support.microsoft.com/default.aspx?scid=kb;EN-US;224453

I have forced connections using SQL Server and IIS using IPSec, yes. We do not currently have any running in production at this time. However, we do use IPSec policies...

Is there a reason you are creating directly into tempdb and not using # or ##? In any case, you have the option to drop the table when done, otherwise...

When you had force encryption turned on through the server, you connected just fine? Is that correct?

Also, you say you have the server certificate installed on the client. Do you...

You might want to performance monitor this system, then. Yes, it is possible there is another program running, but typically you'd see the slow down across the board. Watch the...

You cannot repoint UDP/1434. If you block UDP/1434 all clients will need to be specifically configured to connect to the SQL Server with the appropriate TCP port.

A proxy server,...

Can you post the last few lines (20 or so) of the sqlsp.log file? You'll find it in %SYSTEMROOT% on the system you attempted the install from. Make sure you...