You're completely correct.

I actualy wanted to point to SET XACT_ABORT  ON

This should stop the execution when the first error occurs within a batch...

Antivirus software performing a systemscan at that timeframe ?

We've had some problems using a filebackup software (veritas) that was copying our .bak files at the moment that our backup job started to run.

Because of the folderlock the backupsoftware...

- SET ARITHABORT ON

... but I don't want to have to check after every statement....

Don't complain if...

- what's your server's ram total ?

- The OS also need ram to manage AWE

- keep in mind that task-manager doesn't show correct figures for awe.

  User perfmon to...

... By default SQL Server 2005 will generate a 512 bit certificate for this purpose....

Can you point to a reference conferming this ?

any luck with forcing all connections to be encrypted ?

I'm still able to connect without encryption; our sniffer shows the querytext-dump very nice readable.

the strange thing is that if I install a SSL-cert at serverside (logged on using the sqlserver service account)

and I only enable TCP/IP and set the SQNNC-properties to only...

Hi Brian,

Did you ever get this to work ?

- start a sqlprofiler trace and examine the results

- maybe this can point you in a direction

(I don't know from where I got it , but it shows who is...

the scripts are unavailable.

Nice article.

...,

case [new] when -1 then 'NEW'

                            else ''

       end AS NewContract,

case [new] when 'Yes' then [rep name] else '' end  AS RepName2,  ....

There's a little inconcistency in the csv.

data for build 9.00.1532 isn't in the same layout as the other ones ! 

(the URL position has shifted...

Maybe not.

We don't have that many access-apps linked to other engines.

I certainly didn't try that path.

a database consists of at least one filegroup (called PRIMARY).

- a filegroup is a "container" for db-files.

- If you want to put your "on the fly" tables in the...