SQL Standard edition only supports 2GB of RAM regardless of any switch you use in the OS.

Full stop - no exceptions

Hence you saw no difference.

You need SQL Enterprise to use...

Try -R as a switch on your BCP to pick up client regional settings, no need to change anything else

You could write your own, but why are you not using the server vendor tools?

for example, dell server , dell tools

On a  compaq server, you can set up (I forget...

DECLARE @codesnippet varchar(100)

--Amend here to insert wht you are looking for

SET @codesnippet = 'wantedword'

SELECT DISTINCT LEFT(DB_NAME(), 20), (LEFT(OBJECT_NAME([id]), 40)) AS ObjectName

        FROM dbo.syscomments

        WHERE [text] LIKE '%'...

I've ran queries against the same server with standard 100MB and then with my PC switch port put down to 10MB. Same query, same row count took over 3 times...

I have done this on remote SQL Servers that we administered over the internet.

We used tcp only and installed a certificate on the SQL Server, then used the "Server Network...

When you connecting to a SQL Server install (simply), say "SQLServerBox" it looks for the computer name in DNS, resolves this to IP address, then connects to that.

SQL Server (2000)...

following on, SQL 2000 SP3a does recognise hyperthreading and uses "4" cpus but only requires 2 CPu licenses

Or using ANSI-92 SQL, rather than the archaic ANSQL-89 (older Sybase, SQL 6.5) join-in-the-where-clause

update products

set qty = a.qty - b.qty

from products a JOIN (select product_id, sum(qty) qty from invoice_product group by...

I'd put SP4 on, but then I have a lot of control over my environment and you sound like you'd have some job on your hands...

I was running hotfix 961 anway, there...

SET XACT_ABORT ON will abort your batch (up until the next "GO") if there is an error.

IF you issued a "BEGIN TRANSACTION", it will be rolled back.

Testing for @@ERROR after...

The error will NOT be in the database.

Databases don't generate PDFs!

Something else does that needs a trigger or check to start the PDF process.

If you have 2 databases on the...

Probably, if you using the sp_OA,,, procs for example or xp_cmdshell

Live server permissions then?

Why do you think this is a database problem?

Does the SQL Server generate a PDF?

Is the customer data being written into the live db? Such as tighter security on live?

Same...