I never use views, I will read some and see if it fits.

All the answers are consistent in that we have to add columns at the end-

I thinked that I...

Thanks for reply.

Yes we have indexes (32) and table partition.

That was what I want to know. So if you said that is normal, I will be a little quiet.

But I...

Thanks both for reply.

When use ALTER TABLE command I don't have the chance to select the position of the column (like mysql)

For out framework is not strictly necessary the order...

thanks for reply.

The reason for adding in an especific position is that we have a framework made by us, that needs certains fields in certains positions to work properly.

I know...

Thansk for reply so quicky!!

Yes, the performance of all apps running on the server are affected.

We have SQL Server, and an old legacy system using fox pro 2.6 and dbfs....

Thanks for reply.

If there is other app consuming memory, there is other way to figure out which app is (not using taskmanager)

Sorry for the rookie question, I'm not an Windows...

Thanks for reply.

Yes we need 12GB becouse the server is not dedicated tio SQL, it has our two bussiness apps running.

And if I put all memory to sql server the...

Hi, please share what you have-

Thansks!

Thanks right now i'm reading the article.

Thanks for help me!!!!

Thanks for reply.

I tested save transaction for an hour an I cant get what I want.

I'll do a workaround using a old fox table that is not transactionable, and insert...

Thanks Marco, but I don't need data sync I only need Structure sync, because we distribute our app to another company.

Thanks for reply.

Steve, thanks to you too.

We are going to...

Thanks for reply

logship or mirror the databases

I have to read about it, because I dont understant how it works and don't know if it will help with my problem....

steveb. (2/22/2011)

---

not sure, ...

Thanks for reply.

I don't need data compare. I'll try this tool.

Do you know if I can integrate with an installer o something like this?

Craig Farrell (10/5/2010)

---

gheinze (10/5/2010)

---

Thanks to all. You were helpfull to me to understand a lot of things about locks.

Now I will test on my production system and check how it...