Let me give you the real view:

ALTER view [dbo].[V_SMPN_CONTRIBUINTES]

as

select

a.NIF+isnull(filial_number,'') as NIF,a.COD_MET_TRIBUTARIO,a.NOME,a.STATUS,a.COD_PROVINCIA,

a.COD_REP_FISCAL,null as cod_enquadramento,null as Tipo_Empresa,null as dt_constituicao,null as num_dr,null as dt_dr,

null as...

create view test

as

Select a.nome,null as morada from table1 as a

union

select b.nome, b.morada from table2 as b

union

select c.nome, null as morada from table3 as

Here it is

Sorry, didn't undestood your question.

I have created a maintenance plan with two sub plans (each subplan is a job).

When i click in the Maintenance plan name i can not script...

Did Microsoft allready told when it will release the sql denali ?

Sorry i didn't read the message well.

The version is developer edition and in production we have enterprise

It's SQL2005. But the option is there.... How can not support if the check box is there?

I can not make backups has mentioned.

People are not working, is there a problem in rebuilding all the indexes instead of just one?

thanks.

can there be down time, aka maintenace mode..where the servers are unavailable?

yes, if for a small amout of time

yes. that is correct.

But i think that even if i had replication the same thing would happen, correct?

In that case i think i will do an app in .NET taht exports XML between the two databases...

Yes, they are made in both locations.

There is no internet.

"can they be reconsiled at the end of the day" , Yes they can.

500 MB of size

didn't undestood your answer 🙂

Maybe in my case it is not necessary.

This is the problem:

I have created a table named TempImport which imports data using bulk insert.

This TempImport is an empty table and every...

Ok, thank you.

So, in my case what would you do?

Would you let the databases stay in simple recovery model and make regular differencial backups or would you change it to...