Well, You are talking about stand by servers indeed. where servers provided with the backups or logs are read only servers.

My problem actually requires merge replication, where two machines are...

I am trying to write the changes made to a database into a file and update another remote database with such changes.

Kelly suggested to set up auditing via triggers which...

Thanks every one ...

Is there any way to read and use this log using t-sql . For instance like exporting the changes into an external file?

Thanks Site Owner

Actually, The thing that I find strange is that the server can distinguish which transactions where made and when as it is the case with the defferentional backup!...

Believe me, I got more dazzled with this discussion.

I still cannot decide what to do.

Having one lookup table will help me having less code on the application side.

The pros for...

Well Frank,

I already have an appplication which has each of clients and vendors apart.

But I had to have an account code for each of them in the chart of accounts....

It could log into the server but could not enumrate the databases!

Thanks Vasanth

I read that having unncessary indexes would actual criple the database performance.

What do suggest for the optimal use of indexes?

Also , Can you please explain the use of cursortypes and locking in ado and if it can explain in this case

Thanks

I am using vb6 with ado

I was used to use addnew with a recordset

but so I will use somthing like

"insert into dbo_invoice (invoice_id, invoice_date) select max(invoice_id)+1 as new_id,...

Thanks Sam

Well, that's a good suggestion.

I suspected a piece of my delete function which could have deleted the first record not the one meant to be delelted.

But I recognized...

Thanks Paul

Well I guess this is what I am about to do .

I tried to change the sa password once but I...