yes for each quad core cpu you have to allocate 4 GB ....

in general 4Gb RAM for each CPU

I have to insert into a excel file the questions and question pool level (which come from alttext colum -@1-.@2-,@3-.@4-.@5-)

questionID Question Pool Level 1 Question...

Hi again,

I hope now the data are in requested format...

create table #questions1 (questionID int,structureId int)

insert into #questions1

SELECT '814','35' UNION ALL

SELECT '815','37' UNION ALL

SELECT '838','136' UNION ALL

SELECT '840','1191' UNION...

Table questiions sample data

questionIDstructureID

81435

81537

838136

8401191

8411191

8421191

843155

845155

846155

8471237

81838

81938

82032

82238

82340

82441

82641

82742

Table Structure

structureIDTEXtaltText

1090AMC M.A.202 - Occurence reporting@5-

1091Subpart C - Continuing Airworthiness@4-

1092AMC M.A.301 - Continuing airworthiness tasks@5-

1093AMC M.A.302 - Maintenance programme@5-

1095AMC...

Hello,

I cannot change the date type in access,because it(access) dont allow me. I was thinking about date type supported by access.

Best Regards,

Hadrian

Hello ,

My concerrn is that it comes from Oracle and I want to rewrite for MSSQL 2008.

Thanks for interesting AWE issues.

If I use only 3.5Gb for an instance with AWE enabled for it , could I leave the second without AWE?

so for 8GB RAM installed I choose for each of the twon instances 3.5Gb,in total 7 GB remains 1 GB for Windows, AWE enabled.It is the right...

yes you are right the instances are not configurated with AWE because I was thinking that AWE is for > 4GB and I choose only 3.5GB.

anyway If I eanble AWE...

it's 32 bit

first I configurated AWE but because I put only 3.5 GB for each instance I disable AWE.

rhe witness must be on a separate computer not the two involved in mirror direct

Thanks Brian!

or use linked server also in BOL

check Books Online