- 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...

I think you should just refresh the linked tables in access and "ask for a new location".

This way you can point to the new server and fill out the correct...

Maybe it's a good idea to put your "on the fly" tables in separate (huge) filegroup(s) on fast spindles.

maybe this should be added :

If "legacy" is the only reason for the msde to live, migrate the databases to your sqlservers instance.

If the servicelevels of both instances match, and...