:w00t: hey!...

I'm following the given business specs here, look how they read: "...if recods are equal between 2 tables not to insert, only insert records that are not in...

... how about something like this?

insert into table2

select * from table1

except

select * from table2

I...

Not sure if I follow.

Are you referring to rows that match the predicate vs. rows that do not match the predicate of a given query?

:w00t: ... got it, you are kidding 😀

The one index per column solution, better saying one bitmap index per dimension key column on fact tables is a fairly accepted, pretty useful solution for Oracle data warehouse environments...

Well, that's the problem - poster never asked about instructions or tools to make a conversion. Poster knows how to do it.

Poster clearly asked if it was possible to do...

Oh boy; what you say holds true but you have never even attempted to answer the poster's question. 😀 You just keep randombly answering questions you make up in...

Okay -this is gonna be my last posting on this matter.

Let me copy/paste poster's questions...

1. Is there a way to modify the converted procedures?

2. Is there way to keep...

Have you created any user tables?

According to your scenario you just created an empty database.

... or perhaps SQL Server got confused because of "defulat" account? 😛

I think you may have overlooked the part where poster says: Is there a way to modify the converted procedures?

In my book that means poster has two versions of...

Your backup logic should look like:

Step #1

Take Backup

On success go to Step #2

On failure send alert and abort!

Step #2

Delete old backup files...

Gift Peddie (4/20/2009)

---

That depends on the platform...

Has the user recently changed his/her password?

Gift Peddie (4/15/2009)

---

It will be easier to move the application to 10g RC2 and then to 2005 because both are easy to integrate with limited issues, while 9i will require...