i do that :

ALTER DATABASE Aloes_dev SET ANSI_NULLS ON,

ANSI_PADDING ON,

ANSI_WARNINGS ON,

ARITHABORT ON,

CONCAT_NULL_YIELDS_NULL ON,

QUOTED_IDENTIFIER ON,

NUMERIC_ROUNDABORT OFF;

now, i hope their is no problems on the dev...

i change the settings tomorrow on the test database and i will look if any problems appear.

Thanks for your time spend...

Yann.

hello,

the screen said this

[Recommended Settings] ON ON ON ON ON ON OFF -

aloes_dev OFF OFF OFF OFF OFF OFF OFF Failed

ok, i change the settings.

(-)Database SQL Options Database Administration Rule Information

Score Result Friendly Name Description

Non Compliance (local)\Aloes_dev One or more databases failed the scan. Database SQL Options should be configured as...

thanks for your answer. I do that tomorow at work.

could you say me what is the "upgrade documents" ?

for obtain this result, i use the best practice analyser 2000 who said what problems have your database.

my database aloes setting isn't good. why ? what this parameter can do...

thanks a lot... i look the query plan...

hello,

you say "Red nodes need work on" but i dont understand what you want to say. I dont speak american fluently. could you translate on a second answer ?

Yann.

ok, i look tomorrow. thanks

thanks for your works...

I'm sorry, that's true the database is smaller than 1 gigaoctet, so that's not a problem of memory!

how can i test the need in memory ? with sql profiler ? with RML Utility for sql server ?

we have only 2 simultaneous users, some sql transaction can...

this code :

bulk insert myTable from 'C:\file.txt' with (FIELDTERMINATOR = '|');

works on my serveur sql serveur 2005 sp2 french edition developper:)

Sorry for my english...

A developper must work on developpement database. that's the best security.

A script developped by a developper must be passed on a pre-production database by the dba. if...