Connection pooling has nothing to do with number of connections it has to do with the reuse of connection and is a client side thing, not server.

>>Some of us actually follow the basic standards of our trade.  Some of us look a the US Government standards, since they are the **largest users of data processing on...

Joe it is all fine and wonderful that ISO-11179 exists but until I read in your book "DATA & Databases: Concepts In Practice" I had never heard about it or...

Sorry setting up a permanent trace on the server that outputs to file, Profiler or a tool like profiler will be required to capture all of those details as SELECTs...

Note: there is one known issue in QA. If the comment block contains the word GO (or whatever is defined as the batch seperator in QA's options see Optionbs->Connection(tab)->Batch Seperator(text field)) on...

Miminmal at best in most all situations. However can impact file fragmentation on the hard drive. And then you might just want it that way for backup and restore purposes....

See if this can help you out any.

Had a sec of nothing else so take a look and see if this helps. I used the following SQL...

---------------------------BEGIN---------------------------

select cast(object_name([id]) as varchar(40))...

Just so you know if the future some of the extra settings not as direct properties are generally reachable thru the .Properties property. To get the right names use Disconnected...

Has anything else been done in recent days? And is the only affected user. If the only one affected then I don't believ it has anything to do with public....

I believe this will do the trick.

For SQL Auth

objConn.Properties("UseTrustedConnection").value = 0

For NT Auth

objConn.Properties("UseTrustedConnection").value = -1

The error says it all.

"EXECUTE cannot be used as a source when inserting into a table variable."

so you cannot exec a stored procedure and get the results dumped into a...

Quite honestly you are probably going to find a developement job easier and from their can get the expeirence and chance to do Admin work. Once you get in then...

1) Only if they are already on a seprate drive/drive array from your data files and they themselves are on seperate drives/drive arrays from each other. They will use a...

I don't recall an specific never every being dropped. I have heard as high as 50,000 connections on a server before in major centers. It is all based on the...

Now see. You already got a copy from my website, so what's your complaint, not glossy enough for you?